Thursday, February 18, 2010

Adding Parameters to the Report Title in SSRS 2005

So in SSRS 2005 I needed to add my parameters to my report title.  In Crystal Reports it was pretty simple, just drag and drop the parameter into the report title and it would do the work for me.  In SSRS I needed to build an expression.

So click on the Report Title and in the Properties, click on Value and the option.  In the expression type something like this:

="Report on Stuff between" + Parameters!Start_Date.Value + " and " + Parameters!End_Date.Value

If my Start Date was 02/01/2010 and End Date was 02/18/2010 the report title would be:

Report on Stuff between 02/01/2010 and 02/18/2010


Works great once I learned how to do it.

No comments:

Post a Comment