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!

Merging 2 BI Publisher RTF Reports, passing parameters to 1

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

Summary

How to pass parameters to an ExecXmlpReport function

Content

Hi All, I found this code to merge 2 BIP reports into 1. It works great for 2 separate reports with 2 separate data sources. Below I am combining WYES001 and WYES001A into a merged pdf report. However, one of my BIP reports requires a parameter.

I am trying to pass the parameter SIC_CODE . 

It's not clear from this reference how the parameters from the Query get passed to the XML file. 

Reference:
https://docs.oracle.com/cd/E41633_01/pt853pbh1/eng/pt/txml/task_RunningReportsUsingPeopleCode-4f7f77.html

I've tried...

     /* fill query runtime prompt record */

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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