BI Publisher pass variable to sub template for each record

Question

Summary

Content

Hi All,

I have a main report rtf template and query that lists projects. I need to add a sub template that then gets engineer names from a different record depending on what the Project ID is in the main template.

How do I pass the project id from the main rtf template  to the sub template?

Main RTF

Project 1 ID

Sub RTF - Engineer Name based on Project ID

Project 2 ID

Sub RTF - Engineer Name based on Project 2 ID

Project 3 ID

Sub RTF - Engineer Name based on Project 3 ID

etc...

Thanks,

John

Dir_Pal · Answer

Follow this doc which might help you

https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-43E24DE3-F1DE-47E1-8B2F-C8ED59D619BA.htm#BIPRD3064

Venkat Thota - BIP · Answer

Try these Links https://blogs.oracle.com/xmlpublisher/formatting-concatenated-datasources https://docs.oracle.com/cd/E21764_01/bi.1111/e18862/T527073T558188.htm

John Bruso1 · Answer

Hi Venkat,

Yes, the main template has 1 data source (Projects) and the sub template has a different data source (Engineers). Project ID is the common value between the two. Is this possible within BI Publisher or do I need to figure out a way to connect the data within Peoplesoft into 1 query?

Thanks!

John