To prompt the user to enter two different values one for the month and one for the year

[Former Member]

Hello,

I'm currently using Crystal Report 8.5. After refreshing the report, I would like the user to see the attached pop up window to enter two values one for the month and  one for the year. Please see the attachment.

Thank you.

[abhilash_kumar · Accepted solution]

Hi Bill,

You would need to create a 'Parameter'. I don't know what it used to be called for CR 8.5, but in the higher versions the parameter is created from the 'Field Explorer'.

In the Field Explorer you should find an option to create a parameter. Go ahead and create two separate prompts - one for year and one for month. Make them both number prompts.

After that you need to add a Record Selection Formula to filter records based on the selection.

Does the datasource have a separate field for month and another one for year? Or is it a single date/datetime field? If it's a date field, the formula would look something like this:

Month({Date_field}) = {?Month_prompt}

AND Year({Date_field})  = {?Year_prompt}

-Abhilash

[Former Member]

Thanks Abhilas for your help. It works perfectly.

[Former Member]

Correction: Abhilash

[abhilash_kumar]

Glad it works!

Please close the thread.

-Abhilash