Skip navigation links

MySQL Forums :: Analytics, Reporting, BI :: Crystal Reports and Visual Studio 2005


Advanced Search

Crystal Reports and Visual Studio 2005
Posted by: Randy Kling ()
Date: March 24, 2008 06:23PM

I am attempting to make a Crystal Reports viewer to display reports external to the viewer. The viewer is to display reports for a seperate application I'm writing. I want to be able to call the viewer and send it a parameter list with the database location, username. password, report file name and location, and then some other parameters specific to the report. I have the viewer working on my development machine when I use the MySQL database local to the development machine. However, when I log in to a MySQL database on a remote server the reports displayed are still from the database on the development machine. I send the viewer the IP to the other machine along with the username and password for the server machine, but I still get reports based on the development machine. I am using C# and Visual Studio 2005 to develop the viewer. What I would like to know is how to get the C# program to pass the server IP, username and password to the report so that it will access the server, and not the development machine. The applications will be deployed to other machines and when the user logs into my application it is logging into MySQL on whatever machine they are using; it could be local, or it could be remote. So I pass the login info to the viewer to pass to the report so it will know where to find its data. The following is the C# code that I have so far. This code is based on "Crystal Reports For Visual Studio 2005 Walkthroughs" which was downloaded from the Crystal Reports website. Unfortunately the walkthrough are based on MS SQL Server and not MySQL.

I forgot to mention: I want to use SQL authenticationa nd do not want to use ODBC and DSN, as the applications will be deployed to other machines.

Thanks for your help.

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;
using System.Collections;

namespace CRViewer
{

public partial class Form1 : Form
{
//private const string PARAMETER_FIELD_NAME = "City";

public Form1()
{
InitializeComponent();
}

private void ConfigureCrystalReports()
{

String[] arguments = Environment.GetCommandLineArgs();

if (arguments.GetLength(0) < 6)
{
MessageBox.Show("Usage: CRViewer server database username password reportname");
Application.Exit();
}

//for (int i = 0; i < arguments.GetLength(0); i++)
// MessageBox.Show(arguments);

ConnectionInfo connectionInfo = new ConnectionInfo();
connectionInfo.ServerName = arguments[1]; // server location
connectionInfo.DatabaseName = arguments[2]; // database name
connectionInfo.UserID = arguments[3]; // user name
connectionInfo.Password = arguments[4]; // password
// 5 report name.rpt
// 6 parameter list
// 1 - 1 string
// 2 - 2 strings
// 3 - 1 int
// 7 Report Number
// 8 Parameter 1
// 9 Parameter 2
string selectFormula = "";
if (arguments.GetLength(0) > 6)
{
if (arguments[6] == "1")
{

}
else if (arguments[6] == "2")
{
if ((arguments[7] == "1") || (arguments[7] == "2") ||(arguments[7] == "3") ||(arguments[7] == "4") ||(arguments[7] == "9"))
selectFormula = "{library.Category} = \"" + arguments[8] + "\" AND {library.AccessionNumber} >= \"" + arguments[9] + "\"";
else
selectFormula = "{library.Category} = \"" + arguments[8] + "\" AND {library.AccessionNumber} = \"" + arguments[9] + "\"";
crystalReportViewer.SelectionFormula = selectFormula;
}
else if (arguments[6] == "3")
{

}
}

string reportPath = arguments[5];
crystalReportViewer.ReportSource = reportPath;
SetDBLogonForReport(connectionInfo);
}

private void Form1_Load(object sender, EventArgs e)
{
ConfigureCrystalReports();
}

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

}
}
}
}



Edited 1 time(s). Last edit at 03/24/2008 06:26PM by Randy Kling.

Options: ReplyQuote


Subject Written By Posted
Crystal Reports and Visual Studio 2005 Randy Kling 03/24/2008 06:23PM
Re: Crystal Reports and Visual Studio 2005 sheril sher 04/15/2009 04:06AM
Re: Crystal Reports and Visual Studio 2005 sheril sher 05/05/2009 01:10AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.