Hi,

Is it possible to connect to a datasource without using a DSN in Crystal Reports.Net?

If so, how is it done? I've tried different things in the Database Expert but no luck. I already have a global connection string in my web config and I would like to use that if possible.

Thanks

Are you creating console application or web??? 

http://forums.asp.net/t/1256406.aspx

hi

i am using .net 2005. in my project i am using crystal reports.while exporting the crystal reports to pdf  the barcode font is decreasing because of that i am not able to read the barcode with barcode reader and also the size is very small. please tell me the solution as soon as possible

Thanks

Regards

A.rajesh

web

I am creating reports in a web application.

Thanks joseabie

I was able to connect but I'm not sure how to integrate this into my application. I'm used to Crystal Reports 8.5 with VB where I can drag field items onto my report. Is this still possible with your method?

I did a quick mockup of a form: 

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim cn As New SqlConnection(MainConnectionString)
        Dim cm As New SqlCommand()

        cm.Connection = cn
        cm.CommandText = "MyStoredProc"
        cm.CommandType = Data.CommandType.StoredProcedure

        Dim da As New SqlDataAdapter
        da.SelectCommand = cm

        Dim ds As New Data.DataSet

        da.Fill(ds, "MyStoredProc")
        Try
            rpt.Load(Server.MapPath("../../MyReport.rpt"))
            rpt.SetDataSource(ds)
            Me.CrystalReportViewer1.ReportSource = rpt

        Catch ex As Exception

        End Try

    End Sub

Actually i am using CR11, ASP.Net 2.0 VB,,

when you connect the report with database select

Project Data (hope you added your storedprocedure in dataset)

-> expand .Net objects -> you an c your stored procedure

-> select your procedure -> update....

now you can add the table fields in to your reports