Monday, June 7, 2010

How to Hide or Remove a Parameter from the Reports Parameter Form?


When you create a new user parameter, it is added to the parameter form automatically as you have seen.  The way to hide an undesired parameter is to de-select it from the parameter form builder.  Unfortunately, if you had already modified the parameter form, the layout and headers will be defaulted after you de-select the parameter.
 
Steps to remove the parameter from the form:

1. Open the report in Reports Builder
2. In the Object Navigator, double click on the icon next to Parameter Form
3. Note the layout and headers in this parameter form (there is no way to print this out to save)
4. Click on Tools from the menu
5. Click on Parameter Form Builder
6. Scroll to the bottom where your user parameters are listed
7. Click on the parameter you do not want to see (make it unhighlighted)
8. Click OK
9. This will replace what you already have built
10. Re-adjust parameter form to what you had in step 3

No comments:

Post a Comment