Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

passing parameters

Status
Not open for further replies.

pashu

Programmer
Sep 14, 2003
24
IN
Hello Freinds,

I've passed the parameters for the report it is working fine but when i give the parameters such as from month 03 and year 03 and to month 02 and year 04,it gives the error "The minimum cannot be greater than maximum',i have understood the problem but is there any other way to pass the parameters by coding in crystal reports ,if yes please send me the sample coding if possible.

Thanks & Regards,
Pashu.
 
Which Crystal? In Crystal 8.5, I'd translate the month and year into actual dates, e.g.
Code:
Date (?Year-start, ?month-start, 01)

Put this in a formula field, and another for the end. Or you could make use of Crystal's versatility, getting the last day of the month regardless of month length
Code:
Date (?Year-end, ?month-end - 1, 01) - 1

Madawc Williams
East Anglia, Great Britain
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top