Print Date range parameter value on the Page Header

[dzavad]

I use date range parameter to select records {?Date}.
How can I print Date range parameter values on the Page Header?
Example: <REPORT NAME>
For Period 01/01/2001 to 05/15/2001

 

[txkitten]

Start with a text feild and type:

For Period To

then simply insert your Parameter fields into it, in the correct placements.

It should look like this when done:


For Period {#FromDate} To {#ToDate}

Then place this feild in your pageheader whereever you need it. When you run your report it will hold the dates you entered as your parameters.

Hope this helps.

TxKitten

 

[dzavad]

Thank you txkitten ,it was helpful.
I also found another rway to print date range:
&quot;From: &quot; + ToText ( Minimum ( {?Dates} ) ) + &quot; To: &quot; + ToText ( Maximum ( {?Dates} ) )

Where - {?Dates} is range parameter

 

[rosemaryl]

If you use & to concatenate you do not have to convert the date to a text field with ToText:



&quot;From: &quot; & Minimum ({?Dates}) & &quot; To: &quot; & Maximum({?Dates})
Rosemary Lieberman
rosemary@microflo.com

http://www.microflo.com

 

[ramc2000]

Does anyone know a better way to solve this issue?? I don't think

&quot;From: &quot; & Minimum ({?Dates}) & &quot; To: &quot; & Maximum({?Dates})

is the best way to go. What's gonna happen here is that if your maximum date falls behind the &quot;ToDate&quot; parameter entered, when you print out your report it will be confusing for someone not familiar with the dates entered as parameters.
Example:
Dates entered as parameters:

From 10/01/02 to 10/31/02
Actual maximum date in data: 10/20/02
actual minimum date in data: 10/01/02
Thus, we'll get:

From: 10/01/02 To: 10/20/02

 

[kmarino]

You're right about using the min and max data values rather than the actual parameter values. I too would like to use the Date Range parameter, but I've run into the same problem.

I've been using 2 parameters: one for the start date and one for the end date. Then I can display them as txkitten initially described.

Also check out the following link for other information about ranged values: thread149-197103

 

[dgillz]

Ramc2000 and kmarino,

The formula posted by rosemary returns the maximum of the date range parameter, not the maximum of the dates in the database. It will work. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[rosemaryl]

Dear Ramc2000,

Your supposition is incorrect.

You are not returning the min and max of actual data with this formula, but the min and max of the **range value parameters**. Even though there are only 2 values in the range (From Date through ToDate) you have to use minimum and maximum to retrieve.

Hope this helps,

ro Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[kmarino]

Thankyou dgillz and rosemaryl. It is working. I do see the parameter values as I entered them.