Makes sense with your RDD report that is BAQ based. I do see the RDD with the description “Report used by BAQReport…” with the Report Type ‘SQL Server Reporting’. If an RDD exists for that BAQ, is it a RDD based BAQ report already but I am still seeing the BAReportResult only in the report’s dataset.
If I create the BAQReport through BAQ Report Designer and save it, it automatically creates the Report Style and the RDD. Is this not the correct steps or do we need to manually create it through the Report Style and not through BAQ Report Designer?
BAQ report designer is not use when creating reports from BAQ based RDDs. RDD is created manually by adding the BAQs. Then you create Report Style and link it to the RDD. In the report style under Action you will use “Create SSRS report”. This will create a report in you Custom reports folder on the report server. From thereon it is just like any other SSRS report you can design the way you want it.
Does all the joins in the BAQ come over or do you have to manually re-add those tables into the RDD also and in the Report Builder sql expression? I didn’t see any of the tables in the RDD when I manually added the BAQ.
They will come over. You only add the BAQ in RDD and nothing else. When you go to design the SSRS report you will see all the tables and fields. Each BAQ will appear as a separate Data source.