reporting services - Remove Duplicates in SSRS Subreport -
i have ssrs report links line item subreport main report order number. when customer orders 2 line items, 2 order numbers come in contact info, etc. in ssrs report, order number shows twice , multiple line items fall below. 1 order number line items following.
as have looks like:
order# contact user 1234 j. smith js1 lineitem qty order date 1 3 05/15/2015 2 2 05/15/2015 order# contact user 1234 j. smith js1 lineitem qty order date 1 3 05/15/2015 2 2 05/15/2015
i tried =fields!lineitem.value =previous(fields!lineitem.value) because dup isn't directly previous didn't work.
but i'd have 1 single result. great.
at bottom of design screen should row groups window. many times, have group created. if right click on , click properties should image below:
thanks.
Comments
Post a Comment