Is it possible to have the main report be a BAQReport and a subreport a different BAQReport? When I set up the subreport connection parameters on the main report, it still renders it as not able to display the subreport. I’m trying to not have to create a direct db connection with a new dataset as the subreport but instead use a BAQReport.
Have you tried test running the sub report independently with the Table guid and known good additional parameters? if so what was the error their?
The subreport runs independently correctly but when I run the main report the error displays “subreport cannot be displayed”. I checked the parameters on the subreport in the main report but still not displaying. Has this been tried before and worked with a BAQReport as a subreport of a main BAQReport?
If the sub report is running independently, then it sounds like your issue is related to margins/page size. Make sure your subreport page dimensions are smaller than you parent subreport object’s size. Double check the margins as well. Assuming you pass your parameters correctly then there should be no problem.
I’m running into the same issue, has anyone been able to solve this? Thanks, 
How are you linking the subreport? It might be an issue if the subreport is pointed to the incorrect location.
I’m connecting the SubReport through a parameter. One thing I didn’t mention in my previous response is I’m working in a SaaS environment. I don’t know if that makes a difference here but the main report works just fine, its only the SubReport that’s giving me an issue.
Did you ever get this to work? Is the subreport a BAQReport?
Yeah I did, I ended up having to use RDD (Report Data Definition) with multiple BAQ’s. I then downloaded the rdl file and made two copies of it and renamed them SubReport1, SubReport2. On the original rdl you can then insert the subreports using the newly named copies.
That was the only way I found possible in a SaaS environment.
Does your subreport include the parameters for TableGuid also?
Yeah it did. Since the sub report was a copy, I was able to use the same TableGuid as the main report with no issues.
I think I’m running into the issue where the main report is a BAQReport and then the subreport is also a BAQReport. Is your setup the same with using all BAQReports?
I had to build it in RDD instead of BAQReport to get it to work. I don’t think BAQReport supports SubReports.
I’m still not clear if a main BAQReport supports a SubReport that is a BAQReport also?
BAQ report does not support sub reports. You need to make BAQ based RDD.
Could you clarify how to make a BAQ a based RDD?
It is explained in the link below on this forum.
I read through the link and I thought BAQReports always created a RDD based Report Style from the BAQ? What is the difference in your original comment with a BAQ Report vs. a BAQ based RDD report, I thought they were the same since it creates it in the Report Style as 'Report used by BAQReport…" as the Report ID description. Can a BAQ based RDD support subreports?
The difference is in BAQ report you can only have one BAQ and also it does not support sub reports. In BAQ based RDD you can add as many BAQs as you want and it supports subreports if needed. BAQs can be added any time you want to modify the report and add more information.
Basically, a BAQ report generates one temp table of the results of the BAQ. It also makes 2 or 3 other temp tables to hold things about the report, and are not specific to the data returned by the BAQ. Here’s an RDL for a BAQ report
Examining the query expression of the BAQReportResult dataset shows it pulls from one temp table: BAQReportResult_GUID.
A RDD report (native or BAQ based) can generate multiple datasets. The main report then pulls data from one or more of the tables. Here’s the QuotForm one:
If you look at the properties of the Quote dataset, and examine the query expression, you’ll see that this dataset pulls from several temp tables: QuoteHed_GUID , QuoteDtl_GUID , and QuoteQty_GUID
The QuotForm report uses several sub reports. Examining the datasets for the QuotForm_HeadMiscCharges subreport shows that the Quote RDD also created temp table QuoteLnMsc_GUID.