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

What is the meaning of -1 used in sql based report

Started by inu, 04 Apr 2015 03:01:03 PM

Previous topic - Next topic

inu

Hi Team,

#promptmany('Param_Department','string',sq('-1'))# is being used in my sql based report , which is restricting to retrieve the data..

In place of -1 can i put somethingelse.... which should not effect the report output...
Please instruct me and share some ideas , so that problem would be solved...

Regards
Inam

navissar

That's a macro prompt. The first value is the parameter's name, the second value is the type, the third value is the default value for the parameter if it isn't filled. You can get rid of the default value but then the prompt becomes mandatory.