#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2013
    Posts
    1
    Rep Power
    0

    Oracle Report that should display o/p in two tabs on a same spreadsheet in excel


    Hai,
    I have a report that displays Supplier Requirements (Gross) for the specified number of weeks in 10g. This Supplier Requirements Report (SRR) is displayed in excel format when the job is done through concurrent program. I have a requirement of "displaying gross requirements and netted requirements on a same spreadsheet in two different tabs when I run a concurrent program" where now only gross is displayed. Can someone please help me out how I can do this. Thanks in advance.
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Oct 2013
    Posts
    1
    Rep Power
    0
    Hi,

    I have a solution. I have generated XML output in MS Excel standard.

    I am embedding the xml data in this post.

    -----
    Code:
    <?xml version="1.0"?>
    <?mso-application progid="Excel.Sheet"?>
    <!-- Generated by Oracle Reports version 10.1.2.0.2 -->
    <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="(URL address blocked: See forum rules)"> <Styles>  <Style ss:ID="sColHeader">   <Font ss:FontName="Calibri" x:Family="Swiss" ss:Size="11" ss:Color="#000000" ss:Bold="1"/>   <Interior ss:Color="#D8D8D8" ss:Pattern="Solid"/>   </Style> </Styles>
      <Worksheet ss:Name="Workorder Type">
        <Table ss:DefaultColumnWidth="100"><Column ss:Width="100" /><Column ss:Width="100" />
          <Row>
            <Cell ss:StyleID="sColHeader"><Data ss:Type="String">Department No</Data></Cell>
            <Cell ss:StyleID="sColHeader"><Data ss:Type="String">Department Name</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">10</Data></Cell>
            <Cell><Data ss:Type="String">ACCOUNTING</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">20</Data></Cell>
            <Cell><Data ss:Type="String">RESEARCH</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">30</Data></Cell>
            <Cell><Data ss:Type="String">SALES</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">40</Data></Cell>
            <Cell><Data ss:Type="String">OPERATIONS</Data></Cell>
          </Row>
        </Table>
      </Worksheet>
      <Worksheet ss:Name="Employee Data">
        <Table ss:DefaultColumnWidth="400"><Column ss:Width="100" /><Column ss:Width="100" /><Column ss:Width="100" /><Column ss:Width="100" />
          <Row>
            <Cell ss:StyleID="sColHeader"><Data ss:Type="String">Employee Number</Data></Cell>
            <Cell ss:StyleID="sColHeader"><Data ss:Type="String">Employee Name</Data></Cell>
            <Cell ss:StyleID="sColHeader"><Data ss:Type="String">Department Name</Data></Cell>
            <Cell ss:StyleID="sColHeader"><Data ss:Type="String">Salary</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7369</Data></Cell>
            <Cell><Data ss:Type="String">SMITH</Data></Cell>
            <Cell><Data ss:Type="String">RESEARCH</Data></Cell>
            <Cell><Data ss:Type="Number">800</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7499</Data></Cell>
            <Cell><Data ss:Type="String">ALLEN</Data></Cell>
            <Cell><Data ss:Type="String">SALES</Data></Cell>
            <Cell><Data ss:Type="Number">1600</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7521</Data></Cell>
            <Cell><Data ss:Type="String">WARD</Data></Cell>
            <Cell><Data ss:Type="String">SALES</Data></Cell>
            <Cell><Data ss:Type="Number">1250</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7566</Data></Cell>
            <Cell><Data ss:Type="String">JONES</Data></Cell>
            <Cell><Data ss:Type="String">RESEARCH</Data></Cell>
            <Cell><Data ss:Type="Number">2975</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7654</Data></Cell>
            <Cell><Data ss:Type="String">MARTIN</Data></Cell>
            <Cell><Data ss:Type="String">SALES</Data></Cell>
            <Cell><Data ss:Type="Number">1250</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7698</Data></Cell>
            <Cell><Data ss:Type="String">BLAKE</Data></Cell>
            <Cell><Data ss:Type="String">SALES</Data></Cell>
            <Cell><Data ss:Type="Number">2850</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7782</Data></Cell>
            <Cell><Data ss:Type="String">CLARK</Data></Cell>
            <Cell><Data ss:Type="String">ACCOUNTING</Data></Cell>
            <Cell><Data ss:Type="Number">2450</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7788</Data></Cell>
            <Cell><Data ss:Type="String">SCOTT</Data></Cell>
            <Cell><Data ss:Type="String">RESEARCH</Data></Cell>
            <Cell><Data ss:Type="Number">3000</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7839</Data></Cell>
            <Cell><Data ss:Type="String">KING</Data></Cell>
            <Cell><Data ss:Type="String">ACCOUNTING</Data></Cell>
            <Cell><Data ss:Type="Number">5000</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7844</Data></Cell>
            <Cell><Data ss:Type="String">TURNER</Data></Cell>
            <Cell><Data ss:Type="String">SALES</Data></Cell>
            <Cell><Data ss:Type="Number">1500</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7876</Data></Cell>
            <Cell><Data ss:Type="String">ADAMS</Data></Cell>
            <Cell><Data ss:Type="String">RESEARCH</Data></Cell>
            <Cell><Data ss:Type="Number">1100</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7900</Data></Cell>
            <Cell><Data ss:Type="String">JAMES</Data></Cell>
            <Cell><Data ss:Type="String">SALES</Data></Cell>
            <Cell><Data ss:Type="Number">950</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7902</Data></Cell>
            <Cell><Data ss:Type="String">FORD</Data></Cell>
            <Cell><Data ss:Type="String">RESEARCH</Data></Cell>
            <Cell><Data ss:Type="Number">3000</Data></Cell>
          </Row>
          <Row>
            <Cell><Data ss:Type="Number">7934</Data></Cell>
            <Cell><Data ss:Type="String">MILLER</Data></Cell>
            <Cell><Data ss:Type="String">ACCOUNTING</Data></Cell>
            <Cell><Data ss:Type="Number">1300</Data></Cell>
          </Row>
        </Table>
      </Worksheet>
    </Workbook>

IMN logo majestic logo threadwatch logo seochat tools logo