• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 671
  • Last Modified:

SSRS 2005 Setting the prompt text for a report parameter based on another parameter in a report

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?
1 Solution
I'm afraid you can't use any kind of expression in a parameter prompt.

This means you can't reference a dataset or any other parameters, the prompt will always be static.
nicecatsAuthor Commented:
I suspected that, Thanks for the answer. Let's hope SSRS 2008 is better.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now