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])
Quote from: Lana on 12 Nov 2015 04:39:07 PM
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.
if(#promptmany('Reported Date', 'date', sq('notchecked'))# = 'notchecked')
then ( null )
else ([REPORTDATE])