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

default date prompt in dimensional crosstab report

Started by avuong6, 05 Jul 2016 10:19:05 AM

Previous topic - Next topic

avuong6

i have a 4 column report in which users can define the 4 periods for the report. for period 4, i would like it to be optional. so if no selection is made, i would like it to not select a period and then the 4 column report turns into a 3 column report. the prompt for column 4 is currently coded like this:

#prompt('P_Period4', 'memberuniquename' , '' , '' , '[Sales].[Monthly Periods].[Period].[Period]')#

how do i default this to basically not return anything if no selection is made on period 4? is this possible?

bdbits

Just make the last prompt optional, then use render variables to hide the 4th column if nothing was chosen.