Additional SQL Querry in the report
-
- Posts: 1
- Joined: Tue Oct 10, 2017 12:44 pm
Additional SQL Querry in the report
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
R&R is currently limited to a single SELECT per report.____Kathleen__R&R Support
-
- Posts: 17
- Joined: Tue Oct 10, 2017 12:44 pm
==> RE: Additional SQL Querry
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)?