Click to See Complete Forum and Search --> : Checking a range of dates
ryanlum
Mar 17th, 2005, 07:06 PM
hey guyz.. if lets say that i got
hey.. if i got 2 parameters.. one is the starting date. the other parameter is the range that the user selected..
1st param - starting date
2nd param - 6 months down the road
how do i search the report starting from the first date and then search for records 6 months down the road
RobDog888
Mar 17th, 2005, 09:24 PM
You can pass two parameters like so...
moReport.ParameterFields.Item(1).ClearCurrentValueAndRange
moReport.ParameterFields.Item(1).AddCurrentValue dStartDate
moReport.ParameterFields.Item(2).ClearCurrentValueAndRange
moReport.ParameterFields.Item(2).AddCurrentValue dEndDate
How are you opening your report and setting the datasource?
ryanlum
Mar 18th, 2005, 12:18 AM
i mean in the crystal report itself
how do i set it to search for a date range
like starting from the beginning of the year to 6 months down the road?
RobDog888
Mar 18th, 2005, 12:23 AM
Use the record selection formula editor then.
ryanlum
Mar 18th, 2005, 07:01 AM
yiah..
whats the coding for it?
like i start from date x.. then i want to search 6 months later..
how do i set the coding for the 6 months....
vbforums.com
Copyright Internet.com Inc., All Rights Reserved.