2006 IR Open Dicussion Posted September 5, 2006 Share Posted September 5, 2006 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 More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now