Announcing a new experience for the Oracle Analytics community coming April 4th!
This category will be read-only as we migrate this space from 3/30-4/4, after which you’ll be able to post as usual. See you there!
Multiple data sources ... Passing variables between 2 RTF Templates
Summary
2 Reports in 1 that share variables?Content
Hi all,
I am converting a crystal report that has a subreport to a BI Publisher report made from 2 separate queries.
In the first part of the report is a list of contracts with work type codes.
The second part of the report (The subreport) contains a list of all Work Type codes and the number of contracts that exist for each of these work type codes. The number of contracts per work type code comes from the first part of the report.
In BI Publisher, and PS Query, it is not clear how to pass these Work Type Counts from the 1 report query to the second report query.