Hello awesome community!
I want to develop a report that looks like this:
It's about showing purchase orders but if the PurchLines have multiple different cost centers, the cost center field will split into multiple rows.
So I did that by inserting a table inside the tablix of Cost Center and I grouped it with Cost Center Values while the big base table is grouped by PurchID.
My issue is I get an extra blank row for the mini table of Cost Center at the end of cost centers
Here is a screenshot:
Sorry for the extensive censor lol.
As you can see in the "Cost Center" Column, it splits but it always gives a blank row.
I don't know if it's a blank row or an empty space, because I tried using row visibility option hiding the row based on the following expression:
"IIF(ReportItems!CostCenterField.Value = "", True, False)" but it didn't help.
How can I remove these blank rows or empty spaces?
Thanks in advance!
