report format problem.. database design

jaasaria 0 Junior Poster

15 Years Ago

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

<?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
47 Views

Be the first to reply

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.