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
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.