I’m working on formatting a new SSRS report to resemble another report the company already has. I’m struggling with nested grids. Below is the example of what is currently being used, would I have to create separate sub reports to replicate this or is there an easier way?
You wouldn’t HAVE to use a subreport. It depends on the all the data you need in your report. If you only need part information, then a list of open POs for them, then you could link the two together, and work around the repeating.
The details section of your tablix would have the fields for all the open POs, then you could group the details section with Part Number. Create a header section with the checkbox. In the header section you could just put this in the expression to pull the part number from the first PO record in that group =First(Fields!PONumber.Value, "PartNumber")
I’ve mocked up what im trying to describe.
Data would look like the following:
If you are new to SSRS, stay away from subreports as much as you can. They are a big performance hit. But sometimes they are your only option when you introduce too much data into the same dataset.
I’m thinking in the context of this particular report I may need a subreport. The report lists multiple Parts based off a given project BAQ, I’m going to guess, being a beginner, the example (@cfinley) you provided would break the Part Number repeat?
I’m trying to replicate the group by you have in the grid, I assume Parent/Child(?), but I’m having trouble. I’ll mess with it a bit more, but I sincerely appreciate the example! It’s quite helpful in figuring out how things work.
This is as far as I’ve been successful with thus far. I try to add a sub group in the Row Groups section as Child, or frankly anything, and I get this error:
I think I must be doing this out of sequence perhaps? Maybe I need to group them in a particular order? I was able to get a group of the entire table, but now I’m having difficulty breaking out the PO group.