We help IT Professionals succeed at work.
Get Started

Crystal Reports 2008 for Visual Studio 2008

pgkdavefdd
pgkdavefdd asked
on
291 Views
Last Modified: 2012-05-11
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.
Comment
Watch Question
Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
This problem has been solved!
Unlock 1 Answer and 6 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE