Monthly Parameter

[lshea]

I am working with Crystal 9 and am not sure how to proceed.

I currently have two parameters, ?StartDate and ?EndDate, each asking for a discrete date value. When working with daily data, these parameters work great.

However, the problem I'm having is when I'm working with monthly data. The table only has one entry per month, (Ex: 1/1/06, 2/1/06, etc) so selecting a date range isn't exactly accurate. For example, the date range 1/1/06 - 2/15/06 and the range 1/1/06 - 2/28/06 will return identical data.

I'd like to be able to allow parameter selections such as ?StartDate = January 2006 and ?EndDate = August 2006, resulting in a return of 8 lines of data.

Thank you for any help in advance!

 

[synapsevampire]

Seems in part a training issue to me.

Are you saying that you'd like the dates prepopulated with the month name and the year, so that the user can simply select the months of interest?

The example of what you want shows that, so I'll assume that to be the case.

So in the edit parameter screen you'll see set default values, select that and enter in the dates you'd like to present, such as 1/1/2006, 2/1/2006, and then select the description and enter the descriptions as January 2006 etc.

Now select the show decription only and the users will be presented with the more frendly descriptions, yet the proper dates will be passed using your usual record selection technique.

-k.