Crystal Reoprts

Sriram Ramani

Hi All, I have created a Window based application , i have also created a setup and deployment application and made it into a setup file , now i need to create a crystal report application such that it automatically takes the database table from the system. For Example if i deploy the application and install in the client system and install it in C:/Program files/application Now in this folder my database file will be present(I'm using an Access Database .mdb), i need that when the user clicks a button in my application the report must show the table from that database file. Please anyone help me!

15 Replies

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

Nilanka Dharmadasa17y ago
Hi Sriram,

I was able to recreate your problem. The error ' report has no table'.

First tell me have you designed a crystal report template ? If so check whether you have set a data table in the template.
The reason for this error is, when you create the crystal report template (.rpt file) you have not set any table. But you try to set a data table from code.It makes no sense. So it gives you an error.
If you want to display a dataset in the report, first you should add a table to the template.

First have a basic idea about crystal reports. There are tutorials on the web.
Sriram Ramani17y ago
Here is my codings...... Dim ds As New DataSet ds = New DataSet("LKG") Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Working\Sri\My project works\VVB\Vinayaga Vidhya Bhavan\Vinayaga Vidhya Bhavan\bin\Debug\vvb.mdb" Dim Connection1 As OleDb.OleDbConnection = New OleDb.OleDbConnection(ConnectionString) Dim Command1 As OleDb.OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM LKG") Connection1.Open() Command1.Connection = Connection1 Dim OleDbDataAdapter1 As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter OleDbDataAdapter1.SelectCommand = Command1 OleDbDataAdapter1.TableMappings.Add("table", "LKG") OleDbDataAdapter1.Fill(ds) DataGridView1.DataSource = ds.Tables(0)----> no error obj As New CrystalReport1 obj.SetDataSource(ds.Tables(0)) ---> no tables in report (error) CrystalReportViewer1.ReportSource = obj Some one help me please
Nilanka Dharmadasa17y ago
sorry. i'm not familiar with VB. Anyway, it seems you are defining your dataset inside one method and trying to access it from another method.
Is that so?

Anyway your code is not clear. If you can post it clearly, I can help you.
Sriram Ramani17y ago
Here is my codings...... Dim ds As New DataSet ds = New DataSet("LKG") Dim ConnectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Working\Sri\My project works\VVB\Vinayaga Vidhya Bhavan\Vinayaga Vidhya Bhavan\bin\Debug\vvb.mdb" Dim Connection1 As OleDb.OleDbConnection = New OleDb.OleDbConnection(ConnectionString) Dim Command1 As OleDb.OleDbCommand = New OleDb.OleDbCommand("SELECT * FROM LKG") Connection1.Open() Command1.Connection = Connection1 Dim OleDbDataAdapter1 As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter OleDbDataAdapter1.SelectCommand = Command1 OleDbDataAdapter1.TableMappings.Add("table", "LKG") OleDbDataAdapter1.Fill(ds) DataGridView1.DataSource = ds.Tables(0)----> no error CrystalReport11.SetDataSource(ds.Tables(0))---> no tables in report Public Class Form1 Public ds As New DataSet1 Public Sub rep() Dim cn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Working\Sri\My project works\VVB\Vinayaga Vidhya Bhavan\Vinayaga Vidhya Bhavan\bin\Debug\vvb.mdb") cn.Open() Dim da As New OleDb.OleDbDataAdapter("select * from LKG", cn) da.Fill(ds, "LKG") End Sub Private Sub CrystalReportViewer1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles CrystalReportViewer1.Load Call rep() Dim obj As New CrystalReport1 obj.SetDataSource(ds.Tables(0)) CrystalReportViewer1.ReportSource = obj End Sub Some one help me please
Nilanka Dharmadasa17y ago
Hi Sriram,

Paster your code here. Then your problem will be more clear to us.
Sriram Ramani17y ago
No it dont work , i treid that too , same error is showing . I even tried to pass the table name too inside like this ds.tables("tab_name") Same error is showing whatever i do . I thinh the table is not getting inserted into the dataset!
Nilanka Dharmadasa17y ago
Hey Sriram,

The dataset has only one table.

So you should call like this.
obj.setdaasource(ds.tables(0))

Whne you pass 1 it looks for the second table.
Hope your problem is resolved.

Please do not forget to accept my answer.
Sriram Ramani17y ago
Hi there, I tried using the dataset method , by this below coding. Dim daadp as new OledbDataAdapter Dim ds as new Dataset daadp=new oledbdadaadapter("select * from tab_name",cn) daadp.Fill(ds,"tab_name") dim obj as new CrystalReport1 obj.setdaasource(ds.tables(1))--->here i'm getting an error as the there is no tables in the dataset!
Girish Kulkarni17y ago
Hi buddy,
Try this one.
1. Right click on your project and add dataset as a new item. It is called as typed dataset. Now one xsd file will get added into your project.
2. Open xsd file and right click on it and add one table. Simillary add all the columns which you want to show in the report.
Set all the appropriate properties. In this way you are going to create a table which you will directly connect to the database.
eg. You will have a table "Employee" with column "EmpID","EmpName","Address"
3. Use this xsd file as dataset in your crystal report. This dataset(xsd) will help you in designing the project.
4. Now, through coding create instance of this dataset and fill table values dynamically by using queries.
5. Now assign dynamic instance of your dataset to the crystal report and open the report.

I hope it will help you. Please let me know if you want further clarifications or help.
If this answer works for you then please dont forget to Check "DO you like this answer".
Sriram Ramani17y ago
Hi Niki, Thanks for your reply . I have not done it yet , i tried in one before but it was not working . Now i'll try as u said . Will uploads the codes soon. Thanks
Sriram Ramani17y ago
Thanks Magg, I got what you mean . I'll try it and let u know . Thanks for the Answer
Nilanka Dharmadasa17y ago
Hi Sriram,

The best thing you can do is setting the data source dynamically. You can do this via C# code. If you need my help on that let me know. Better if you can paste your code here so that I can understand your requirement clearly.

If my answer helps you, please accept my answer.
naura pax17y ago
hi sriram,
There is another way of achieving that by using app.config.
You can define configuration string there and by using it you can access it in your data access layer.
So instead of directly setting ms access file as datasource you can set a DataSet as datasource for your crystal report. That dataset can be filled at runtime using sql queries on ms access db.
hope i'm close this time
bebo
Sriram Ramani17y ago
Hi there, I can understand what u say and also i know how to add a crystal report to my project. I'm using msvs2008. What i need to know is that when i deploy my application to the client's machine the database file gets copied to the C:\pgfiles\application folder now i want the report's datasource to directly take this location where the database file is located. Hope u get what i say.
naura pax17y ago
hi sriram,
If you have vs , crystal report will be available right there.
For eg in visual studio 2005 you open your window project and reference to following: C:\WINDOWS\assembly\GAC\CrystalDecisions.Enterprise.Framework\10.2.3600.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll
C:\WINDOWS\assembly\GAC\CrystalDecisions.Enterprise.Framework\10.2.3600.0__692fbea5521e1304\CrystalDecisions.Enterprise.Framework.dll
and you can directly add a file of type crystal report in your window application and directly set table from your database in that report file.
Later you'll have to build forms from where you can access these reports by using
ReportViewer class objects.