Report to display data based on dates comparison.

Question

Hi All,

I have requirement to display data based on dates comparison.

I have two dates supply date and ship date in my report. I have a dashboard prompt (variable prompt - PV_Supply) Supply which consists of value 'Yes'.

If user selects 'Yes' then my report should display data based on the condition (supply date < ship date)

How to filter report based on this condition?

regards,

ram.

ArijitC · Answer

Try this ..

'@{PV_Supply}{SometingElse}'='SometingElse'

or "Supply Date" < "Ship Date" and '@{PV_Supply}{SometingElse}'='Yes'

User_JL3CW · Answer

Hi all,

The requirement is like this: Initially my report should display all the records.

My dashboard prompt is have only Yes value as shown below.

As when user selects 'yes' then my report should filter based on the condition (Supply date < Ship date).

My report should display records Supply date < ship date.

For this i have created a variable prompt (PV_Supply) with value 'Yes'.

The above written formula fails and it does not display any data, Please advice suitable answer.

Regards,

ram.

ArijitC · Answer

You can set default value to 'Something Else' or can change it like ...

"Supply Date" < "Ship Date" and '@{PV_Supply}{SometingElse }'='Yes'

You can also update default value of the dashboard prompt