I am developing a report that accesses a remote SQL2008 server DB. In that report I need to pass 2 parameteres that are prompted for. BillDate and DueDate When I run the report locally it rund correctly but when I run it from my website, I am prompted for the parameters when I select print to press the next arrow. How do I correct my newinvoice.asps.vb form to pass and retain the paarameters? The following is my vb code for that page:
Imports CrystalDecisions.CrystalReports.Engine
Imports CrystalDecisions.Shared
Partial Class NewInvoice
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("NewBillInvioceCrystalReport.rpt"))
SetTableLocation(report.Database.Tables)
CrystalReportViewer1.ReportSource = report
End Sub
Private Sub SetTableLocation(ByVal tables As Tables)
Dim connectionInfo As New ConnectionInfo()
connectionInfo.ServerName = "MyServer"
connectionInfo.DatabaseName = "ICCTowerFund"
connectionInfo.UserID = "UserID"
connectionInfo.Password = "Password"
For Each table As CrystalDecisions.CrystalReports.Engine.Table In tables
Dim tableLogOnInfo As TableLogOnInfo = table.LogOnInfo
tableLogOnInfo.ConnectionInfo = connectionInfo
table.ApplyLogOnInfo(tableLogOnInfo)
Next
End Sub
Any Help is greatly appreciated.