Hide Duplicate value in table(ReportViewer)

Question

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 8-Jan-12 5:42am

synctor

Updated 27-Jul-18 10:45am

Add a Solution

3 solutions

Solution 1

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!

Posted 8-Jan-12 5:47am

E.F. Nijboer

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 ;-)

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wendelius · Accepted Answer · 2012-01-08T05:59:00

Solution 3

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 [^]

Posted 8-Jan-12 5:59am

Wendelius

Comments

synctor 8-Jan-12 12:00pm

thanks

Wendelius 8-Jan-12 12:13pm

You're welcome :)

synctor · Accepted Answer · 2012-01-08T05:59:00

Solution 2

i found it

click on Cell of you want Hide duplicates and in properties Set "Hide Duplicates" Property

Posted 8-Jan-12 5:59am

synctor

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.