Having More Than One SQL Query in One Report

[2006 IR Open Dicussion]

By: ryan - ryankee

Having More Than One SQL Query in One Report

2006-04-10 04:11

Hi,

 

May I know how can i have more than one SQL query (querying different tables) in the same report? Must I creat subreport to do it, or can i declare some sort of variable or parameter and being it into the report. Can any one kindly show me an example of how this can be done...i'm new to iReports.

 

Thanks

Ryan

 

 

 

 

By: venkat - venkat1201

RE: Having More Than One SQL Query in One Report

2006-04-11 21:08

Hello,

 

u'r problem will be solved by using the pl/sql procedure's.u can call procedures directly in the ireport.

 

regards

venkat

 

 

 

 

By: Javy Dreamer - javydreamercsw

RE: Having More Than One SQL Query in One Report

2006-04-12 04:51

You can use data from different tables using one single query. Look the net for joins for example.

 

Or use something like this:

 

select field1, (select field2 from table2) from table1

 

This will bring field1 and field 2 from different tables in the result.

 

Procedures are indeed an option but are way more advanced than SQL.

 

Good luck.