Dynamic Database Connection in Crystal Report 13...?

Question

5.00/5 (1 vote)

See more:

I have one ASP.NET (C#) Project and i am using Crystal Report for generating reports..
and for report i am using MS Access Database

Now my question is that when my project runs on client pc at that time my report will use the database which is held on client pc and when it will in my pc means at development that time report use my database...

Both database have same schema and data as well..

Means i want the database connection dynamically...

at client pc it will use client database and in my pc it will use my database...

I want to set database information at runtime....

Posted 2-Nov-11 19:15pm

Tejas Vaishnav

Updated 2-Nov-11 20:21pm

v2

Add a Solution

4 solutions

Solution 3

1.Create an object of ReportDocument say object name : objRpt.
objReport = new yourreportname();

2. Write following code :

C#

foreach (Table crTable in objRpt.Database.Tables)
            {
                TableLogOnInfo logOnInfo = new TableLogOnInfo();
                logOnInfo = objRpt.Database.Tables[crTable.Name].LogOnInfo;

                // Set the connection information for the table in the report.
                logOnInfo.ConnectionInfo.ServerName = server.Trim();
                logOnInfo.ConnectionInfo.DatabaseName = database.Trim();
                logOnInfo.ConnectionInfo.UserID = username;
                logOnInfo.ConnectionInfo.Password = password;
                objRpt.Database.Tables[crTable.Name].ApplyLogOnInfo(logOnInfo);

}
I hope you can get connection details from config

3. Create an object of CrystalReportViewer class say object name : objCrystalReportViewer
.

4. objCrystalReportViewer.ReportSource = objRpt;
5. objCrystalReportViewer.Show()

Posted 2-Nov-11 20:51pm

deepakdynamite

Updated 3-Nov-11 0:14am

v3

Solution 1

Dear friend

this is not possible as U r Saying, to achive this
Don't connect ur Crystal report directly with database
Add a dataset in ur project and add datatable in that dataset, now design ur fields in that
datatable and connect ur crystal report with that datatable, now dynamicly fill that datatable
by using this method U can make ur report dyanamic

Posted 2-Nov-11 19:58pm

Menon Santosh

Solution 2

Hi,

This is not possible in web application.
You have to set your database in hosting server.

Posted 2-Nov-11 20:07pm

keyur soni

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Tejas Vaishnav · Accepted Answer · 2011-11-03T00:12:00

Here i find this solution for My Question mentioned as above...

Here i have declare one Function that will set my database information at run time....

here setDbInfo is the function for seting db info this function will called after loding report to report document and before assining to report viewer like shown in DisplayReport function...

C#

protected void setDbInfo(ReportDocument rpt, string ServerName, string DatabaseName, string UserName, string Password)
        {
            TableLogOnInfo logoninfo = new TableLogOnInfo();
            foreach (CrystalDecisions.CrystalReports.Engine.Table t in rpt.Database.Tables)
            {
                logoninfo = t.LogOnInfo;
                logoninfo.ReportName = rpt.Name;
                logoninfo.ConnectionInfo.ServerName = ServerName;
                logoninfo.ConnectionInfo.DatabaseName = DatabaseName;
                logoninfo.ConnectionInfo.UserID = UserName;
                logoninfo.ConnectionInfo.Password = Password;
                logoninfo.TableName = t.Name;
                t.ApplyLogOnInfo(logoninfo);
                t.Location = t.Name;
            }
        }

        protected void DisplayReport()
        {
            try
            {
                ReportDocument rpt = new ReportDocument();
                rpt.Load(Server.MapPath("~/CRList.rpt")); 
                string ServerName = ConfigurationManager.AppSettings["Server"].ToString();
                string DatabaseName = ConfigurationManager.AppSettings["DBName"].ToString();
                string UserName = ConfigurationManager.AppSettings["UserName"].ToString();
                string Password = ConfigurationManager.AppSettings["Password"].ToString();
                setDbInfo(rpt,ServerName,DatabaseName,UserName,Password);
                CRPTViewer.ReportSource = rpt;
                CRPTViewer.RefreshReport();
            }
            catch (Exception exc)
            {   
                throw exc;
            }
        }