Nested RDLC Filter Tables

Question

I am creating an RDLC report in which a data set consists of several data types. There is one parent table and several child tables.

What I would like to do is display the corresponding data from each child table for each row in the parent table.

Here is a simplified example: table1 = "Purchase" has the columns PurhcaseID, PurchaseNumber, PurchaseDate table2 = "PurchasedItem" has the columns PurchaseItemID, PurhcaseID, ItemDescription

In my RDLC, I have a Purchase table grouped by BuyDate, and you want to display PurchaseedItems for each purchase. The current solution uses a subreport, but I don’t like it because it leaves an ugly empty space when there is no data to display the sub-report. (I would be fine using a subordinate report if I could correctly hide it without leaving empty space.)

I cannot rewrite the stored procedure to return a single table.

How do others relate to this scenario?

Answer 1

. subreport , .