[RESOLVED] CR Report Between 2 Dates?
Hi,
I am trying to set up a report that takes 2 dates as parameters and will report everything between them. I have one field called birthdays and I want the report to show them all between the 2 dates that the user gives.
Anyone Know how I would set this up?
Re: CR Report Between 2 Dates?
You can either set it in the SelectionFormula or by filtering your datasource object.
Re: CR Report Between 2 Dates?
Actually I messed up... I need the parameter to be a month and report to show all the of the records with that month in the birthday field. Passing the parameter shouldn't be a problem. The problem lies in the syntax of the expression I think....
Any ideas?
Re: CR Report Between 2 Dates?
Can you post your code? I have some code on the forums for passing parameters for the report.
Re: CR Report Between 2 Dates?
The record selection formula in Crystal would simply be (assuming @Month parameter is the month number)
Month ({TableName.BirthDate}) = {?@Month}
Re: CR Report Between 2 Dates?
Quote:
Originally Posted by brucevde
The record selection formula in Crystal would simply be (assuming @Month parameter is the month number)
Month ({TableName.BirthDate}) = {?@Month}
This works thanks guys.