sondev
IS-IT--Management
- Jan 7, 2005
- 22
I am trying to group a date range based on a parameter field. The paramater field, ?daterange, needs to display items on the report within the date range. I am able to convert the date range to text with the following formula field:
totext(minimum({?daterange}),"MM/dd/yyyy") + " to "+ totext(maximum({?daterange}),"MM/dd/yyyy")
I placed this on my report header. Now the problem is that the data will not sort within this date range. I need to group this ?daterange parameter but im not sure how. Instead of specifying the range value for one parameter, should I create two parameters? I need to be able to enter these fields and pull this report in an HTML form. Any advice would help. thanks
totext(minimum({?daterange}),"MM/dd/yyyy") + " to "+ totext(maximum({?daterange}),"MM/dd/yyyy")
I placed this on my report header. Now the problem is that the data will not sort within this date range. I need to group this ?daterange parameter but im not sure how. Instead of specifying the range value for one parameter, should I create two parameters? I need to be able to enter these fields and pull this report in an HTML form. Any advice would help. thanks