PreetiGanamani
Programmer
Hello,
i really need help with this...
I have to add the option of hiding or showing 2 columns.
these are the steps i followed but i can see all the columns in the report irrespective of the selection at the prompt.
please do let me know if i am doing something wrong or if i need to do something else.
STEPS:
1) In the prompt page ,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 (Parameter1) --> click finish.
2) Select the property "Static Choices" of the value prompt. Add 2 new choices (e.g. Use: w , Display: with column A; Use: o , Display: without column A).
3) Add a new variable (File -> Variables...) with Type "String" and a name ( e.g. "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 two values to the variable (e.g "w" for with and "o" for without column - this have to be the same as the "use" in the property "Static Choices" of the value prompt).
4) Click on the list column you want to hide. Then select the property "Conditional Style" and choose your previously added variable (with both values marked).
5) Click on the Condition Explorer and then your variable with the value for hiding the column ( e.g. o). Select for the list column the property "Box Type" and change the value to "None" - the list column disappears.
6) Leave the Conditional View by double-clicking the green bar (the explorer-bar changes to green when report studio is in conditional view).
I followed the steps taken from a previous post by timida.
When i do this the 2 columns are hidden from the report page but when i run the report both of these columns are displayed.Not sure how to go about it from here...
Lohita
i really need help with this...
I have to add the option of hiding or showing 2 columns.
these are the steps i followed but i can see all the columns in the report irrespective of the selection at the prompt.
please do let me know if i am doing something wrong or if i need to do something else.
STEPS:
1) In the prompt page ,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 (Parameter1) --> click finish.
2) Select the property "Static Choices" of the value prompt. Add 2 new choices (e.g. Use: w , Display: with column A; Use: o , Display: without column A).
3) Add a new variable (File -> Variables...) with Type "String" and a name ( e.g. "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 two values to the variable (e.g "w" for with and "o" for without column - this have to be the same as the "use" in the property "Static Choices" of the value prompt).
4) Click on the list column you want to hide. Then select the property "Conditional Style" and choose your previously added variable (with both values marked).
5) Click on the Condition Explorer and then your variable with the value for hiding the column ( e.g. o). Select for the list column the property "Box Type" and change the value to "None" - the list column disappears.
6) Leave the Conditional View by double-clicking the green bar (the explorer-bar changes to green when report studio is in conditional view).
I followed the steps taken from a previous post by timida.
When i do this the 2 columns are hidden from the report page but when i run the report both of these columns are displayed.Not sure how to go about it from here...
Lohita