Dear Experts,
Data in multi-provider is:
u2018Schemeu2019 u2018Valid from Dateu2019 u2018valid to dateu2019
u2018S1u2019 u201801.June.09u2019 u201831.Dec.09u2019
In report requirement user will enter a date range and based on validity, schemes should get picked up.
Say user enters:
Scenario 1: 01.dec.09 to 31.Jan.2010
In output u2018S1u2019 should get picked up. Because it is valid till 31.12.09
Scenario 2: 01.Nov.09 to 30.Nov.09
In output u2018S1u2019 should get picked up.
Scenario 3: 01.May.09 to 15.Jun.09
In output u2018S1u2019 should get picked up. Because it is valid from 01.06.09
All above scenario explains that if data range user enteres is valid for either u201Cfromu201D date or u201Ctou201D date, scheme needs to be picked up for the report.
But problem is u2018ORu2019 condition on two different fields doesnu2019t work.
Not to mentioned if user enters out side this date range scheme S1 should not be displayed.
How to achieve this?
Thank in advance!!
Regards,
Akshay