VS 2005 Crystal Reports SQL Server  moving to production web server from development machine

Posted on 2008-09-29
Last Modified: 2013-11-26
I have created some VS 2005  Crystal Reports on my development machine that use a SQL Server DB . I entered the connection info when I made the reports. These run fine on my development machine but the production web server's SQL server 's name is different from the one on my development machine. I need a way to design the report on my development machine then run it on other servers with different SQL Server names.  

I have attached code for what I have attempted so far. I put the appsettings in my webconfig at the end of the code snippet. The code is something I downloaded while trying to research this.

When I run it the section that reads the config file does not see anyy application settings so
  If (0 < rootWebConfig1.AppSettings.Settings.Count) is false . That's one problem.

The other is when it runs it has no effect at all on my development machine - the report seems to get connection info from the report and ignore the attached code . When it runs on the production machine I get an error that it can't find the server. I changed the webconfig on the production server to show the correct value for the SQL Server there in AppSettings but the code doesn't seem to have any effect on the report connection.

SO what I want to do is develop a Crystal Report on my development machne using VS 2005  and have it still work on the production web server using that machine's SQL Server.  This must be a really common thing to do for everyone. Can you make my code work or suggest an altogether easier way to approach this?
Imports CrystalDecisions.CrystalReports.Engine

Imports CrystalDecisions.Shared

Imports System.Collections

Partial Class LE100_LE_100MainReport

    Inherits System.Web.UI.Page

    Public LE100 As New ReportDocument

    Protected Sub Page_Init(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Init


    End Sub

    Protected Sub ConfigureCrystalReports()

        Dim this As String

        Dim rootWebConfig1 As System.Configuration.Configuration

        rootWebConfig1 = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration(Nothing)

        If (0 < rootWebConfig1.AppSettings.Settings.Count) Then

            Dim customSetting As System.Configuration.KeyValueConfigurationElement

            customSetting = rootWebConfig1.AppSettings.Settings("LE100DB")

            If Not (Nothing = customSetting.Value) Then

                this = customSetting.Value

            End If

        End If

        Dim myConnectionInfo As ConnectionInfo = New ConnectionInfo()

        myConnectionInfo.ServerName = this

        Dim thing As String = ""

        Select Case Session("Le100Report")

            Case "ZIP"

                thing = "le100 zip then strt param.rpt"

            Case "OFR"

                thing = "le100 officer zip street.rpt"

            Case Else

                thing = "Le100 zip then strt.rpt"

        End Select


        Dim rpt As String

        rpt = Server.MapPath(thing)



        Me.CrystalReportViewer1.ReportSource = LE100

    End Sub

    Private Sub SetDBLogonForReport(ByVal myConnectionInfo As ConnectionInfo)

        Dim myTableLogOnInfos As TableLogOnInfos = CrystalReportViewer1.LogOnInfo()

        For Each myTableLogOnInfo As TableLogOnInfo In myTableLogOnInfos

            myTableLogOnInfo.ConnectionInfo = myConnectionInfo


    End Sub

+++++++++from Webconfig below

 <location allowOverride="true">


      <add key="CrystalImageCleaner-AutoStart" value="true" />

      <add key="CrystalImageCleaner-Sleep" value="60000" />

      <add key="CrystalImageCleaner-Age" value="120000" />


      <add key="LE100DB" value="TOMKOVICLAP3" />






Open in new window

Question by:tomkovic
LVL 100

Accepted Solution

mlmcc earned 500 total points
ID: 22599347

Author Comment

ID: 22600431
Well, I normally would not consider referring me to a 500 page document as a real answer but I did find out a much simpler way to do it in that document. The jist of it is that I let the form designer do it with smart tags. I dragged a CrystalReportViewer control then a CrystalReportSource control then a SQLDataSource control. I configured the datasource control to the correct logon connection in my webconfig file then set the CrystalReportCource  datasource to that datasource bby going into the CrystalReportSource' s properties then expanding the Report noded then clicking the elipsis which brought up the data sources collection. I added the datasource to that and specified the data table.

None of this worked until I set the crystalReportViewer  Enable Database Logon  to true in the designer.

See the document that mimcc referred to above for details

Featured Post

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Suggested Solutions

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

706 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now