Crystal report database connection error when refresh - got stucked

Question

0.00/5 (No votes)

See more:

SQL

create procedure sp_summary
@SP_FROMDATE DATE,
@SP_TODATE DATE
AS
SELECT STYLE,PROCESS,SUM(QUANTITY) AS QUANTITY 
FROM TBL_PRODUCTION_INFO 
WHERE STYLE IN (SELECT STYLE FROM TBL_STYLE_INFO WHERE STATUS = 1)
AND PROD_DATE BETWEEN CONVERT(DATE,@SP_FROMDATE) AND CONVERT(DATE,@SP_TODATE)
GROUP BY STYLE, PROCESS

C#

ReportDocument rptDoc = new ReportDocument();
                string workingDirectory = Environment.CurrentDirectory;
                //string workingDirectory = Application.StartupPath;

                string rptPath = Directory.GetParent(workingDirectory).Parent.FullName + "\\sewing\\sewingReports\\StyleSummaryDateWise.rpt";
                //string rptPath = @"D:\NewProject\SkyTree Cost Management System\reports\CustomerWiseReport.rpt";
                //string rptPath = @"reports\\CustomerWiseReport.rpt";
                rptDoc.Load(rptPath);
                rptDoc.SetParameterValue("@SP_FROMDATE", Convert.ToDateTime(fromDateTxt.Text));
                rptDoc.SetParameterValue("@SP_TODATE", Convert.ToDateTime(todateTxt.Text));
                crystalReportViewer1.ReportSource = rptDoc;
                crystalReportViewer1.Refresh();

What I have tried:

When I open crystal report it shows error message "database connection error". I make this report with store procedure. What's the problem with this code?

Posted 17-Feb-22 7:23am

Things U Need

Updated 19-Feb-22 6:32am

Add a Solution

3 solutions

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)

Maciej Los · Answer 1 · 2022-02-17T09:37:00

I do NOT see the part of code responsible for connection.

Check this out:
VB.Net crystal report connection string - Stack Overflow[^]
Setting the Connection String Programmatically on a Crystal Reports ReportDocument[^]

Here is an example in VB.NET:

VB.NET

Private Sub CrystalReportViewer1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Load
        Dim cryRpt As New ReportDocument
        Dim crtableLogoninfos As New TableLogOnInfos
        Dim crtableLogoninfo As New TableLogOnInfo
        Dim crConnectionInfo As New ConnectionInfo
        Dim CrTables As Tables
        Dim CrTable As Table
        cryRpt.Load("E:\ColorLab1\colorlab\colorlab\rpt_bill.rpt")

        With crConnectionInfo
            .ServerName = "MAHESH\SQLEXPRESS"
            .DatabaseName = "cc"
            .UserID = "erp"
            .Password = "123"
        End With

        CrTables = cryRpt.Database.Tables
        For Each CrTable In CrTables
            crtableLogoninfo = CrTable.LogOnInfo
            crtableLogoninfo.ConnectionInfo = crConnectionInfo
            CrTable.ApplyLogOnInfo(crtableLogoninfo)
        Next
        CrystalReportViewer1.RefreshReport()
    End Sub

Good luck!

M Imran Ansari · Answer 2 · 2022-02-17T12:39:00

Please check your database connection. It may be closed.
Sometimes runtimes .NET framework has changed the way that it binds to older mixed-mode assemblies and getting stuck. Use the following attribute in your App.config which is useful if your application uses legacy activation paths.

<startup useLegacyV2RuntimeActivationPolicy="true">
	<supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0"/>
</startup>

Things U Need · Answer 3 · 2022-02-19T06:32:00

This works for me. Thanks for your answer.

ReportDocument rptDoc = new ReportDocument();
                string workingDirectory = Environment.CurrentDirectory;
                //string workingDirectory = Application.StartupPath;

                string rptPath = Directory.GetParent(workingDirectory).Parent.FullName + "\\sewing\\sewingReports\\StyleSummaryDateWise.rpt";                
                rptDoc.Load(rptPath);
                rptDoc.SetParameterValue("@SP_FROMDATE", fromDateTxt.Value.ToString("yyyy-MM-dd"));
                rptDoc.SetParameterValue("@SP_TODATE", todateTxt.Value.ToString("yyyy-MM-dd"));
                crystalReportViewer1.ReportSource = rptDoc;
                crystalReportViewer1.Refresh();

Crystal report database connection error when refresh - got stucked

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0