Asked By bh
19-Mar-10 12:44 PM

I have a crystal report (8.5) based on a SQL2K Stored procedure that accepts
a single bit parameter (@Qual), which defaults to 0 in the procedure.
When I run the report from crystal, it works fine, whether I select true or
false.
When I run the report from .NET, no matter what I send to the discrete
parameter, it filters out only the true (1) records.
Imports CrystalDecisions.Shared
Dim paramField As ParameterField = New ParameterField
Dim dscVal As ParameterDiscreteValue = New ParameterDiscreteValue
-----set dscVal using one of the following scenarios, below----
paramField.CurrentValues.Add(dscVal)
Scenario 1: (returns only records with @Qual = 1 in the database)
dscVal.Value = False
-OR-
Scenario 2: (returns only records with @Qual = 1 in the database)
dscVal.Value = 0
-OR-
Scenario 3: Errors out, as you can not pass chr() data into a discrete value
dscVal.Value = Chr(168)
Any help you could offer to get this operational would be appreciated.
Thanks in advance.
bh