My report doesnt appear...

Israel

Hi!

Please give me a help. I would love to see my report appearing with datas. But when I run my program it's giving me this message:

could not load file or assembly 'file:///c:\Program Files (x86)\
SAP BusinessObjects\Crystal Reports for .Net Framework 4.0\
Common\SAP Businessobjects Entreprise XI 4.0\win2_x86\dotnet1\
crdb_adoplus.dll or one of its dependencies. The system
doesnt find the specific file.

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.Sql;
using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;

namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{

SqlConnection conn = new SqlConnection("Data Source=localhost\\sqlexpress;Initial Catalog=master;Integrated Security=True");
public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
conn.Open();
SqlCommand com = new SqlCommand("select * from tbl_products", conn);
com.CommandType = CommandType.Text;
SqlDataAdapter sdt = new SqlDataAdapter(com);
DataTable ds = new DataTable();
sdt.Fill(ds);
CrystalReport1 crp = new CrystalReport1();
crp.SetDataSource(ds);
crystalReportViewer1.Refresh();
conn.Close();
}
}
}

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes12y ago
You'd be better addressing this question to someone who's more familiar with reporting systems than I am.

However, if I were to use such a system, I think I'd prefer the ReportViewer control to Crystal reports.

Mahesh Chand has written a number of articles, plus a book, on using this control and I'd check out the links here (you'll need to refine by author to get Mahesh's stuff in isolation):

http://www.c-sharpcorner.com/tags/1/reportviewer
Israel12y ago
Vulves, listen please. Your advises are welcome. But I have a big problem... Until now I am stressing to know which way to start from now making my own reports. Do you know one or some link to learn making simple, nice and complex reports. I I would love to choose definitively. I want to follow others programers as you the way to do report.
Vulpes12y ago
Alhough you can import XML data into Excel, most of the raw data I produce is non-hierarchical and CSV files are adequate for this.

I believe you can also use an XML datasource with Crystal Reports or the ReportViewer control.
Israel12y ago
ok, but tell me more. Do you want to say that you import datas throught xml. I'm asking this question because I hear that it's possible to make report in windows application using xml report?
Vulpes12y ago
I don't currently use any reporting system as such.

Many applications I write produce raw data which clients or their advisers then process. If I'm asked to do something myself I'd import the data into Excel and produce a basic report from that. The client can then customize the report if needed.
Israel12y ago
Vulves, This is a good answer for me. Why? because I would like to know in which kind of report system are you use?
Vulpes12y ago
I don't know much about Crystal Reports but see if the solution given in this link (second one down) will work:

http://crystal622.rssing.com/chan-5903591/all_p45.html