Need help or suggestions please

Hello,

I have been struggling with this and would appreciate if anyone can guide me here.

I am getting a resultset from a database and I need to present it in a particular format. I tried creating the report with iReport and it is not loading up even in the preview. I dont know what I am doing wrong.

 

The resultset I am getting is of the following format

<Details>

     <Company>

          <Name> Intel </Name>

          <ID> 2356 </ID>

          <City>Santa Clara </City>

          <State> California </State>

     </Company>

     <Financials>

          <Cash>2345</Cash>

          <Liability>9876</Liability>

          <Assets>457847</Assets>

     </Financials>

     <Profile>

          <Employees>44459</Employees>

          <Industry>computer</Industry>

     </Profile>

     <Year>2009</Year>

     </Company>

     <Company>

          <Name> Intel </Name>

           <ID> 2356 </ID>

          <City>Santa Clara  </City>

          <State> California </State>

      </Company>

     <Financials>

           <Cash>4857</Cash>

           <Liability>8769</Liability>

           <Assets>36456</Assets>

     </Financials>

      <Profile>

           <Employees>56489</Employees>

           <Industry>computer</Industry>

     </Profile>

      <Year>2010</Year>

     </Company>

     <Company>

          <Name> IBM  </Name>

          <ID> 2356 </ID>

           <City>Santa Clara </City>

          <State>  California </State>

     </Company>

      <Financials>

          <Cash>2345</Cash>

           <Liability>9876</Liability>

           <Assets>457847</Assets>

     </Financials>

      <Profile>

           <Employees>44459</Employees>

           <Industry>computer</Industry>

     </Profile>

      <Year>2009</Year>

     </Company>

     <Company>

          <Name> IBM </Name>

           <ID> 2356 </ID>

          <City>Santa Clara  </City>

          <State> California </State>

      </Company>

     <Financials>

           <Cash>4857</Cash>

           <Liability>8769</Liability>

           <Assets>36456</Assets>

     </Financials>

      <Profile>

           <Employees>56489</Employees>

           <Industry>computer</Industry>

     </Profile>

      <Year>2010</Year>

     </Company>

</Details>

 

The output needs to of the below


Intel IBM
  2009 2010 2009 2010
         
Financials        
  Cash 58748 456476 4657846 456740
  Liability 564756 343545 857898 98798
  Assets 35455 87990 34535 789787
Profile        
  Employees 634536 67886 87668 95688
  Industry Computers Computers Computers Computers
ID 2356 67678
City Santa Clara San Jose
State California California

 

yesmein's picture
Joined: Mar 31 2010 - 3:20am
Last seen: 13 years 6 months ago

0 Answers:

No answers yet
Feedback