Suppose i am having 6 columns in my report having names 1,2,3,4,5 and 6.
Now i want only those columns to be displayed in the report which i will be selecting through prompt.
Suppose i select column 1,2 and 3 then only those 3 columns should be displayed in the report.
Can anyone provide me solution for this ....
Thnx in advance
Yes u can do this by using render variable. :)
User wants to be as a required prompt.
Create a Boolean Variable for each column based on the prompt value and assign it to Render Variable property of each column.
Say you have 3 columns in your report.
Create 3 Boolean variables like
ParamDisplayValue('Prompt') Contains 'Column1'
ParamDisplayValue('Prompt') Contains 'Column2'
ParamDisplayValue('Prompt') Contains 'Column3'
Assign the variables to Render variable property of appropriate columns.
hi Gopinath
i tried your steps using with Boolean variable and render variable property But not giving the empty page
might be i am going wrong somewhere,
can u please explain in details ....
best regards,
vj
Hi VIJ,
I am not sure but can you try this once: Take only paramValue instead of ParamDisplayvalue
Say you have 3 columns in your report.
Create 3 Boolean variables like
ParamValue('Prompt') Contains 'Column1'
ParamValue('Prompt') Contains 'Column2'
ParamValue('Prompt') Contains 'Column3'
let me know if it works
Thank you
Hi hrk551 ,
sorry to say that but this is not working too. :(
regards,
vij
Hi,
Gopinath Saying correct,
1) create one boolean varibale, in that expression window write like this "ParamDisplayValue('PromptName(OutputColumn)') is null and give the varibale name as 'ColumnExist'.
2) created 6 boolean variables as per your column names.
3) in that each boolean variable "ParamDisplayValue('PromptName') contains '1' for 1 column and create boolean variable for each columns.
4) goto the report studio drag & drop the conditional block beside the list.
5) and select the block and assign Block variable as 'ColumnExist' variable to that conditional block.
6) current block property as 'No' and select the entire list through ancestor button and drag into that entire list into that conditional block.
7) and select the 1 column and in properties pane select the ancestor button inthat select 'ListColumn' and assign render variable as created boolean variable for 1 column. and assign remaning boolean variable through render varible.
I think it is working properly.
Please excuse any grammer mistakes.
Bye
Hi all,
i have tried this and it works.............
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(parameter name) contains A" ,
A = 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.
hope it will help ............
regards,
vij
:)