Using Parameter values in Report Header

• ajit.sadasivan

  Newbie

  Points: 3

  More actions

  December 19, 2008 at 6:19 am

  #383613

  Hi,

  Our reports were developed using SQL Server 2005 Reporting services, using Business Intelligence Studio. For most of the reports,

  the user is supposed to enter a date ( feeDate). Internally this date is passed to the underlying query. How do we display this date in the Report header ?

  I tried returning the data also in the query. But Reporting services won't allow us to display the field values in the header.

  I can see this date field displayed under the Report parameter. Can I use the parameter field ( textbox value) in the header ?

  With Regards

  Ajit

• Jack Corbett

  SSC Guru

  Points: 184397

  More actions

  December 19, 2008 at 7:09 am

  #915251

  You can just use the parameter in the Header. Like this:

  ="Fee Date: " & Parameters!feeDate.Value

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question