MS Reporting Services--Adding text before Report Paramaters

Posted on 2006-04-18
Medium Priority
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
  • 2
  • 2
LVL 14

Expert Comment

ID: 16482938
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!).

Author Comment

ID: 16487145
They are message/instructions only, but point out some important fields that are being searched.

Author Comment

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

Accepted Solution

simon_kirk earned 500 total points
ID: 16499744
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

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

864 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