Crystal Reports Date Range

[WalfdPD]

I am using CR that came packed w/ VBnet.2003 pro edition.
I need a report that shows an employees absentee days during a particular date range as selected by an end user. The data table I am using is an access table which uses the date/time format.

When I use the parameter editor to compose a date range selector it will allow the end user to change the start and finish default settings to the dates he/she wants but when the report is run it displays all of the dates that fall within the start and finish defaults as specified in the parameter editor rather than the dates selected by the end user.

 

[Madawc]

On the menu, check Report> Selection Criteria> Records. See what it is looking at, and whether you can switch this to the selection you want.

Madawc Williams (East Anglia, UK)

 

[lbass]

How did you set up the parameter in the record selection formula? It should look something like:

{table.date} in {?daterange}

As Madawc suggested, go to report->edit selection formula->record to see what you have so far. You might want to copy the formula into a post.

-LB

 

[WalfdPD]

I am having limited success by using the following formula

{ABSHST.adate} >= {?StartDate} and
{ABSHST.adate} <= {?EndDate} and
{ABSHST.Empnr} = {?emp}

 

[lbass]

Where did you develop this formula? Are you sure you are in the record selection formula area?

You are not using a subreport are you?

-LB

 

[WalfdPD]

This formula was developed using the "record selection formula editor". Not being an experienced user of crystal reports I am not sure if I am using a sub report, but I don't think I am.
As I said I am having limited success, I think I need to fine tune the startdate and enddate parameters