c# - Conditional Grouping in RDLC -
i able conditionally group item in rdlc, i'd option not group anything. i'm not sure on how that.
here's current group expression:
<group name="groupby"> <groupexpressions> <groupexpression>=iif(parameters!groupby.value = "c", fields!city.value, fields!state.value)</groupexpression> </groupexpressions> </group>
i have 3 group options i'd like:
if value "c", group city
if value "s", group state
if value "n", don't group anything
just add statement , if doesn't = c or s group unique id value.
=iif(parameters!groupby.value = "c", fields!city.value, iif(parameters!groupby.value = "s", fields!state.value, fields!someuniquevalueuniquetoallrecords.value))
hope helps.