I have created 2 separate BAQ reports with BAQ Report Designer. These use completely different BAQs. I am trying to use one of them as a subreport and am having some difficulty. The only parameter on either report at the moment is the usual TableGuid one. If I hardcode the Guid (from the preview in the system monitor) in the subreport options > Parameters everything works fine. This is obviously not a solution though as a hardcoded Guid means the Subreport will never change. What step am I missing to get this parameter passed to the subreport each time the report is viewed?
In order to get the “outer” BAQ report to run, you’d have to first run the “inner” one. So your users would have to run both two BAQ reports (and in the correct order.
You might be able to get the GUID of the inner one from the systask tables. But I’d really suggest trying to make this use a single BAQ. Or make the sub-report not be based on a BAQ, but rather a plain SSRS report, and build its Dataset Query right in the report.
2 Likes