Click here to Skip to main content
15,867,704 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi
i use JOIN from my dataset Query SO some of fields data is duplicate
and i use that Duplicate fields in table of report viewer . how can i hide Duplicates in table of Report viewer(RDLC)?

Thank you
Posted
Updated 27-Jul-18 10:45am

i found it

click on Cell of you want Hide duplicates and in properties Set "Hide Duplicates" Property
 
Share this answer
 
Comments
RaviRanjanKr 8-Jan-12 16:51pm    
A suggestion :- you can use Have a question or Comment button to drop your message and to get Immediate response instead of posting as answer.
If your data doesn't contain duplicate values in all columns, consider using grouping in your report. See:
- Grouping Data in a ReportViewer Report [^]
- Adding Table Data Regions [^]
 
Share this answer
 
Comments
synctor 8-Jan-12 12:00pm    
thanks
Wendelius 8-Jan-12 12:13pm    
You're welcome :)
You can use distinct. Check out the link for more info:
http://office.microsoft.com/en-us/access-help/all-distinct-distinctrow-top-predicates-HA001231351.aspx[^]

Good luck!
 
Share this answer
 
Comments
synctor 8-Jan-12 11:52am    
No i dont want handle Query ! just i want know how can hide duplicates in Table of Report viewer ,
indeed my Record is not duplicate ! Distinct dont work for it ! Just my 1 Column is Duplicate , and i use it in Table
E.F. Nijboer 8-Jan-12 15:19pm    
Ah ok, didn't got that ;-)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900