Passing parameter from Crystal OCX to a report that uses a stored procedure
Try Clearing your parameters first before you set them to new values
I know that the formulas must be cleared otherwise they persist from
report to report. Example when we have a report that uses 3 formulas
and the next report uses only 1 formula we clear three formulas and
then re-init the single formula to its ne value. I'm not sure but
Ibelieve that parameters obey the same rules.
Quote:
> Hi,
> I design reports with CR7 Pro Designer and I call my reports with
>Crystal Reports OCX in VB 5. My report uses an Access 97 parametrized query
>through ODBC, the option "Save data with report is not checked".
>When I print my report in VB, I transmit it new values for my parameters.
>These parameters are used :
>- In the report's header that display the new values : it's OK
>- For my query that uses old values : why doesn't it take my new values ?
>I tried two syntax :
>With CrystalReport1
> .ParameterFields(0) = "Param1Name;Param1Value;TRUE"
> .PrintReport
>End With
>With CrystalReport1
> .StoredProcParam(0) = "Param1Value"
> .PrintReport
>End With
>None of them works.
>Does anyone has an idea ?
>Thanks,
>Cyrille Le Clerc
>------------------------------------------------
>Cyrille Le Clerc
>------------------------------------------------
>Remove "no-spam."