Date in crystal reports...

[SN082]

Hello, I have a table with a date field, my selectionformula uses the date field in order to select records to report. To archieve that I used two date variables, to select a period of time. How can I "put" the start and the end date in the header of my report?


all help would be appreciated.

Rgrds,

stijn

 

[RobinLord]

Use two parameter fields instead, then the parameters can be printed in the report wherever you like.
Alternatively make the variables 'global' and then create a two formulae which takes the values of one of the variables each and put the formulae on the page header.

 

[SN082]

robinlord,

could you please give me an example?


Thanks,
stijn

 

[dgillz]

I typically would use a date range parameter for my start and end dates. The user is prompted for the date range and you ties your parameter field in witht he record selection formula.

To get the dates to appear at the top, try a formula like this:

ToText(minimum({?DRParm}))+" to "+ToText(maximum({?DRParm}))

Then place this formula in the page header.

if you really need variables, write a formula similar to my one above to get the dates in your page header. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[dgillz]

I typically would use a date range parameter for my start and end dates. The user is prompted for the date range and you ties your parameter field in witht he record selection formula.

To get the dates to appear at the top, try a formula like this:

ToText(minimum({?DRParm}))+" to "+ToText(maximum({?DRParm}))

Then place this formula in the page header.

if you really need variables, write a formula similar to my one above to get the dates in your page header. Software Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com