Macros - promptmany

[Lana]

Hi -

I have the following filter, and the report validates fine. when no checkbox is selected, i get a blank report.

when any combo of values is selected, i get this error, RQP-DEF-0177

anyone know about this error and how to resolve it?

if(#promptmany('Reported Date', 'date', sq('notchecked'))# = 'notchecked')
then ([REPORTDATE] is null)
else  ([REPORTDATE])

and

if(#promptmany('Reported By', 'varchar2', sq('notchecked'))# = 'notchecked')
then ([REPORTEDBY] is null )
else ([REPORTEDBY])

and

if(#promptmany('Changed Date', 'date', sq('notchecked'))# = 'notchecked')
then ([CHANGEDATE] is null )
else ([CHANGEDATE])

and

if(#promptmany('Changed By', 'varchar2', sq('notchecked'))# = 'notchecked')
then ([CHANGEBY] is null )
else ([CHANGEBY])

[Lynn]

Hi -

I have the following filter, and the report validates fine. when no checkbox is selected, i get a blank report.

when any combo of values is selected, i get this error, RQP-DEF-0177

anyone know about this error and how to resolve it?

if(#promptmany('Reported Date', 'date', sq('notchecked'))# = 'notchecked')
then ([REPORTDATE] is null)
else  ([REPORTDATE])

and

if(#promptmany('Reported By', 'varchar2', sq('notchecked'))# = 'notchecked')
then ([REPORTEDBY] is null )
else ([REPORTEDBY])

and

if(#promptmany('Changed Date', 'date', sq('notchecked'))# = 'notchecked')
then ([CHANGEDATE] is null )
else ([CHANGEDATE])

and

if(#promptmany('Changed By', 'varchar2', sq('notchecked'))# = 'notchecked')
then ([CHANGEBY] is null )
else ([CHANGEBY])

Surely there were more details about the error than just the number you posted. You also didn't mention if your source is relational or dimensional. More information might help you get better responses, but based on the expression you've posted I suspect your problem is with the "then" portion of your "if" statements.

You cannot set the value of a query item within a condition. You can only return something. You could try revising as shown here for the first one.

Code Select Expand


if(#promptmany('Reported Date', 'date', sq('notchecked'))# = 'notchecked')
then ( null )
else  ([REPORTDATE])