Hi Crystal Guru
Sorry but I am a newbie to Crystal 9 and need a bit of help. The answer is probably dead easy but I would appreciate your advice nonetheless.
Okay I have access to my database and can select columns from the table and place into the report in one horizontal line. Now if I run the report the it lists every single row from that table. However what I need to do is apply a date restriction so that it only returns data specified between a date range.
For example: I have an employee table called emp with 5 employees (4 of which joined last month and 1 joined this week) and select the report to return their first and last names. Now when I run the report I get all 5 entries, however I want the report to only return the employees who joined in the last week, i.e. the 1 employee.
How do I set this up?
Cheers
David
Sorry but I am a newbie to Crystal 9 and need a bit of help. The answer is probably dead easy but I would appreciate your advice nonetheless.
Okay I have access to my database and can select columns from the table and place into the report in one horizontal line. Now if I run the report the it lists every single row from that table. However what I need to do is apply a date restriction so that it only returns data specified between a date range.
For example: I have an employee table called emp with 5 employees (4 of which joined last month and 1 joined this week) and select the report to return their first and last names. Now when I run the report I get all 5 entries, however I want the report to only return the employees who joined in the last week, i.e. the 1 employee.
How do I set this up?
Cheers
David