Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

ServerName Property in Code Being Ignored

It seems that the connectionInfo.ServerName = "XXX"; property in my code is being ignored. No matter what I type in there, it keeps trying to use the ServerName that was used for the report creation. Unfortunately, that was my development server and now I need it to use my clients production server. It applies the user and pass correctly as I tried changing those values in the code and it reflected in the login prompt that eventually appears.

I'm fairly certain my code is right as I relied on the VS2005 walkthrough for a lot of it but I am also new to Crystal Reports. Any help would be appreciated.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

namespace Val_Report
    public partial class Form1 : Form

        public Form1()

        private void Form1_Load(object sender, EventArgs e)
                //Set up database and report path

                //Set Report Dates Initially at first of month to current date

                //Get first day of month
                DateTime firstDay = DateTime.Now;
                DateTime FirstDayInMonth = new DateTime(firstDay.Year, firstDay.Month, 1);
                string strStartDate = FirstDayInMonth.ToShortDateString();
                //Set the orderStartDate TimePicker to value
                orderStartDate.Value = FirstDayInMonth;

                //Get current date
                string strEndDate = DateTime.Now.ToShortDateString();

                //Set the orderEndDate TimePicker to value
                orderEndDate.Value = DateTime.Now;

                //Set up my report parameters (date, etc)
                setReportParameters(strStartDate, strEndDate);

        private void ConfigureCrystalReports()
                //Set up sql connection
                ConnectionInfo connectionInfo = new ConnectionInfo();
                connectionInfo.ServerName = "Database";
                connectionInfo.DatabaseName = "db_name";
                connectionInfo.UserID = "test";
                connectionInfo.Password = "test";
                connectionInfo.IntegratedSecurity = false;

                //Set report path
                string reportPath = Application.StartupPath + "\\" + "ValidationView.rpt";
                crystalReportViewer.ReportSource = reportPath;

                // Loop through main report and set connection info


        private void SetDBLogonForReport(ConnectionInfo connectionInfo)
            TableLogOnInfos tableLogOnInfos = crystalReportViewer.LogOnInfo;
            foreach (TableLogOnInfo tableLogOnInfo in tableLogOnInfos)
                tableLogOnInfo.ConnectionInfo = connectionInfo;



        private void crystalReportViewer_Load(object sender, EventArgs e)


        private void setReportParameters(string strStartDate, string strEndDate)

                // all the parameter fields will be added to this collection 
                ParameterFields paramFields = new ParameterFields();

                // the parameter fields to be sent to the report 
                ParameterField pfStartDate = new ParameterField();
                ParameterField pfEndDate = new ParameterField();

                // setting the name of parameter fields with wich they will be recieved in report 

                pfStartDate.ParameterFieldName = "StartDate";
                pfEndDate.ParameterFieldName = "EndDate";

                // the above declared parameter fields accept values as discrete objects 
                // so declaring discrete objects 
                ParameterDiscreteValue dcStartDate = new ParameterDiscreteValue();
                ParameterDiscreteValue dcEndDate = new ParameterDiscreteValue();

                // setting the values of discrete objects 

                dcStartDate.Value = DateTime.Parse(strStartDate);
                dcEndDate.Value = DateTime.Parse(strEndDate);

                // now adding these discrete values to parameters  


                // now adding all these parameter fields to the parameter collection 


                /* Set the modified parameters collection back to the viewer so that
                 the new parameter information can be used for the report. */
                crystalReportViewer.ParameterFieldInfo = paramFields;

        private void redisplay_Click_1(object sender, EventArgs e)

           // ConfigureCrystalReports();
            string strStartDate = orderStartDate.Text;
            string strEndDate = orderEndDate.Text;

            string reportPath = Application.StartupPath + "\\" + "ValidationView.rpt";
            crystalReportViewer.ReportSource = reportPath;

            setReportParameters(strStartDate, strEndDate);

        private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
            Form about = new Validation_Report.About();



Former Member
Not what you were looking for? View more on this topic or Ask a question