Website Design United States, Website Design California, Website Designing United States, Website Designing California

Crystal Reports Using Stored Procedure with Parameters - Visual Basic .NET

Siddharth sinha

The User sometime faces a problem to prepare Crystal Reports using Stored Procedure in .NET. Passing a parameter into a report can be difficult.

Using the code:
First, create a Stored Procedure which takes a parameter. Now use this Procedure in creating a crystal report. In VB.NET Crystal Report is built-in.

Now you have a crystal report which asks for parameter value, which should be passed by your program, Not with an input box.

// Any source code blocks look like this
Imports System.Data.SqlClient
Imports System.Data
Imports System.Data.Common
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared

Public Class Form1 Inherits System.Windows.Forms.Form

#End Region

Public reporttype As String
//creating an object of the crystall report
Public cr3 As New CrystalReport3

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load

End Sub

//calling the report on keypress property
Private Sub txtExch_KeyPress(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyPressEventArgs) Handles txtExch.KeyPress
If e.KeyChar = Microsoft.VisualBasic.ChrW(13) Then
e.Handled = True

//setting first parameter as the report ask for two parameter
cr3.SetParameterValue(0, txtOrgName.Text)

//setting second parameter as the report ask for two parameter
cr3.SetParameterValue(1, txtExch.Text)

// set the Crystal report viewer as the the cr3 ( the object of the crystal report)
CRViewer.ReportSource = cr3

End If

End Sub
End Class


© 2008-2009