Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Group by Date Range

Status
Not open for further replies.

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
 
It sounds more like you want to only display records within this one range and then sort the records by date. You should set up the parameter in the record selection formula like this:

{table.date} in {?daterange}

Then go to report->sort records and choose {table.date} to sort by.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top