Jump to content
Changes to the Jaspersoft community edition download ×

Having More Than One SQL Query in One Report


2006 IR Open Dicussion

Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...