reporting services - RDLC filtering nested tables -


I am creating an RDLC report where there are several databases in the dataset, a parent table and several child tables.

What I would like to do is display data relevant to each child's table for each row in the original table.

Here is a simplified example: table1 = "purchase" in the column back case, purchase number, buyet table 2 = "purchased item" column has purchased IitemID, PurhecaseID, ItemDescription

my RDLC I have been grouped on the date of purchase and I would like to display it. Purchase is for every purchase. The current solution uses a subreport, but I do not like it because it leaves an ugly empty place. Patience There is no data for the report display. (I would be fine with using a subreport if I can safely hide it without leaving the blank space.)

I can not re-write the stored procedure to return a table I am

How are other people dealing with this scenario?

I left my dream of Nested Parents with data sources tables Using a subreport to pass a parameter to display and use for filtering.


Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -