You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Received Response
edited Sep 11, 2019 5:18AM in Oracle Analytics 1 comment


2 Reports in 1 that share variables?


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.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!