October 7, 2009 at 9:45 am
I have a summary report that use two parameters to determine the output of data. One is a date parameter and the other is a string parameter called pathway. The pathway has 2 values which are:
NONAdmitted patients 18 weeks, Admitted patients 18 weeks.
I have a text box which i use to display a a heading. I would like to dynamically alter this header so that it chnages depending on the parameter value selected.
For example, if the user selects NONAdmitted patients 18 weeks, I only want to display the NONAdmitted part of the string. If the user selects the Admitted patients 18 weeks,I only want to display the Admitted part of the string.
Regards
Eseosa
October 7, 2009 at 7:38 pm
You can use something like this in the header textbox, if the two parameter values will never change:
=IIF(Parameters!pathway.Value = "NONAdmitted patients 18 weeks", "NONAdmitted", "Admitted")
October 8, 2009 at 3:14 am
Many thanks. That exactly what I wanted to do. cheers
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply