Req is like this---
A generic query subject Q1 is created in Fm with 100 columns in a table say Table A.
There is a value prompt--in which user selects the table and based on the table selected by the user the columns and the data are stored in the generic column of the query only the columns that is present in the selected table will be displayed and the remaining columns will have null value and will be hidden. This way the number of columns displayed to the user will change based on the table selected.
in this suppose user selects a table that has only 50 columns -how to hide the rest of the 50 columns .
can u pls suggest a better solution.(if we go for style variable will be very hectic creating 100 variables)
Hi
I think you have 2 options. You could have a page for each report the user could choose and then have render variables on the page so only the relevant page is displayed or you could have render variables on each column either way is going to be difficult to manage.
I had to do something similar where my client wanted to be able to select which columns were used in the report. The report ended up having something like 70+ render variables and took ages to run. In the end I decided that the best way to meet the requirement was to give the users access to query studio, then they can pick and choose which columns they wanted.
Maybe QS is a better way to go