Hiding a date prompt based on previous prompt selection

[mykodine]

Hello!

please can anyone help me?

On my report I have 2 prompt pages. The first has a selection of:
Custom Date Range
Month To Date
Week To Date

The month to date and week to date are filtered so that they will only produce data for the last month or week accordingly.

So I'm trying to hide the date prompt on page 2 so that it will only be visible when Custom Date Range is selected. And will not be visible when MTD or WTD are selected.

I have the variable set so that if WTD or MTD then yes else no.
If I try just using the conditional style for the date range prompt with the above variable... it still doesn't like it!
I've tried custom block too, no joy.

Any ideas?
Many thanks

 

[almeids]

The problem may be with the condition definition. I don't know what version of Report Studio you're running but in ReportNet "or" conditions are not handled well in conditional variables - in my experience they don't work at all. Instead, put your logic in a data item in your query which calculates a single value you can test in your conditional variable definition.