Printing Date Range Parameter Field values 2

[checkley]

The purpose of my report is to list all the orders in
my database in a date range to be determined by the
user. I create my report, and create my Parameter field,
which prompts my user for the start dates and end dates
when he runs the report. That is all absolutely fine, but HOW DO I GET THE START DATE AND END DATE TO PRINT IN THE REPORT HEADER ? If I place the Parameter field in the report header, it is invisible in Print Preview. If it is just ONE date - i.e. a "from" date which runs up to the present day - it prints just fine, but neither I nor my colleague can make the preview display a "from (Date) - to (Date)" Parameter. Surely people need to do this all the time!! I must be missing something here.........

 

[Naith]

If you're using a single ranged parameter, do:

"From " + Minimum({?Date}) + " to " + Maximum({?Date})

Naith

 

[dgillz]

Close, but you need to convert the dates to text first:

"From "+ToText(Minimum({?Date}))+" to "+ToText(Maximum({?Date}))
Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[Naith]

I'm losing my touch today. ("What touch?&quot

Good save, Dgillz.

 

[mbarron]

You could use Naith solution if you substitue &'s for the +'s

"From " & Minimum({?Date}) & " to " & Maximum({?Date})
Mike