Remove Duplicates in Parameter Drop down in SSRS Report in AX 2009

Hi All,

I created a Data set and added one field in the filter…

Added new parameter…

Added to field from same data set to values property of parameter…

It displaying duplicate values…

I want to display parameter drop down with unique values…

Please Suggest me…Urgent…

Thanks in advance

Hi Krishna,

same problem here. Did you got the solution please share.

Anybody please help !!!

Thank you

Hi Krishna,

It’s not a problem in VS. It usually display all the values that ur tables contained in it.

If u open ur report from ur client (AX), that dropdown may show only unique values.

Check it from ur client.

I am currently working on a customization on the Sales Order Report using the SSRS.

The report shows the Sales Order details. These details originates from SalesTable and SaleLine.

The report also shows the quantity of items that are on-hand. This come from the InventSum table.

However, multiple data are shown on the form.

As an example:

  1. As per Sales Order, the number of items ordered is set to 5.

  2. Available quantity of the item is 10.

  3. In the Customized Report, the following appears:

17 lines are shown with Order Qty of 5.

ItemId Description Warehouse Location Site

0101 AH20M900SB Big B-1-1 1

Order Qty Available Qty

5

5 -5

5 1

5 1

5 1

5 1

5 1

5 1

5 1

5 1

5 1

5 1

5 1

5 1

5 1

5 1

5 1

10