[2005] Generate Report between two dates
Hi i have some problem in genrating report between two dates
I have designed the crystal reports for that and it is multiple tables
Now i want to find the records between two dates which are passed by user
And then i want to generate the report between that dates
Can anyone help me ? please
Thank you in advance :)
Need help badly :(
Re: [2005] Generate Report between two dates
Could be
1.- Ask for the dates range inside the application, generate the table or recordset or dataset that crystal reports will read
or
2.- In Crystal Reports, insert a parameter field that ask the user for a range of dates and use that Parameter field in the Record Selection formula
Re: [2005] Generate Report between two dates
Quote:
Originally Posted by jggtz
Could be
1.- Ask for the dates range inside the application, generate the table or recordset or dataset that crystal reports will read
or
2.- In Crystal Reports, insert a parameter field that ask the user for a range of dates and use that Parameter field in the Record Selection formula
Thank you for your reply.
First thing i can pass two dates in the parameeter value but in function i cannot find the Between And Operator for the forumla
Re: [2005] Generate Report between two dates
Considering that the Range of Dates Parameter Field is an array, then your RecordSelectionFormula should be as :
Code:
{Table.DateField} IN {?DateRangeParameter}