hye, i'm new with CR XI.

currently, i'm working with a crosstab report. the report will display data based on daterange. the parameters are divisionName, startMonth, endMonth, startYear, endYear.

my report working well unless if user keyin the endMonth > startMonth. for example, if user keyin startMonth = 9, startYear = 2005, endMonth = 1, endYear = 2009, then there will be no data display. but it has no problem if startMonth= 1, endMonth = 9.


what is the right formula for a daterange report?