Crystal report displays no data although the dataset was set using push method

Question

0.00/5 (No votes)

See more:

VS2015

I'm new to crystal report. I'm facing an issue that my report show no data although the dataset showed it did have data during debugging. I noticed that everything went wrong after the line " m_rptViewReport.SetDataSource(ds); ", it show "HasRecords = Function evaluation disabled because a previous function evaluation timed out. You must continue execution to reenable function evaluation crystal reports" Basically, I'm trying to export the data to xls file using push method. I'm using VS2015 and my crystal report assembly version is 13.0.3500.0

Pls take a look at my code

C#

public bool ExportToFile(DataSet ds,string fileType)
    {
        try
        {
            object obj = null;
            char[] split ={ '.' };
            CrystalDecisions.CrystalReports.Engine.ReportDocument m_rptViewReport = null;


                if (File.Exists(Request.PhysicalApplicationPath + "\\" + this.ReportFile))
                {
                   try {
                    m_rptViewReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
                    m_rptViewReport.Load(Request.PhysicalApplicationPath + "\\" + this.ReportFile);

                       ds.WriteXml("D:\\testfile.XML", XmlWriteMode.WriteSchema); //the output XML file does have data
                       m_rptViewReport.SetDataSource(ds);//something went wrong after this line
                   }
                   catch (Exception ex) //nothing happened here
                   {
                       throw ex;
                   }
                }
                else
                    this.SetTextTitle(Resources.GetLanguage("msgNoFile") + " " + this.ReportFile);

            if (m_rptViewReport.HasRecords){ //I added this line later and founded that the value is not TRUE
            if (m_rptViewReport != null)
            {
               SetReportParameterValue(m_rptViewReport);

                       Response.ContentType = "application/vnd.ms-excel";

                       try {
                           m_rptViewReport.ExportToHttpResponse(CrystalDecisions.Shared.ExportFormatType.Excel, Response, true, this.ReportCode);

                       }
                       catch (System.Threading.ThreadAbortException ex1)
                       {
                           //throw ex1;
                       }

            }
           }
           return true;
        }
        catch(Exception ex)
        {
           return false;
        }
    }

Thanks

What I have tried:

- I added useLegacyV2RuntimeActivationPolicy="true" to app.config and then removed it but both did not work.
- I also removed all CrystalReportViewer from my UI.

Posted 12-Sep-17 17:48pm

Member 13406906

Updated 12-Sep-17 20:24pm

Add a Solution

Comments

Graeme_Grant 12-Sep-17 23:54pm

Have you set breakpoints to check that in fact data is being passed to CR?

1 solution

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)

koklimabc · Answer 1 · 2017-09-12T20:24:00

Best Approach from my exprerience,

Create a new aspx page, modified everythings inside Page_init() (because not working other stage), make sure also put CrystalReportViewer on markup views.

protected void Page_Init(object sender, EventArgs e)
        {
            rptfile = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
            rptfile.Load(Server.MapPath("~/Reports/Report.rpt"));
            rptfile.SetDatabaseLogon("sa", "123", @"192.168.102.1\Database", "Data");
            rptfile.Refresh();

            .....

            OleDbDataAdapter sql = new OleDbDataAdapter(query, Connection);
                //OleDbDataAdapter sql = new OleDbDataAdapter();
                //sql.SelectCommand = new OleDbCommand(query, Connection);
            DataSet ds = new DataSet();
            sql.Fill(ds);

            rptfile.SetDataSource(ds.Tables[0]);
            this.CrystalReportViewer1.ReportSource = rptfile;
            CrystalDecisions.Shared.ConnectionInfo connectinfo = new 
            CrystalDecisions.Shared.ConnectionInfo();
            connectinfo.ServerName = @"192.168.102.1/Database";
            connectinfo.UserID = "sa";
            connectinfo.Password = "123";
            connectinfo.DatabaseName = "Data";

            CrystalDecisions.Shared.TableLogOnInfos TableLoginInfos = 
            this.CrystalReportViewer1.LogOnInfo;

            foreach (CrystalDecisions.Shared.TableLogOnInfo TableLogon in 
             TableLoginInfos)
            {
                    TableLogon.ConnectionInfo = connectinfo;
            }

            rptfile.SetParameterValue(@"param1", Class1.param1);
            rptfile.SetParameterValue(@"param2", Class2.param2);

            this.CrystalReportViewer1.HasToggleGroupTreeButton = false;
            this.CrystalReportViewer1.HasToggleParameterPanelButton = false;
            this.CrystalReportViewer1.ToolPanelView = ToolPanelViewType.None;
        }

Inside your web.config (to help web server find the path in easy),

<configuration>
  <configSections>
    <sectionGroup name="businessObjects">
      <sectionGroup name="crystalReports">
        <section name="rptBuildProvider" type="CrystalDecisions.Shared.RptBuildProviderHandler, CrystalDecisions.Shared, Version=13.0.2000.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, Custom=null" />
        <section name="crystalReportViewer" type="System.Configuration.NameValueSectionHandler" />
      </sectionGroup>
    </sectionGroup>
    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->
    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=5.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />
  </configSections>
  <businessObjects>
    <crystalReports>
      <rptBuildProvider>
        <add embedRptInResource="true" />
      </rptBuildProvider>
      <crystalReportViewer>
        <add key="ResourceUri" value="/crystalreportviewers13" />
      </crystalReportViewer>
    </crystalReports>
  </businessObjects>
</configuration>