Does anyone have issues with using a BAQ report as a subreport of another BAQ Report?
Did you ever get this to work? I’m trying to use an External BAQ as a subreport in SSRS. I think an External BAQ would behave the same as a regular BAQ but I can’t seem to get BAQ Reports to be used as a subquery report in my main BAQ Report.
Is your external BAQ in your report data definition?
There is no report data definition since the external BAQ is the data definition. Or where are you referring to the report data definition? I did create a BAQ Report using the external BAQ. Then the main report references that subreport created from the external BAQ.
It has been a minute since I have used an external BAQ and an external BAQ report, but can you confirm that the ssrs report (.rdl) isn’t querying the SSRS database in the BAQ report?
Look at what the SSRS report is querying to get its data.
I don’t understand what you mean when you say I have a subreport created from the external BAQ.
It’s basically the same question as your original question “using a BAQ report as a subreport of another BAQ Report”. The workaround is to query directly to the database instead of the BAQ subreport.
The datasource in the SSRS report is using the sql server connection in my workaround but was wondering how to use the BAQ report as the subreport datasource.
1 Like
Yeah, I don’t think you can use it as a subreport unless the BAQ is a table in the report data definition.