Crystal Report based on SQL Server Stored Procedure with Parameters 
Author Message
 Crystal Report based on SQL Server Stored Procedure with Parameters

I'm trying to run report from VB.NET application this way:

Dim logonInfo As New CrystalDecisions.Shared.TableLogOnInfo()
Dim objTable As CrystalDecisions.CrystalReports.Engine.Table
Dim objReport As New ReportDocument()
Dim reportName As String

reportName = "S:\CoordinatorNGData\Reports\" & TextBox1.Text
objReport.Load(reportName)
For Each objTable In objReport.Database.Tables
    logonInfo = objTable.LogOnInfo
    logonInfo.ConnectionInfo.ServerName = "65.115.116.28"
    logonInfo.ConnectionInfo.DatabaseName = "myDB"
    logonInfo.ConnectionInfo.UserID = "user"
    logonInfo.ConnectionInfo.Password = "myPwd"
    objTable.ApplyLogOnInfo(logonInfo)
Next objTable

CrystalReportViewer1.ReportSource = objReport
CrystalReportViewer1.Zoom(1)
CrystalReportViewer1.DisplayGroupTree = False
CrystalReportViewer1.BackColor =
System.Drawing.ColorTranslator.FromOle(RGB(140, 0, 180))

While the report is based on View, everything is fine. But I'd like to
create another report based on Stored procedure wuith Parameters. Where and
how do I pass parameters to Stored procedure?

Thank you
vovan



Wed, 15 Jun 2005 03:38:23 GMT  
 
 [ 1 post ] 

 Relevant Pages 

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

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

3. Pass parameter to a MS SQL stored procedure from Crystal Report 6.0

4. New Stored Procedure Parameter (SQL Server 7) isn't recognized in CR7 Report Designer

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

6. Assign Stored Procedure of SQL Server with Crystal report

7. Crystal Reports 8.5, SQL Server 2000, and Stored Procedures

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

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

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

11. Stored Procedure Parameters to Crystal Reports

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

 

 
Powered by phpBB® Forum Software