Tearing my hair out here!!!
I have created 3 reports, all very similar and all using the same database. 2 work fine, but one gets the error " The report you requested requires further information." when I am trying to load it into a web browser.
The code in the aspx.vb page is identical as those in the other report pages, except for the report pages.
This leads me to believe I am missing a setting in crystal reports itself. I am using CR 2008. There are 5 tables used in the reoprts I can verify the database ok.
The code to grab the report is as below:
Private report As New CrystalDecisions.CrystalReports.Engine.ReportDocument
Private Sub ConfigureCrystalReports()
report.Load(Server.MapPath("BuildingAndEstate.rpt")) 'Loading the report
report.Database.Tables(0).LogOnInfo.ConnectionInfo.ServerName = ConfigurationManager.AppSettings(
"ServerName")
report.Database.Tables(0).LogOnInfo.ConnectionInfo.DatabaseName = ConfigurationManager.AppSettings(
"ServerDatabase")
report.SetDatabaseLogon(ConfigurationManager.AppSettings(
"ServerUserId"), ConfigurationManager.AppSettings("ServerPassword"))
report.DataDefinition.RecordSelectionFormula =
"{vwBuildingAndEstateReport.Property Ref} = '" & Request.QueryString("id") & "'"
CrystalReportViewer1.ReportSource = report
CrystalReportViewer1.ToolPanelView = CrystalDecisions.Web.ToolPanelViewType.None
End Sub
Any ideas?? Please??
Thanks
IP Logged