hi guyzz.... i wanted to make a report to show the item sold by its months.
here my attachment.. plss see...
how can i make this report using crytal report..?
plsss help
jaasaria 0 Junior Poster
<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<DocumentProperties xmlns="urn:schemas-microsoft-com:office:office">
<Author>jaasaria</Author>
<LastAuthor>jaasaria</LastAuthor>
<Created>2008-12-18T22:07:50Z</Created>
<LastSaved>2008-12-18T22:16:57Z</LastSaved>
<Company>Gates</Company>
<Version>11.6568</Version>
</DocumentProperties>
<ExcelWorkbook xmlns="urn:schemas-microsoft-com:office:excel">
<WindowHeight>9720</WindowHeight>
<WindowWidth>15195</WindowWidth>
<WindowTopX>480</WindowTopX>
<WindowTopY>45</WindowTopY>
<ProtectStructure>False</ProtectStructure>
<ProtectWindows>False</ProtectWindows>
</ExcelWorkbook>
<Styles>
<Style ss:ID="Default" ss:Name="Normal">
<Alignment ss:Vertical="Bottom"/>
<Borders/>
<Font/>
<Interior/>
<NumberFormat/>
<Protection/>
</Style>
<Style ss:ID="s22">
<Alignment ss:Horizontal="Center" ss:Vertical="Bottom"/>
</Style>
</Styles>
<Worksheet ss:Name="Sheet1">
<Table ss:ExpandedColumnCount="14" ss:ExpandedRowCount="7" x:FullColumns="1"
x:FullRows="1">
<Row>
<Cell ss:MergeAcross="5" ss:MergeDown="1" ss:StyleID="s22"><Data
ss:Type="String">table1 </Data></Cell>
<Cell ss:Index="9" ss:MergeAcross="5" ss:MergeDown="1" ss:StyleID="s22"><Data
ss:Type="String">table 2 (all item was been sold)</Data></Cell>
</Row>
<Row ss:Index="4">
<Cell><Data ss:Type="String">item code</Data></Cell>
<Cell><Data ss:Type="String">item name</Data></Cell>
<Cell ss:Index="4"><Data ss:Type="String">qty balance</Data></Cell>
<Cell ss:Index="9"><Data ss:Type="String">january</Data></Cell>
<Cell><Data ss:Type="String">feb</Data></Cell>
<Cell><Data ss:Type="String">march</Data></Cell>
<Cell><Data ss:Type="String">etc</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">43</Data></Cell>
<Cell><Data ss:Type="String">milk</Data></Cell>
<Cell ss:Index="4"><Data ss:Type="Number">89</Data></Cell>
<Cell ss:Index="9"><Data ss:Type="Number">30</Data></Cell>
<Cell><Data ss:Type="Number">34</Data></Cell>
<Cell><Data ss:Type="Number">66</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">44</Data></Cell>
<Cell><Data ss:Type="String">sugar</Data></Cell>
<Cell ss:Index="4"><Data ss:Type="Number">43</Data></Cell>
<Cell ss:Index="9"><Data ss:Type="Number">43</Data></Cell>
<Cell><Data ss:Type="Number">43</Data></Cell>
<Cell><Data ss:Type="Number">43</Data></Cell>
</Row>
<Row>
<Cell><Data ss:Type="Number">45</Data></Cell>
<Cell><Data ss:Type="String">coffee</Data></Cell>
<Cell ss:Index="4"><Data ss:Type="Number">55</Data></Cell>
<Cell ss:Index="9"><Data ss:Type="Number">43</Data></Cell>
<Cell><Data ss:Type="Number">43</Data></Cell>
<Cell><Data ss:Type="Number">53</Data></Cell>
</Row>
</Table>
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<Selected/>
<Panes>
<Pane>
<Number>3</Number>
<ActiveRow>7</ActiveRow>
<ActiveCol>1</ActiveCol>
</Pane>
</Panes>
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet2">
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
<Worksheet ss:Name="Sheet3">
<WorksheetOptions xmlns="urn:schemas-microsoft-com:office:excel">
<ProtectObjects>False</ProtectObjects>
<ProtectScenarios>False</ProtectScenarios>
</WorksheetOptions>
</Worksheet>
</Workbook>- 1 Contributor
- 0 Replies
- 51 Views
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.