Skip to Content
0
Former Member
Apr 16, 2014 at 03:14 PM

Named Date Ranges in Business Objects Report Instance

20 Views

I've just created a series of reports which are scheduled to run under 4.1.

The user will have the opportunity to view the reports 'as is' or, within Infoview, select against the saved data to view the last full week, month, etc.

The Saved Data Selection Formula is:

if not hasvalue({?Account Open}) or {?Account Open}=0 then 1=1

else if hasvalue({?Account Open}) and {?Account Open}=1 then {p_report_Customer_High_Risk_Occupations_Detail.Account_open_date_newest}in LastFullWeek

else if hasvalue({?Account Open}) and {?Account Open}=2 then {p_report_Customer_High_Risk_Occupations_Detail.Account_open_date_newest}in LastFullMonth

else if hasvalue({?Account Open}) and {?Account Open}=3 then {p_report_Customer_High_Risk_Occupations_Detail.Account_open_date_newest}in Yeartodate

else 1=0;


My question is, if the user retains instances stretching back over a month or two, opens one of those instances, then filters against the 'saved data' based on the formula above, will the filtered data returned be based on the date the report was originally run or will the Crystal function take the current date when applying the filter?


If the latter, what sort of strategy can be applied to ensure the 'proper' starting point for the named date function?


Thanks...