I know its a simple question, but how do you eliminate or limit duplicate lines in a BAQ Report? It has been a long time since I created one, so I do not remember the solution. I am trying to create a stock value report show breakdown of all inventory with std. material, labor, burden, for the quantity (UOM) on the floor. I am getting several duplicate rows for items.
Userlevel 3
For the “group”, google “ssrs group tablix”.
I missed this is a BAQ report, you can modify your BAQ subquery to be distinct. I believe that is under query options and you can specify that you want distinct rows. That will be the easiest solution most likely.
Thanks, but none of that “group”, “distinct” or Tabilix means anything to me. I am not a programmer.
Userlevel 3
You can either create a “group” on the report to eliminate duplicates, or modify the query by putting in a “distinct” so that it eliminates duplicates. If you aren’t using a Tablix, then distinct is the route to go.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.