I would like to offer a parameter in a report that allows the users to group by either an "Expected to Close Date" or "Deadline" date. I know it's possible to to let users choose how to group a report with parameters, but I'm having trouble doing it with date fields. Anyone know how to do this? Thanks! Sandi Reinardy Development Database Manager City Year Boston, MA 02130 617-927-2336

If this is a custom report just use group and choos the date field and then sort by other fields. It is a long about way in a report that comes with BB Bruce Fausey Data Specialist Cathedral of Hope Dallas, TX 75235 [Email Removed]

I want the person running the custom report to be able to change the group method. For example, one user might want the report grouped by Fund, but another might want it grouped by Appeal. Rather than making two reports, I'd like to set a parameter that lets them choose. I think what you're describing shows how to set a group, but not a parameter. Sandi Reinardy Development Database Manager City Year Boston, MA 02130 617-927-2336

-Set-up Parameter field where the choices are "fund, appeal..." strings. -Set up a formula that looks at your parameter and chooses the appropriate field. -Group on the formula field. -if you are mixing data types here, you may run into trouble (just do a simple type conversion) This works quite well, however, I'd create 2 reports- easier for the not-computer-savvy user, and therefore easier on me :) Kate Sklodowska -------------------- Collegiate School Development Office Database Manager [Email Removed] T: 212-812-8597 F: 212-812-8514