Creating SSRS from 3 BAQs

MelissaC · June 21, 2025, 4:48pm

I have 3 BAQs I added to an RDD and create the new report. My issue is I don’t see 3 datasets in the report, just 2. Missing “TopLevel”. I checked the datasets to see if the data was hiding in one of those but it’s not, just the data from each BAQ.

aosemwengie1 · June 21, 2025, 5:25pm

Show the relationship details

MelissaC · June 21, 2025, 5:52pm

aosemwengie1 · June 21, 2025, 5:58pm

Relation types are not filled in?

MelissaC · June 21, 2025, 7:41pm

As soon as I pick a Parent, the relation type turns grey and I can’t select one, even if I select the type first.

aosemwengie1 · June 21, 2025, 8:41pm

Maybe you just need to add the dataset to your rdl manually?

DaveOlender · June 22, 2025, 12:11pm

I found that if you use BAQ Parameters instead of “Relations” then you will get 3 separate Datasets and you can do the join in the SSRS Select.

DaveO

aosemwengie1 · June 22, 2025, 12:34pm

That’s usually how I do it too, just curious to hear if it can work with the relationships instead.

surendrapal · June 23, 2025, 2:19am

If you make changes after your created RDL file, you should use the Sync Data Set option as follows:

Or

Rename and rdl, and attempt to create new.

MelissaC · June 23, 2025, 12:32pm

Hi,
Should I put the parameters in all 3 BAQs? I have them in the TopLevel BAQ.

DaveOlender · June 23, 2025, 12:44pm

Ms. Melissa: Yes generally all three. It depends on what each baq needs to run and be in Sync with the main BAQ.

DaveO

surendrapal · June 23, 2025, 1:44pm

I am uncertain about the version you are referring to, but in the latest version I tested, the parameter for the top-level BAQ will be sufficient, and you do not need to repeat the same parameter for each BAQ. However, if you have a correct data relation setup.

utaylor · June 23, 2025, 3:19pm

Interesting thread, never tried to join the datasets from there.

surendrapal · June 23, 2025, 4:48pm

Steps to Create a Report (Example)

Step 1: Define the BAQs

OrderHeader: Top-level BAQ with Parameter OrderNum
OrderDetails: Second-level BAQ
OrderRelease: Third-level BAQ

Step 2: Create the Report Data Definition

Name: OrderDetails
Data Source: All three BAQs defined above

image1970×1058 114 KB

Step 3: Establish Data Relationships

OrderHeader to OrderDetails: One-to-many relationship

image1960×1174 122 KB
OrderDetails to OrderRelease: One-to-many relationship

image1962×1144 124 KB

Step 4: Add the following criteria to the set Filter:

Step 5: Create the Report Style as shown below

Step 6: Open the RDL file in Report Designer as shown below

Step 7: Added the report to the menu

Step 8: Tested the report and verified that it functions as expected

Step 9: Check the report data in database and it generated only filtered data

utaylor · June 23, 2025, 5:53pm

Wow, thanks for the write up, I will have to try this out.

MelissaC · June 24, 2025, 7:43pm

This is awesome and has gotten me closer than ever!! I’ve gotten my data down to 2 BAQs, both of which return the information I’m looking for. When I open the SSRS I can see all the fields I need from both BAQs. However, when I print preview the report I don’t get any data. It renders and I can see the labels but not the data.

utaylor · June 25, 2025, 12:00pm

Do you see the datasets for each of the BAQs in the .rdl?

MelissaC · June 25, 2025, 3:29pm

They are all under 1 dataset but those are the fields from both BAQs.

DaveOlender · June 25, 2025, 3:49pm

Ms. Melissa: double check that your tablix is set to use the correct dataset.
Click in the tablix area and then click on the small sqare in the Upper left.
Then check to make sure the Dataset property is set to your KitInOut Dataset.

MelissaC · June 28, 2025, 3:03pm

Thanks. I checked and it is in the tablix parameters. I decided to put all the fields on the report to see if any data was coming through. It looks like the secondary data from the UD10 table is pulling correctly, but not the top level data.

The partlot_partnum and partlot_lotnum are what I am entering as filters for the report.