I'm creating a crystal report which I plan to put in Custom Reports.  In my export I've included all gifts to the CFY.  When running the report I want to have a parameter open so that the user has the option to only pull certain dates.  I can't get it to work it still includes all dates.

 I have the name as Gift Dates, Type=Date, Value Field = CnGf_1_Date, Description Field - None, Prompt Text=Enter Gift Dates:, Prompt with Description Only=False, Custom Values=True, Multiple Value=True, Discrete Value=True, Range Value=True

Thank you

Chris

Hi Chris

A couple of things come to mind:

Have you set default values to instruct the user what time period you want them to choose?

Have you included the Parameter in the Select Expert so that it runs whenever the report is accessed?

Regards

Peter

I'm not sure what you mean by default values - the parameter asks for the gift date and shows the format they need it in.  They will need to use a date of either the day after the gift was entered and also on a weekly basis.

I'm also not sure what you mean by the select expert - it won't let me choose a parameter field.  I don't want the person to have to go into the Crystal report at all - only custom reports.

 Thanks,

 Chris

It's best if your parameter is a date range rather than a single value.  In the select expert, choose the Gift Date field, then under the operation choose Formula:  Your formula will be something like {Gf.GfGiftDate} IN {?DateRangeParameter}

Drew

Here it is

{Gf.GfGiftDate} in DateTime ({?Start}) to DateTime ({?End})

 Where
{?Start} is parameter 1 for start date and {?End} is parameter 2 for end date.