Filtering Duplicate Query results in Report
-
Hello,
I have a query backing my report that returns duplicate records for only some inputs. Instead of filtering within the query (which I have tried by being more specific in my joins, group bys, where statement etc...) I heard that you can filter in The Report Builder. This report needs to only have one record per input.
Example:
AAA
AAA
AAA
BBC
BBD
DDD
I would like the report to return:
AAA
BBC
BBD
DDD
Thank you so much!:-D
-
Well, your query could specify SELECT DISTINCT or a GROUP BY to eliminate duplicates. Also in report you can choose to only show a value once.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
You will have an option called Hide Duplicates in the properties,
but doing something in the query will always be the better alternative.
-
I was looking in Visual Studio for the hide duplicates option in Tools-->Options and Tools-->Customize and can't seem to find it. Am I looking in the wrong place? Do you think you could direct me?
-
Select the textbox/item where you want duplicates to be hidden -> right-click -> select properties. Then find the Hide Duplicates property and select the dataset for which you want to hide duplicates.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question -
Thank you! Problem solved.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply