I am new to SSRS. I use reportbuilder 2.0. After going through the initial steps(select datasource/dataset) and use the table/matrix wizard i have no problems. The issue i am having is my report pulls multiple rows with the the same values:Not sure the best way to address this.Currently i am having to export to excel and then remove duplicate entries.looking for a way to do this in the query design view. Any pointers to fix this would be appreciated. Thanks

Hi Gbolahr, Thanks for your post. You can click the Edit As Text button in the Query Designer window, then type in the “distinct” keyword after the “select”, you can refer to the query string below: select distinct column1,column2 from tbl Thanks, Bill LuPlease remember to mark the replies as answers if they help and unmark them if they provide no help.