I just have one Question.
in SSRS while we use the locally embedded in the report definition file ( the SSRS rdl ) What should be the XML Coding Format. Below has some example Type.1 and Type.2 plz go through it once.
I don't have much idea abt XML coding so Please suggest
Type.1:-
<Query>
<XmlData>
<Company>
<SS Sold-to-BP="BP0009983">
<Sold-to-Name>MRC GLOBAL (FINLAND) OY</Sold-to-Name>
<Sold-Addr-City>VANTAA</Sold-Addr-City>
<Sold-State></Sold-State>
<Sold-Addr-Country>FI</Sold-Addr-Country>
<Invoice-Month>Mar</Invoice-Month>
<Invoice-Date>2015-03-16</Invoice-Date>
<Net-Line-Amount>6903.54</Net-Line-Amount>
<Inv-Curr>EUR</Inv-Curr>
<Inv-Amnt-EUR>6903.54</Inv-Amnt-EUR>
<Inv-Amnt-USD>7750.69</Inv-Amnt-USD>
</SS>
<SS Sold-to-BP="BP0009983">
<Sold-to-Name>MRC GLOBAL (FINLAND) OY</Sold-to-Name>
<Sold-Addr-City>VANTAA</Sold-Addr-City>
<Sold-State></Sold-State>
<Sold-Addr-Country>FI</Sold-Addr-Country>
<Invoice-Month>Mar</Invoice-Month>
<Invoice-Date>2015-03-16</Invoice-Date>
<Net-Line-Amount>2046.15</Net-Line-Amount>
<Inv-Curr>EUR</Inv-Curr>
<Inv-Amnt-EUR>2046.15</Inv-Amnt-EUR>
<Inv-Amnt-USD>2297.24</Inv-Amnt-USD>
</SS>
</Company>
</XmlData>
</Query>
Type.2:-
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns="urn:schemas-microsoft-com:office:spreadsheet">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>Krushna Meher</Author>
<LastAuthor>Krushna Meher</LastAuthor>
<Created>2017-03-16T01:04:59Z</Created>
<LastSaved>2017-03-16T01:04:59Z</LastSaved>
<Version>16.00</Version>
</DocumentProperties>
<OfficeDocumentSettings xmlns="urn:schemas-microsoft-com:office:office">
<AllowPNG/>
</OfficeDocumentSettings>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>3870</WindowHeight>
<WindowWidth>20340</WindowWidth>
<WindowTopX>0</WindowTopX>
<WindowTopY>0</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:Name="Normal" ss:ID="Default">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font ss:FontName="Arial"/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s62">
<Font ss:FontName="Courier New" ss:Size="9" x:Family="Modern"/>
<NumberFormat ss:Format="@"/>
</Style>
<Style ss:ID="s63">
<Font ss:FontName="Courier New" ss:Size="9" x:Family="Modern"/>
<NumberFormat ss:Format="#0"/>
</Style>
<Style ss:ID="s64">
<Font ss:FontName="Courier New" ss:Size="9" x:Family="Modern"/>
<NumberFormat ss:Format="yyyy\-mm\-dd;yyyy\-mm\-dd;"/>
</Style>
<Style ss:ID="s65">
<Font ss:FontName="Courier New" ss:Size="9" x:Family="Modern"/>
<NumberFormat ss:Format="0.0000;[Red]\-0.0000;"/>
</Style>
</Styles>
<Worksheet ss:Name="Opn SlsOdr-Cost Itm_1">
<Table ss:DefaultRowHeight="12.9375" ss:StyleID="s62" x:FullRows="1" x:FullColumns="1" ss:ExpandedRowCount="3" ss:ExpandedColumnCount="17">
<Column ss:StyleID="s62" ss:Width="56.25"/>
<Column ss:StyleID="s63" ss:Width="39"/>
<Column ss:StyleID="s62" ss:Width="61.5"/>
<Column ss:StyleID="s63" ss:Width="45"/>
<Column ss:StyleID="s62" ss:Width="78.75"/>
<Column ss:StyleID="s62" ss:Width="11.25"/>
<Column ss:StyleID="s64" ss:Width="67.5"/>
<Column ss:StyleID="s62" ss:Width="263.25"/>
<Column ss:StyleID="s62" ss:Width="39" ss:Span="1"/>
<Column ss:StyleID="s62" ss:Width="78.75" ss:Span="1" ss:Index="11"/>
<Column ss:StyleID="s65" ss:Width="50.25" ss:Index="13"/>
<Column ss:StyleID="s65" ss:Width="72.75"/>
<Column ss:StyleID="s65" ss:Width="61.5"/>
<Column ss:StyleID="s65" ss:Width="106.5" ss:Span="1"/>
<Row ss:AutoFitHeight="0">
<Cell>
<Data ss:Type="String">Order Type</Data>
</Cell>
<Cell>
<Data ss:Type="String">Company</Data>
</Cell>
<Cell>
<Data ss:Type="String">Sales Order</Data>
</Cell>
<Cell>
<Data ss:Type="String">Position</Data>
</Cell>
<Cell>
<Data ss:Type="String">Cust Ord Line#</Data>
</Cell>
<Cell>
<Data ss:Type="String">QL</Data>
</Cell>
<Cell>
<Data ss:Type="String">Promise Date</Data>
</Cell>
<Cell>
<Data ss:Type="String">Item</Data>
</Cell>
<Cell>
<Data ss:Type="String">BP Code</Data>
</Cell>
<Cell>
<Data ss:Type="String">BP Name</Data>
</Cell>
<Cell>
<Data ss:Type="String">Sales Rep Code</Data>
</Cell>
<Cell>
<Data ss:Type="String">Sales Rep Name</Data>
</Cell>
<Cell>
<Data ss:Type="String">Order Qty</Data>
</Cell>
<Cell>
<Data ss:Type="String">Delivered Qty</Data>
</Cell>
<Cell>
<Data ss:Type="String">Balance Qty</Data>
</Cell>
<Cell>
<Data ss:Type="String">Price</Data>
</Cell>
<Cell>
<Data ss:Type="String">Amount</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell>
<Data ss:Type="String">SLS</Data>
</Cell>
<Cell>
<Data ss:Type="Number">240</Data>
</Cell>
<Cell>
<Data ss:Type="String">SO0000065</Data>
</Cell>
<Cell>
<Data ss:Type="Number">1</Data>
</Cell>
<Cell>
<Data ss:Type="String">1</Data>
</Cell>
<Cell>
<Data ss:Type="String"/>
</Cell>
<Cell>
<Data ss:Type="DateTime">2015-05-15T00:00:00.000</Data>
</Cell>
<Cell>
<Data ss:Type="String">ZS240-SCRAP</Data>
</Cell>
<Cell>
<Data ss:Type="String">BP0005025</Data>
</Cell>
<Cell>
<Data ss:Type="String">SANDVIK ESPA›¼ÑOLA, S.A.</Data>
</Cell>
<Cell>
<Data ss:Type="String">240140</Data>
</Cell>
<Cell>
<Data ss:Type="String">Mariana Mouta</Data>
</Cell>
<Cell>
<Data ss:Type="Number">20.68</Data>
</Cell>
<Cell>
<Data ss:Type="Number">21</Data>
</Cell>
<Cell>
<Data ss:Type="Number">-0.32</Data>
</Cell>
<Cell>
<Data ss:Type="Number">20.5</Data>
</Cell>
<Cell>
<Data ss:Type="Number">-6.56</Data>
</Cell>
</Row>
<Row ss:AutoFitHeight="0">
<Cell>
<Data ss:Type="String">SLS</Data>
</Cell>
<Cell>
<Data ss:Type="Number">240</Data>
</Cell>
<Cell>
<Data ss:Type="String">SO0000172</Data>
</Cell>
<Cell>
<Data ss:Type="Number">905</Data>
</Cell>
<Cell>
<Data ss:Type="String">905</Data>
</Cell>
<Cell>
<Data ss:Type="String"/>
</Cell>
<Cell>
<Data ss:Type="DateTime">2016-08-31T00:00:00.000</Data>
</Cell>
<Cell>
<Data ss:Type="String">ZS240-PACKING CHARGE</Data>
</Cell>
<Cell>
<Data ss:Type="String">BP0006606</Data>
</Cell>
<Cell>
<Data ss:Type="String">HEATON VALVES AFRICA</Data>
</Cell>
<Cell>
<Data ss:Type="String">240140</Data>
</Cell>
<Cell>
<Data ss:Type="String">Mariana Mouta</Data>
</Cell>
<Cell>
<Data ss:Type="Number">1</Data>
</Cell>
<Cell>
<Data ss:Type="Number">0</Data>
</Cell>
<Cell>
<Data ss:Type="Number">1</Data>
</Cell>
<Cell>
<Data ss:Type="Number">691.02</Data>
</Cell>
<Cell>
<Data ss:Type="Number">691.02</Data>
</Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<PageSetup>
<Header x:Margin="0.3"/>
<Footer x:Margin="0.3"/>
<PageMargins x:Top="0.75" x:Right="0.7" x:Left="0.7" x:Bottom="0.75"/>
</PageSetup>
<Unsynced/>
<Selected/>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>
Thanks,
Krushna
