Scribd
Upload
33 views6 pages

How To Create Report With Dynamically Selected Columns

1. Create a report with a value prompt for selecting columns dynamically. 2. Add the column names to the prompt's static choices. 3. Create boolean variables for each column, linked to whether its name is in the prompt's value. Selecting columns in the prompt will show/hide them using the boolean variables.

Uploaded by

cwitters
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
33 views6 pages

How To Create Report With Dynamically Selected Columns

1. Create a report with a value prompt for selecting columns dynamically. 2. Add the column names to the prompt's static choices. 3. Create boolean variables for each column, linked to whether its name is in the prompt's value. Selecting columns in the prompt will show/hide them using the boolean variables.

Uploaded by

cwitters
Copyright
© Attribution Non-Commercial (BY-NC)
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 6

How to create report with dynamically selected columns

1. Create new list report.

2. Drag in desired data items into the list.

3. Create prompt page with Value Prompt

Click Finish.
4. Highlight the value prompt to bring up the properties.
5. Click on the ‘Static Choices’ property.
6. Enter the names of the columns to be rendered dynamically.

7. Click OK.
8. Set the ‘Multi-Select’ property to ‘Yes’
9. Set the ‘Select UI’ to ‘Check box group’
10. Click on the ‘Conditional Explorer’.
11. Click on ‘Variables’
12. Drag in a Boolean Variable for each of the dynamic columns
13. Rename each variable to correspond with the column name.
This is done by changing the name property.

14. In the expression for each variable enter:

ParamDispplayValue(‘dynamicColumns’) contains ‘X’

X = the name of the column

14. Click on the ‘Page Explorer’.


15. Select the first dynamic column.
16. Click on the ancestors button and select ‘List Column’

17. In the properties pane select the ‘Render Variable’

18. Click OK.


19. Repeat for each column.
20. Run the report. You will now be prompted to select which
columns to include in your report.

You might also like