Crystal Report

Hi,

I have a problem to pass data set to crystal report XI's report, I have try it with Crystal Report 8.5 and its work.

I used "File Definition Only" as my data source

The code is like below,

      ReportDocument doc = new ReportDocument();
      doc.Load("C:\Customer.rpt");

   string cString = "Persist Security Info=False;Integrated Security=SSPI;database=northwind;server=mySQLServer";

      SqlConnection myConnection = new SqlConnection(cString);

      SqlDataAdapter myAdapter = new SqlDataAdapter();
      myAdapter.TableMappings.Add("Table", "Suppliers");
      myConnection.Open();
      SqlCommand myCommand = new SqlCommand("SELECT * FROM Suppliers",
      myConnection);
      myCommand.CommandType = CommandType.Text;

      myAdapter.SelectCommand = myCommand;
      ds = new DataSet("Suppliers");
      myAdapter.Fill(ds);

      doc.SetDataSource(ds.Tables[0]);

      myConnection.Close();

I got an error says "Engine Error."

And, how to disable tool tips on Crystal Report Viewer on VS 2003

Thnx.

Answer this question

Crystal Report

cg_greg
I have the exact same error when trying to use a DataSource that is a Field Definition file (.TTX) in VS 2005. It boggles my mind that this feature is available in VS 2003 CR, but NOT in VS 2005 CR.

I understand the marketing aspect of this, but to remove even more functionality from the VS 2005 version so as to force developers to get the CR XI Release 2 (which is apparently not even available yet) seems exceptionally greedy and certainly doesn't leave a developer wanting to use CR at all.

I'm investigating using Microsofts Report Viewer included in VS 2005 -- as it appears to have a lot MORE functionality.

Rob.
Voodoo45
I hav install it with field definition.
The error occurs when, i actually set the datasource to the report, then i get
"UnKnowm Query Engine Error"...

And about the tooltips, i used crystal report viewer that available on .net, and i can't find the "EnableToolTips" property, is there any viewer i van used

thanx
Kooki
Hello Daniel,

When you installed Crystal Reports XI did you choose to install the Field Definition database driver It does not install by default.

You can go into Crystal Reports XI and create a new report using the Field Definition, this should install it if it has not been installed.

As for the tool tips, you can turn this off by going to the properties of the Crystal Report viewer and setting the EnableToolTips to false. EnableToolTips is under the Appearance category.

Keith - Business Objects
Svenson21
Hello Daniel,

Are you using the reporting engine from Crystal Reports XI to open these reports From you issues it sounds like you are using the reporting engine that was bundled in Visual Studio .NET 2003 to open the Crystal Reports XI version reports.

The EnableToolTips property is available with the viewers from Crystal Reports XI. They are not available with the version Crystal Report that was bundled with Visual Studio .NET 2003.

It could also be the reason why you are getting the error as the report format has changed and the reporting engine from the bundled version would not know what to do with it.

Keith - Business Objects
Crystal Report

Answer this question

Crystal Report

Hot Topic

Visual Studio

Crystal Report

Crystal Report

cg_greg

Voodoo45

Kooki

Svenson21