Call SQL stored procedure in VB5.0 and print report to Crystal report 
Author Message
 Call SQL stored procedure in VB5.0 and print report to Crystal report

Hello!
I have designed a report with Crystal
report 4.61 and I want to call Sql stored procedure in VB5.0.
the example is...

With CrystalReport1
.SQLQuery = "Exec erbcompile..erpr_plancost1 '"
& Form1.Combo1.Text & "' "
.LogonInfo(0) = "DSN =erl_dp2;UID =erlmis;PWD =erlmis;"??it got a wrong msg
with "Do not use connect property or logoninfo property!!"
.ReportFileName = "C:\test\test.rpt"
.DiscardSavedData = True
.Destination = 0
.Action = 1
End With

I don't get it what is wrong???
Anybody help me??
thanks in advance...........:>

ITRI/ERL  Engineer  :  Maggie




Fri, 06 Jul 2001 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

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

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

3. Calling Crystal Report from VB, repo is based on Stored Procedure in Sql Server

4. Linking Crystal Report with a stored Procedure -- crystal report for visual studio.net

5. Printing Crystal Reports without Crystal Control ActiveX or Crystal Reports API call

6. sub report changes its source stored procedure to main report's stored procedure

7. calling an Oracle stored procedure from Crystal Reports

8. Crystal Report calling stored procedures on Oracle

9. report based on a stored procedure , crystal reports and vb6

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

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

12. Assign Stored Procedure of SQL Server with Crystal report

 

 
Powered by phpBB® Forum Software