Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Multiple data sources ... Passing variables between 2 RTF Templates — Cloud Customer Connect
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

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!