Skip to Content
0
Former Member
May 22, 2016 at 09:06 PM

Display numeric parameter results in Report Header with condition

30 Views

My database has 9 employees each with a numeric ID number. I have created a Number parameter using Allow multiple values. i have a text box in the report header which says "Employees selected: @displayEmpId". When I run the parameter the results are perfect. I see only the employee Id's l selected. e g. "Employees selected: 3, 7, 9"


What l would like to do is instead of having all 9 numbers display when Il run the parameter and get the results of all e.g. Employees selected: 1, 2, 3, 4, 5, 6, 7, 8, 9 is the message to read "Employees selected: ALL". As the number of employees grow in the future there would not be enough space in the Report Header to display them all.


Would really appreciate ate any help on this problem, I am fine with string fields, its trying to get the string result of ALL when the parameter is numeric.