Parameters required in CE but not CR?

[RLindsey]

I am using CR and CE 10.0 in production. I have a report that has 4 parameters: Branch (of company, a picklist), DateRange (Current Week To Date, Last Full Week, From/To, etc.), From (date), To (date). I use 2 formulae for DateRange_Begin and DateRange_End. They are big IF>Then>Else statements based on DateRange parameter. If user selects last DateRange (From/To), they also have to enter dates for the From and To date parameters.

When I test this in CR it works fine, you don't have to enter the From/To dates when using any of the other DateRanges (.e.g., Last Full Week). However, when I test it in CE, it fails, requiring the From/To parameters, even when not needed.



How can I code this so that I can use the same report for scheduling, and users can use that report to run whatever From/To dates they want?

Sorry, I am CR/CE rookie. Please don't tell me to use a stored procedure, I can barely write the formulae.

 

[ShortyA]

I have done a similar thing. What I did was created two string parameters (StartDate and EndDate) and then in the Record Selection formula I put the following

(
if {?StartDate} ='Last full month' then {table.datefield} in lastfullmonth
else {table.datefield} in datevalue({?StartDate}) to datevalue({?EndDate})
)

If you have other date ranges eg last full week you can just copy the line relating to last full month.