dynamic connection in crystal report

[mohanmsc]

hi guys

I developed an web application in asp.net and i am generating reports using crystal report. what my problem is i place the field values in design time only, so my connection information are also selected in design time. if the report is deploy to online server. how i give the connection information in design time..

i want the connection information dynamically (i.e doing in code behind side)..




thanks lot

 

[dvannoy]

This is an example of using the push method and a SQL SP.


Dim crReport As New YourReportName()

Page Load..

Dim cn As SqlConnection = New SqlConnection()
Dim dsReport As New DataSet()

Set your connection string..

for help with strings go to

http://www.connectionstrings.com

Dim cmd As New SqlCommand()

With cmd
.Connection = cn
.CommandType = CommandType.StoredProcedure
.CommandText = "YourSP"
End With

Dim DA As New SqlDataAdapter(cmd)

cn.Open()

Dim crDatabase As CrystalDecisions.CrystalReports.Engine.Database
Dim crTables As CrystalDecisions.CrystalReports.Engine.Tables
Dim crTable As CrystalDecisions.CrystalReports.Engine.Table

DA.Fill(YourDataSetName, "YourSP")

crDatabase = crReportDoc.Database
crTables = crDatabase.Tables
For Each crTable In crTables
crTable.SetDataSource(YourDataSetName)
Next

YourReportName.ReportSource = crReport

cn.Close()


There are tons of examples on the web...search around you will find them.