cancel
Showing results for 
Search instead for 
Did you mean: 

ERROR:Additional information: Failed to load database information. Error in File temp_5772f972-572f-409c-a19d-e4935cbf344f 5544_4452_{1A3F388F-FBB1-4A29-82CC-A923E3F0A21C}.rpt: Failed to load database information.

Former Member
0 Kudos

I'm working on a report in Crystal Reports C# windows application.i fetch the data from localhost server to crystal report. I have 2 datetimepicker in my form.

datetimepicker1 = cbFromDate

datetimepicker2 - cbTodate

Crystalreport data from localhost:

Now I want that, when selecting some date in from and the to datetimepicker the between data is show in the crystal report please help me to solve i don't know how to start. i'm searching through googling i didn't get any thing about between data in datetimepicker show in crystal report.

Here my try:

  1. using MySql.Data.MySqlClient;
  2. using System;
  3. using System.Data;
  4. using System.Windows.Forms;
  5. namespace CrystalReport
  6. {
  7.     public partial class Form1 : Form
  8.     {
  9.         public Form1()
  10.         {
  11.             InitializeComponent();
  12.         }
  13.         String MyCon = "SERVER=localhost;" +
  14.                 "DATABASE=test;" +
  15.                 "UID=root;" +
  16.                 "PASSWORD=asterisk;" + "Convert Zero Datetime = True";
  17.         private void button1_Click(object sender, EventArgs e)
  18.         {           
  19.             filter_dates();
  20.         }
  21.         private void filter_dates()
  22.         {
  23.             MySqlConnection conn = new MySqlConnection(MyCon);
  24.             CrystalReport1 objcr = new CrystalReport1();
  25.             MySqlDataAdapter da = new MySqlDataAdapter("select id,date,time,user,department,city from pbx where date>='" + DateTime.Parse(cbFromDate.Text) + "' and date<='" + DateTime.Parse(cbTodate.Text) + "' ", conn);
  26.             DataTable dt = new DataTable();
  27.             da.Fill(dt);
  28.             objcr.SetDataSource(dt);
  29.             crystalReportViewer1.ReportSource = objcr;
  30.             crystalReportViewer1.RefreshReport();
  31.         }
  32.     }
  33. }

But i'm getting an error:


Any ideas? Please

Accepted Solutions (1)

Accepted Solutions (1)

0 Kudos

What SDK package are you using?

Answers (1)

Answers (1)

Former Member
0 Kudos

I'm using .net framework 4.5.2 in visual studio 2015

0 Kudos

That would be the VS and framework, what CR SDK are you using?

Go to Programs and Feature and look for CR for .NET, should show you the version you have installed.