Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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.

Current Fiscal.PNG (27736 B)
Tags:
Former Member
replied

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

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question