
Pass parameter to a MS SQL stored procedure from Crystal Report 6.0
Hi Helen,
we are using the same products with the crystal web server. the syntax for
parameters in stored procedures:
http://IP-Adress/reports/400164.rpt?init=actx&sf=&rf=1&user0=user&pas...
password&sproc0=400.164&sproc1=000&sproc2=21.12.98&sproc3=04.01.99&sproc4='X
'
Armin
Helen Wang schrieb in Nachricht ...
Quote:
>Hi,
>We need to create crystal reports without the VB front end. The MS SQL
>server stored procedure does the data selection based on the parameters
>passed to it. Can anyone tell us how to pass the parameter to the stored
>procedure via Crystal Reports? Only constant values can be specified under
>the Crystal Reports stored procedure Parameters tab under Database.
>Any help is deeply appreciated!