Page 1 of 1

Additional SQL Querry in the report

Posted: Wed Jan 23, 2002 1:55 pm
by Bert_L_(Guest)
I am running R&R for Windows, SQL version 9.0 Build 9.0.009. I have an existing report that is working fine. I need to place in the summary, a SQL querry that is independent from the main querry i.e. that looks from a different Oracle table/instance. The SQLEXP() function is limited on functionality. ____Can I do this with your tool or is this a ^wishlist^ for your future release.____My alternative is to use Oracle Report for this requirement since I can create independent querries.____Thanks

=> Additional SQL Querry in the report

Posted: Wed Jan 23, 2002 3:28 pm
by kfleming
R&R is currently limited to a single SELECT per report.____Kathleen__R&R Support

==> RE: Additional SQL Querry

Posted: Tue Jan 29, 2002 4:05 pm
by Owen_Graupman_(Guest)
We do a lot of reports that require summary information from another unrelated table. Maybe you could also solve the problem by doing a multi-scan report (there^s information on how to do this in the Tech Docs area I believe)?