none
SSRS RRS feed

  • Question

  • 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

    Monday, April 24, 2017 7:07 AM