Date range parameter as heading 2

[HezMac]

Hi

I'd like to use the date range entered in by the user as a heading in the report I'm creating. (Using Crystal 8.5)

For Example:
"Revenue for the time period: " [date range parameter]

Possible? Do I have to create a formula?

Thanks for any help.

 

[lbass]

Yes, create a formula:

"Revenue for the time period: " +
totext(minimum({?daterange}),"MM/dd/yyyy")+
" to " + totext(maximum({?daterange}),"MM/dd/yyyy")

-LB

 

[mbarron]

Yes, you would need a formula:

"Revenue for the time period: " & minimum({?date_range_param})& " to " & maximum({?date_range_param})



Mike

 

[HezMac]

One other thing:

Is there a way to have the month spelled out (July instead of 7)?

Cheers.

 

[mbarron]

Expasnding on lbass's
"Revenue for the time period: " +
totext(minimum({?daterange}),"MMMM/dd/yyyy")+
" to " + totext(maximum({?daterange}),"MMMM/dd/yyyy")



Mike

 

[kmcginn]

If the begin and end date are in two separate parameters, you don't even need a formula. You can just add a text box and then the parm for begin, another text box and the parm for end date. I dod it all the itme, but my date range is always in two parameters - begin, and end.

 

[HezMac]

Thanks for your help, I have it working how I want it!
The MMMM - great!