Hi All,
Using Reportnet and I have a report where I need to prompt the user for a date range and a time zone, then filter based on the responses. The dates in the model are stored in GMT and we created calculations to accomodate various other zones i.e.EST,CST, etc.
I've got 2 problems;
How do I set up a "static" parameter for the time zone options as these values are not stored in the database. Then how do I pass the users selection to the filter?
This is what I have in my filter now but something is way wrong.
if (?Time_Zone?='East')
Then([DWH Production Rogers].[Eastern Standard Time]between ?start_date? and ?end_date?)
else
if (?Time_Zone?='Central')
Then([DWH Production Rogers].[Central Standard Time]between ?start_date? and ?end_date?)
else
.
.
.
ETC
Many Thanks
Nuffsaid.
Using Reportnet and I have a report where I need to prompt the user for a date range and a time zone, then filter based on the responses. The dates in the model are stored in GMT and we created calculations to accomodate various other zones i.e.EST,CST, etc.
I've got 2 problems;
How do I set up a "static" parameter for the time zone options as these values are not stored in the database. Then how do I pass the users selection to the filter?
This is what I have in my filter now but something is way wrong.
if (?Time_Zone?='East')
Then([DWH Production Rogers].[Eastern Standard Time]between ?start_date? and ?end_date?)
else
if (?Time_Zone?='Central')
Then([DWH Production Rogers].[Central Standard Time]between ?start_date? and ?end_date?)
else
.
.
.
ETC
Many Thanks
Nuffsaid.