troubleshooting Question

Crystal Reports 2008 for Visual Studio 2008

Avatar of pgkdavefdd
pgkdavefddFlag for United States of America asked on
Crystal Reports
6 Comments1 Solution294 ViewsLast Modified:
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.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 6 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros