Somewhat new at CR.
I need to display the two dates "Start and End date", selected by the user as parameters, on the Header of my Crystal Report.
Thanks for your help,
Pierre
Printable View
Somewhat new at CR.
I need to display the two dates "Start and End date", selected by the user as parameters, on the Header of my Crystal Report.
Thanks for your help,
Pierre
Did you try dragging the parameter field onto the header of your report?
Thanks for helping.
I've tried to drag it to my report but nothing happen.
I am using a Range values, does it matter?
This is my Select Expert code. I would like to show both date selected in the title of my report.
Thanks,Code:{WorkOrder.WODate} >= {?Report Date} and
{WorkOrder.WODate} <= {?Report Date}
Pierre
Yes.Quote:
I am using a Range values, does it matter?
First use the following for your record selection criteria.
{WorkOrder.WODate} In {?Report Date}
To access the range values use the Minimum and Maximum functions.
Minimum ({?Report Date})
Maximum ({?Report Date})
If you allow multiple ranges to be entered, treat the parameter as an array.
Minimum ({?Report Date}[1])
Minimum ({?Report Date}[2])
There is no multiple range to be entered.
Where do I write down this code?
Minimum ({?Report Date})
Maximum ({?Report Date})
If I write it down in my Select Expert, I get an error message.
Thanks,
Roger
Create a Formula that will be used to display the dates in your Header section. The formula would be something like
"From " + ToText(Minimum({?Report Date}),"dd-MMM-yyyy") +
"To " + ToText(Maximum({?Report Date}),"dd-MMM-yyyy")
It works perfectly.
Thanks for your help.
For another problem.
The form that pop-up and asked for the dates is quite big and clumsy.
How can I format it to a more suitable size.
Thanks again,
Pierre