Hi Experts,

I am working on CR2016 designer.

I have one optional prompt on Comments field, but my requirement is, if user don't enter any value in prompt it should bring all values, other wise he has to bring only which are not null values in comments field along with remaining report fields.

I am trying to write below code

(not HasValue({?Comments}) = {Command.ZCOMMENTS})
or
(HasValue({?Comments}) = (not HasValue {Command.ZCOMMENTS})

but throwing "The ) missing" error is coming


Your help should be appreciated.

Edited by skattempudi - 24 Jun 2018 at 11:29pm

why not make the prompt a Yes/No drop down

({?Comments}='No'
or
({?Comments}='Yes' and NOT(ISNULL({Command.ZCOMMENTS})))


If you want to keep what you have I am not sure what they are putting into the ?Comments option but try this
(
not (HasValue({?Comments}))
or
(HasValue({?Comments}) and NOT (ISNULL({Command.ZCOMMENTS})))
)

No problem.  Better two good answers instead no answers or a bad answer :-)

Did you try this...?

(
not (HasValue({?Comments}))
or
(HasValue({?Comments}) and NOT (ISNULL({Command.ZCOMMENTS})))
)