I have an application built using visual studio 2005. there are crystal reports in this application. I installed .NET framework 2, MDAC 2.8 and CRRedist.msi on the app server.When i open a page with a crystal report i am getting the error:

"The report you requested requires further information"
DSN Name

SeverName: myserver
DatabaseName: mydatabase
UserName:
Password:

Use Integrated Security

I have set up the DSNs to point to the machine where the database is.

I am nearly there I think but I cant figure out how to get rid of this error. Would really apprecaite any suggestions that you might have on this.

Thanks and Regards,
Cathie

You need the folowing on your .vb page

Imports CrystalDecisions.CrystalReports.Engine

Partial Class _Default
    Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim report As New ReportDocument
        report.Load(Server.MapPath("the name of the report.rpt"))
        report.SetDatabaseLogon("some username", "some password")
        Me.CrystalReportViewer1.ReportSource = report
    End Sub
End Class

more info at the following link
http://ms-help://MS.VSCC.v80/MS.MSDN...bjectmodel.htm

Hi Cathie,

I understand you had this problem long time ago, but I have it now.
I've created the application in VS.NET 2003 and reports in Crystal XI. The database is located on the separate server and all reports are using ODBC connection. The application used to work fine on the old Windows 2000 Server and work fine on my developer PC which has Windows XP Pro. But after they have changed the application server to a new one I am having the error you had.

Any help will be helpful.
Thanks in advance,
Dmitriy

hello world!

Instead of passing a dataset object in SetDataSource(...), you have to pass an actual table in it that contains the data.see the code below:

customerReport.SetDataSource(ds.Table[0]);
CrystalReportViewer1.Visible = true;
CrystalReportViewer1.ReportSource = customerReport;
CrystalReportViewer1.DataBind();

Hope this will work!

Thanks a lot sraheel...Its working for 1st time... but if click agian its showing prev error messg...