Need help or suggestions please

[yesmein]

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