Pass parameter to a MS SQL stored procedure from Crystal Report 6.0 
Author Message
 Pass parameter to a MS SQL stored procedure from Crystal Report 6.0

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!



Thu, 21 Jun 2001 03:00:00 GMT  
 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!



Fri, 22 Jun 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Crystal - passing parameters to SQL stored procedure

2. Passing Parameters to Crystal Report 5.0 (Stored Procedure Query )

3. Problem with VB passing parameters to Crystal Report - Stored Procedure

4. Passing Stored Procedure parameters via VB6 into Crystal Report (ver 8)

5. passing Parameter from Vb to Stored Procedure In crystal reports

6. Passing parameter from Crystal OCX to a report that uses a stored procedure

7. VB.NET,SQL SERVER 2000 STORED PROCEDURE PARAMETERS, CRYSTAL REPORTS

8. Crystal Report based on SQL Server Stored Procedure with Parameters

9. Stored Procedure parameters passing in CR 6.0

10. Crystal Reports/SQL 2000 - Reporting from a Stored Procedure with multiple selects (for a sub-report)

11. Crystal Reports/SQL 2000 - Reporting from a Stored Procedure with multiple selects (for a sub-report)

12. MS SQL Server 6.0 stored procedures

 

 
Powered by phpBB® Forum Software