Hi, I would like to create a parameter that has as value, the combination of 2 fields of my dataset. Say like Name and FirstName combined as EmployeeName There is no chance I can update/change the procedure that delivers these fields. I tried looking into the code, but didn't have a lot of success. Anyone some ideas? Thanx

I dont think we have this flexibility out of box. Regards,Phani Note: Please mark the post as answered if it answers your question.

hmmm, just a thought. Assign each of these fields into one parameter so that you have RP_FrstName and RP_LstName as the report parameters. Now make another dataset which will concatenate these two report parameters and output a single column. Now you can use this single column into your required parameter.Cheers, Jason P.S. : Please click the 'Mark as Answer' button if a post solves your problem! :)

Hi, Thanx for the thinking! But...I found a way to handle with it : I added a field to my dataset, a calculated field. And in the expression for the field I just did like you should do when you want to display something on your report =Fields!Name + " " + Fields!FirstName. Thanx anyway!!

u talked about a parameter and now u added a field? o.OOne who can read, have a clear advantage!

Yes, I needed to format the label for my parameter. And the label equals the combination of 2 field values! I added the 'new' field to the dataset as calculated field, not to the original procedure.

Label of a parameter (Values of two fields) cannot be defined with formulae. Precisely this is what I wanted to communicate. Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

You can add a calculated field and use that for the label.-