Using another report with different RDD as a subreport

We are trying to pull the Substance Restriction information onto the Packing Slip. There is already a pretty good Part Compliance report, so I’m trying to see if I can just put that in the Packing Slip as a subreport. I’m getting the “Subreport cannot be shown” error, and though I will continue futzing with the parameters, just wanted to see if anyone had attempted this before or if it will even work.

The way RDD based reports work is that the RDD generates a temporary dataset consisting of tables with a suffix (the GUID) tacked on to their name. When the report tries to render, it reads that dataset. Subreports are passed the GUID from the main report. If you tried to use an existing RDD based report as a subreport, the tables needed for that sub wouldn’t exist.

Unless you need the magic of the RDD, I’d suggest you make a subreport from scratch, linking it directly to the DB, bypassing the temp dataset with the GUID.

1 Like

Okay, thanks for the explanation. I will try and get it to work as a subreport.