Concatenate two fields in a SSRS report parameter for AX 2012 report

[murtuzahasmi]

Hi,

Appreciate if someone can help me in the below issue:

I am trying to create a report for a Salary certificate, in which i want the user to be able to select in his parameter , a concatenated parameter with both the Employee number and Employee name. Somehow i can only get each field in different parameters. I am failing to understand how to concatenate them.

Below is the structure i am trying to use for my SSRS report, and have also tried to put different queries for the Parameter but it gives errors.

Can anyone help me to see what i should be doing either in the visual studio or AX 2012 AOT query?

[angelus]

if you have the parametes employeenumber and employeename , then the following will work for u

=Fields!Employeenumber.Value & " " & Fields!Employeename.Value

[murtuzahasmi]

i tried the stated above by creating a Parameter and adding the same like above that you have suggested in the Non-queried query designer of the parameter.

But i seem to be having errors in the report .