I am creating a report, and i have 4 header values, which are parameter that user had selected. So it was easy to show. But have to add another paramter and show the value as user selected from the front end. So that is easy to as other 4. the problem is that when user select the value for 5th column select from the drop down. Stored procedure send the value of the selected item as 1 or 2 or 3. but that 1,2 or 3 is useless and I have to show its corresponding text value in the header. So how I do that with in the SQL Reporting service. So how I can show that ??i am a novice and a student

Are you retrieving the data in a DataSet? If you have the corresponding Text value for the values you selected in the DataSet, then you can always use Expressions to display the same on the Report Header. There is a similar forum that can help you: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/2e2bce70-43f5-4e36-9432-12fb762ccffe How to write expressions? http://msdn.microsoft.com/en-us/library/ms345242(SQL.90).aspx Hope this helps..Chaitanya

Yes you are right and I read the solution. I did the way it explaind. So things are fine with it. Actually the task was to show the slected value from dropdown on the header. When user select the item from the dropdown user sees the text on the display not awear of the item value. Stored procedure that i wrote is getting the value and that stored procedure is being used in other places as well. So for me to show what user selected on the header would be easy if I could show the selected vlaue as 1, 2 or 3. but I have to show New, Old , cancled. I don't know how i can do that. And to work around that I am sending an extra column from the stored procedure and now binding that colum value on the body. Now now i am showing this by reportItem value in the header section. thanks for help i am a novice and a student