MS Reporting Services--Adding text before Report Paramaters

Posted on 2006-04-18
Last Modified: 2011-09-20
I have a report in MS Reporting Services with a few parameters on it, but of course when I run the report it only asks for the parameters.  I would like to add some verbage at the very beginning before it even asks for the parameters.  I have tried a header, but that still only shows after you have put your parameters in and have hit submit.  How can I do this?  I only want this verbage there on the screen not when you do an export.  Can you help?
Question by:The_Spaz
    LVL 14

    Expert Comment

    What are you trying to achieve by adding this text?  Is it supposed to be some sort of message/instructions displayed before the user runs the report, or are you after the user to type something that isn't used in the report (which seems a bit pointless!).
    LVL 1

    Author Comment

    They are message/instructions only, but point out some important fields that are being searched.
    LVL 1

    Author Comment

    Can this be done.  If so, how?  Does no one in here know MS Reporting Services that well?
    LVL 14

    Accepted Solution

    Patience is a virtue - remember most experts like myself have a full time job and comments on questions are done in our spare time!  We don't get paid for it.

    A few choices:
    - Add the instructions into the report description (best option)
    - Set the default values of your report parameters to a Null or Blank value so that the report runs on opening but returns no data.  Then have a textbox within your report that displays the instructions, and set it's visibility to a parameter.  By default the instructions would show, and then when the user selects parameters, they set the instructions parameter to 'off' to hide the instructions.
    - Write a procedure in Word outside of RS with screen prints etc

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
    Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
    It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
    This video discusses moving either the default database or any database to a new volume.

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now