Displaying a date in a monthly report

  • Hello, I'm fairly new to Reporting Services, and have a question that I hope is probably easy to answer. I am designing a monthly report with a date range, and know how to filter out the desired dates. But, I'd also like the report to print out the month at the top - "Monthly Report for XXX, 2008". How can I create the user input field where they would choose the current month so it prints?

    Thanks for any help,

    D Gregg

  • U can use textbox and write expression and normal text into text box like below:

    = "Report for " + Cstr(Parameters!Month.Value) + Cstr(Parameters!Year.Value)

    I havent tested it but it should work with some minor changes.

  • Most excellent, thank you so much. Looks great.

    D

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply