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
Sanzee
2
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:
-
As per Sales Order, the number of items ordered is set to 5.
-
Available quantity of the item is 10.
-
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