Sharing a date parameter within a main report

[reitter]

I'm using Crystal 9.0 with a SQL database. The database has the following 2 fields:

PositionDate
AnniversaryDate


I know that I can make each one of the fields have a parameter Date Range for my user to enter when they run the report. My question is since date range would be the same. Meaning - have the report show everyone who has a PositionDate or an AnniversaryDate between 4/1/2004 - 4/14/2004, isn't there some way to have the 1 date range parameter = either of the two fields?

I'm just trying to make it easier and less confusing for the users to work with.

Thanks for all the help.

 

[govmule]

Hello,

Yes, their certainly is.

Just create two parameters, lets say 'Start Date' and 'End Date', or something to that effect.

Next using the select expert choose 'Position Date' between 'Start Date' and 'End Date'.

After that using the select expert choose 'Aniversary Date' between 'Start Date' and 'End Date'

That should work fine.

Good Luck

 

[synapsevampire]

If you are saying that the same data range applies to both fields, use something like the following in the record selection formula:

{table.PositionDate} in {?MyDateRangeParm}
or
{table.AnniversaryDate} in {?MyDateRangeParm}

-k

 

[lbass]

Have you tried:

{table.positiondate} = {?date} or
{table.anniversarydate} = {?date}

//where {?date} is a discrete date range parameter

-LB

 

[reitter]

Thanks for your answers, I was getting hung up trying to make the parameter where the default ties to a specific field. I didn't realize you didn't have to tie a parameter to a specific field.

Thanks again for such fast responses!