My problem:
I have a simple list report that contains ten columns named A,B,C,D,E,F,G,H,I,J. I want the user to be able to select if they want to hide or show four of the columns (e.g. A,C,F,G) in the report via a multiple checkbox list prompt. This prompt is optional.
The thread thread401-1089845 ( describes what's happend in one or two columns but I need hide more columns. Warning: I don´t know which combinations (only A, or only C, only F, only G, only AC,...,only CFG,..., all).
How to sell multiple information (from multiple prompt value) to the columns? Do I need some filter?
My cycle of operations is here but is incomplete. My solution is only for hidding one column. Can you help me with completing?
1. Creating report in Report Studio with one simple list. List contains ten columns A,B,C,D,E,F,G,H,I,J.
2. Then make a new prompt page and insert a value prompt. The wizard asks whether you want to create a new or use an existing parameter. Select "Create a new parameter" and choose a name (e.g. Parameter1) and click Finish.
3. Select the property "Static Choices" of the value prompt. Add 4 new choices (e.g. A,C,F,G). Set the property Multi-select to Yes.
4. Add a new variable (Conditional Explorer -> Variables) Insert from Insertable object String variable and a change the name (e.g. "var_hide").
In the Layout Expression window choose the Parameter Tab and double-click on your parameter (e.g. Parameter1). In the Expression Definition ParamDisplayValue("Parameter1") is displayed. Change this to ParamValue("Parameter1").
Add four values to the variable (e.g A,C,F,G - this have to be the same as the "use" in the property "Static Choices" of the value prompt).
5. Click on the list column you want to hide. Then select the property "Conditional Style" and choose your previously added variable "var_hide" (with all values marked).
6. Click on the Condition Explorer and then your variable with the value for hiding the column (e.g. C). Select for the list column the property "Box Type" and change the value to "None" - the list column disappears.
7. Leave the Conditional View by double-clicking the green bar (the explorer-bar changes to green when report studio is in conditional view).
8. Repeat steps 5 and 6 with the list column header - you have to hide the column header seperately.
9. ...Your tips...
Thank you for your help ;-)
kostricka
I have a simple list report that contains ten columns named A,B,C,D,E,F,G,H,I,J. I want the user to be able to select if they want to hide or show four of the columns (e.g. A,C,F,G) in the report via a multiple checkbox list prompt. This prompt is optional.
The thread thread401-1089845 ( describes what's happend in one or two columns but I need hide more columns. Warning: I don´t know which combinations (only A, or only C, only F, only G, only AC,...,only CFG,..., all).
How to sell multiple information (from multiple prompt value) to the columns? Do I need some filter?
My cycle of operations is here but is incomplete. My solution is only for hidding one column. Can you help me with completing?
1. Creating report in Report Studio with one simple list. List contains ten columns A,B,C,D,E,F,G,H,I,J.
2. Then make a new prompt page and insert a value prompt. The wizard asks whether you want to create a new or use an existing parameter. Select "Create a new parameter" and choose a name (e.g. Parameter1) and click Finish.
3. Select the property "Static Choices" of the value prompt. Add 4 new choices (e.g. A,C,F,G). Set the property Multi-select to Yes.
4. Add a new variable (Conditional Explorer -> Variables) Insert from Insertable object String variable and a change the name (e.g. "var_hide").
In the Layout Expression window choose the Parameter Tab and double-click on your parameter (e.g. Parameter1). In the Expression Definition ParamDisplayValue("Parameter1") is displayed. Change this to ParamValue("Parameter1").
Add four values to the variable (e.g A,C,F,G - this have to be the same as the "use" in the property "Static Choices" of the value prompt).
5. Click on the list column you want to hide. Then select the property "Conditional Style" and choose your previously added variable "var_hide" (with all values marked).
6. Click on the Condition Explorer and then your variable with the value for hiding the column (e.g. C). Select for the list column the property "Box Type" and change the value to "None" - the list column disappears.
7. Leave the Conditional View by double-clicking the green bar (the explorer-bar changes to green when report studio is in conditional view).
8. Repeat steps 5 and 6 with the list column header - you have to hide the column header seperately.
9. ...Your tips...
Thank you for your help ;-)
kostricka