If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Solution needed-

Started by Shailaja0520, 14 Jan 2009 11:15:08 PM

Previous topic - Next topic

Shailaja0520

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)

wyconian

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