Avatar of pgkdavefdd
pgkdavefdd
Flag for United States of America

asked on 

Crystal Reports 2008 for Visual Studio 2008

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.
Crystal Reports

Avatar of undefined
Last Comment
pgkdavefdd

8/22/2022 - Mon