Thought this would be easy but it's not. I am using ssrs 2005 (SQL Server Reporting Services 2005)
What I want to do is to change the prompt text on one report parameter based on data from another parameter. i.e. I have a parameter called FinancialYear which in the report designer has prompt text of 'Enter Financial Year' that a user can set the value for ie. 2005, then there is a second parameter called PercentChange with prompt text I want to set as 'Percent Change based on ' & Parameters!FinancialYear.value. How do I do this in the report designer?