<b>HELP!!! Parameter field value is not range.</b>

[snazzyCrunch]

I received this message when trying to pass a date range value to a report from an ASP page. Here's the snippet of code....

set session("ParamCollection&quot = Session ("oRpt&quot.Parameterfields
set Param1 = session("ParamCollection&quot.Item(1)

ParamValue = "04/29/02"
ParamValue1 = "05/03/02"

Call Param1.AddCurrentValue (CStr(ParamValue))
Call Param1.AddCurrentValue (CStr(ParamValue1))

**The string data type is correct as this is how the DB was setup. Even though we are searching for dates in between 04/29/02 and 05/03/02. The data type string does work.

Again, the message I receive is "Parameter field value is not range."

On the actual report the parameter field is defined as "Range Values" and it does not enable multiple values.

This code works when passing multiple string values, but the range values is throwing me off.

Thanks in advance :0

 

[synapsevampire]

Range Values probably require a more explicit set.

When I extract date ranges from a parameter in Crystal I use something like this:

Firststartrange = minimum({?MyDateRange}[1])
Endstartrange = maximum({?MyDateRange}[1])

So as you can see the date range parameter has a subscript value and a minimum/maximum.

Hope this helps.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com