I'm having trouble with conditional grouping of a tablix in a NAV RDLC layout.
If the SalesInvoiceLine type is an Item, I want to group based on the No. If the type is something else (general ledger) I don't want to group and just display every line.
The group on expression I'm using is:
=IIf(Fields!Type_SalesInvoiceLine.Value = "Item", Fields!No_SalesInvoiceLine.Value, "")
But this isn't working. Can someone help me find the correct way?