A simple list report has two columns: Part Number and Description. A user would like a radio button to either include the Part Number column (Yes) or exclude the Part Number column (N) on a report. The user does not even want to see the column header if (N) is selected. Can anyone supply the code or steps to do this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Prompt to show or hide a column in a report
- Thread starter kwelb
- Start date
To do this a few things need to be created.
1. Create your Report with 2 columns: Part Number, Description
2. Add a 2 row table in the header area, make the first row, 1st column .25" in height and 1.5" width.
3. Put a Value Prompt in the 1st Column, 2nd Row. Make id a "Radio Button" type. Make it a parameter called "HideDescr". Uncheck the Parameterized Filter. Uncheck Create New Query. Give it 2 Static Choices of, Yes and No. Make it "Auto Submit" of yes. Default Selection of No.
4. Click on the Description Column, now click on the "Select Ancestors" triangle of the Properties panel. Select "List Columns".
5. Now open the Condition Explorer panel and select the "HideDescr" condition variable. The middle bar should become highlighted.
6. Click the "Style Variable", select the "HideDescr" variable. Click OK.
7. In the Box Type property, click "None".
8. Open the "Page Explorer" and click on your report page. The highlighted bar should now go back to normal.
9. Run your report and select your radio buttons as desired.
It's kind of tricky and needs to be done step-by-step, but it works.
Then the "List Column" property for Part Number needs to be assigned
SLN
1. Create your Report with 2 columns: Part Number, Description
2. Add a 2 row table in the header area, make the first row, 1st column .25" in height and 1.5" width.
3. Put a Value Prompt in the 1st Column, 2nd Row. Make id a "Radio Button" type. Make it a parameter called "HideDescr". Uncheck the Parameterized Filter. Uncheck Create New Query. Give it 2 Static Choices of, Yes and No. Make it "Auto Submit" of yes. Default Selection of No.
4. Click on the Description Column, now click on the "Select Ancestors" triangle of the Properties panel. Select "List Columns".
5. Now open the Condition Explorer panel and select the "HideDescr" condition variable. The middle bar should become highlighted.
6. Click the "Style Variable", select the "HideDescr" variable. Click OK.
7. In the Box Type property, click "None".
8. Open the "Page Explorer" and click on your report page. The highlighted bar should now go back to normal.
9. Run your report and select your radio buttons as desired.
It's kind of tricky and needs to be done step-by-step, but it works.
Then the "List Column" property for Part Number needs to be assigned
SLN
- Status
Similar threads
- Locked
- Question