Showing values from date range parameter on report 1

[Chats]

Second query today!

I am using Crystal 8.5, Oracle database.

I have a parameter field which is a date field, accepting range values.

I want to show this date range on my report header, because it is a range parameter, when I drop the field name onto my report, I get a blank.

Can anybody tell me how to get around this please?

Cheers

Ade

 

[Reebo99]

Create formulas :

Minimum({?DateRange})
Maximum({?DateRange})

Reebo
Scotland (Sunny with a Smile)

 

[amatson]

As Reebo99 mentioned, formulas work well.

"Effective: " + ToText(Minimum({WRKLOAD_RPT_1.EFF_DT})) + " To: " + ToText(Maximum({WRKLOAD_RPT_1.EFF_DT}))

However, I've found that only the date range of the result set is what displays on the report. Not necessarily the date range values searched for.

 

[Reebo99]

amatson,

in the original thread :

I have a parameter field which is a date field, accepting range values.

Say the date range parameter is called {?DateRange}, if you create a formula minimum({?DateRange}), you will get the lowest date value of the parameter.

However, in your example, you will only get the lowest date value of the recordset returned.



Reebo
Scotland (Sunny with a Smile)

 

[Digitalcandy]

'Dates From: '+ToText(Minimum({?DateRange}))+' To: '+ToText(Maximum({?DateRange}))