NAV 2015 RTC report Grouping

ebitas

I created a report off the Sales Cr.Memo Line Table, on the option section of the report the user will indicate how he wants the data to be grouped by (Sell To Customer, Posting Date, or Return Reason Code). I created one dataItem and listed the fields under it. In the code I tell it to use different Sort Key depending on the grouping selection. My issue is with the Layout, how do I specify the grouping there? I'm attaching the layout I have designed hopefully that will help. any ideas?

postsaurav

Hi,

Just an Idea -
1. Set the Group By a Text Variable, in Designer.
2. Set the Text Field Value based on user selection.
3. Fill the field name that you want to group on and pass that as a report parameter.
4. Use that Text Field in the RDLC Group.

Its just an Idea, still need to test.

postsaurav

Hi,

Just an Idea -
1. Set the Group By a Text Variable, in Designer.
2. Set the Text Field Value based on user selection.
3. Fill the field name that you want to group on and pass that as a report parameter.
4. Use that Text Field in the RDLC Group.

Its just an Idea, still need to test.

Belias

I think the better approach in your case is the one suggested by postsaurav, but just for info, conditional grouping is actually possible by setting the grouping expression to something like this:
=Switch(Fields!UserSelection.Value = "Sell-tocustomer",Fields!Selltocustomer.Value,Fields!UserSelection.Value = "PostingDate",Fields!PostingDate.Value)

I hope it's clear enough