How to pass only month name and year as parameter ?

[Devaki]

Hi,

I have a report in crystal8.5 with start date and end date as input parameter.The datatype is date and it shows the calender whenever it prompts for input parameter. Now i want to show the date with month and year instead of a calender. Can it be done with the existing set up or i have to create the month as string field and year as number field and do it?

Please help

Thanks
devaki

 

[dgillz]

You can leave your paramter fields as full data fields, place them on your report and format them to show month and year only. Is this what you want? Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[Devaki]

Hi,

I want the parameter field to show only the month
example Jan 01,Feb 01...
I don't want to show the complete calender and then format the parameter field after that.
Is there a way to do this?
Thanks
Devaki

 

[dgillz]

Not with a drop down calendar. You can create a default values list for the parameter(s) as a text field, then convert them to a date for use in record selection formulas. Does that help?. Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[Devaki]

Hi ,

Do i need to create 2 Default value list . one for the month another for the Year.
Thanks for the help
Devaki

 

[dgillz]

No, just create one list as a text value. For instance, if the default value selected is "Jan 2002", the following record selection formula will pick all records with any date in Jan 2002.

year({datefield}} = value(right({?Parmfield},4) and
monthname(month({Datefield}),true) = Left({?parm},3)
//True returns a 3 character month abbreviation

Please let me know if you have any questions.


Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com