Handling multiple optional parameters in Crystal Reports.
Posted on 2006-07-03
I am having trouble in handling multiple parameters in crystal reports all of which are optional.
The follwing is the best analogy of what i am supposed to do.
from date:: the date from which the record are to be fetched
to date:: the date upto which the records are to be fetched
job:: job parameter where records fetched are of specific job
deptno:: records required of specific deptno
ename:: record of that employee to be fetched.
the user can pass either a single parameter or all the above.passing more parameters wil help in filtering his requirement.
If only from date is passed the all records which have date of joing after that date should be fetched
If both from and to are mentiond then date of joining is supposed to between those dates.
I hope my problem is clear.I am using Crstal reports 6.5