report you requested requires further information?

[vbjohn]

The report you requested requires further information.

It gives me the Server Name: OrderSystem
It gives me the Database Name: Orders
Then it asks me for the user name and password.

so I fill in the user name and password. then i click on Log On. then it generates. then it comes up with the same thing eveytime that i click on Log On.

Anyone know how to fix it?

I am using Crystal Reports 10 and ASP.NET

[josey_rick]

First make sure you have unselected the three verify options under advanced options in the options menu. Did you use a logon function similar to the following:

private sub LogOn(ByVal poReport As CrystalDecisions.CrystalReports.Engine.ReportDocument)

Dim lsMethod As String = System.Reflection.MethodBase.GetCurrentMethod().Name

Dim loConnInfo As New CrystalDecisions.Shared.ConnectionInfo

Dim lsMode As String = ConfigurationSettings.AppSettings("Mode")


loConnInfo.ServerName = "YourServer"

loConnInfo.DatabaseName = "YourDB"

loConnInfo.UserID = "User"

loConnInfo.Password = "Password"


Dim loTables As CrystalDecisions.CrystalReports.Engine.Tables

Dim loTable As CrystalDecisions.CrystalReports.Engine.Table

Dim loTableLogonInfo As CrystalDecisions.Shared.TableLogOnInfo


loTables = poReport.Database.Tables

For Each loTable In loTables

loTableLogonInfo = loTable.LogOnInfo

loTableLogonInfo.ConnectionInfo = loConnInfo

loTable.ApplyLogOnInfo(loTableLogonInfo)

Next

End Sub


And you need to use the Databind method to display your report.
Set the databind property of your report viewer to your report document. And the filename of your reprot document to your .rpt file. Then call:

LogOn(reportDocument1)
CrystalReportViewer1.DataBind()

I hope this helps. I'm using Crystal reports V10 and vb.net.