How to display records from multiple table adapter in a single crystal report?

Question

0.00/5 (No votes)

See more:

I want to display records from multiple table adapter in a single crystal report. I add two table adapter in my dataset and add this adapters to my crystal report with database expert. There are two tabs named Data and Link in database expert. In Data ,I choosed my tableadapters and In link ,I determine relation of tableadapters .after that in link tab there are three button (ok,cancel,help) that i click ok and set my fields in columns of report.by doing these steps when i ran my program i had this error: logon database failed

Posted 29-Sep-14 22:48pm

Member 10808329

Updated 30-Sep-14 22:46pm

v3

Add a Solution

Comments

Samatha Reddy G 30-Sep-14 8:32am

Next button is enabled ofter selection of the fields in a table. you have these symbols (> >> < <<) using these symbols you need to select fields to display in report. after that next button will be enabled then you click on next button to complete the process. try like this then also if get same problem i will explain in detail

Member 10808329 1-Oct-14 4:47am

I had a mistake this link was about tables but i want to work with table adapters

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)

Dilan Shaminda · Accepted Answer · 2014-09-30T23:18:00

Solution 2

i think the problem is with the OLEDB Connection.Check this thread.It suggest to "Change the Crystal report to use an OLE DB datasource rather than the SAP Business One data source."

and for the second question you are facing just click on ok button after finishing the datatable linking part.Then drag and drop only neccesary field to the report you want to display.The tutorial you have gone through is an old version of CR.

This is a good article you to follow

Posted 30-Sep-14 23:18pm

Dilan Shaminda

Comments

Member 10808329 1-Oct-14 6:40am

in second question ,I click ok and drag and drop my neccesary fields to the report.
my dataset has two adapter(CustomerBill,Transactions).but i have a error database logon failed.i think there is a poblem with my code behind:
Dim dt As New DataSet("DS_CustomerTransaction")
dt = cls.Search_Cust_Bill_RPT(ArrStr(0))
dt.Tables(0).TableName = "CustomerBill"
Dim oRpt As New Crp_Cust_suratHesab()
oRpt.SetDataSource(dt)
CrystalReportViewer1.ReportSource = oRpt
CrystalReportViewer1.DataBind()

Dilan Shaminda 1-Oct-14 7:31am

Just comment your crystal report code and check whether how many rows you are getting to your dt object :-)

Member 10808329 1-Oct-14 7:48am

yes,in above code dt was filled and have all the row that i want but there is database logon error .also i changed my code to below and there is no error but report is empty but dt is filled.
Dim cls As New Cls_Cust_Bill
Dim dt As New DataSet("DS_CustomerTransaction")
dt = cls.Search_Cust_Bill_RPT(ArrStr(0))
dt.Tables.Add("CustomerBill")
dt.Tables.Add("Transactions")
Dim oRpt As New Crp_Cust_suratHesab()
oRpt.SetDataSource(dt)
oRpt.SetParameterValue("filter", ArrStr(1))
CrystalReportViewer1.ReportSource = oRpt
CrystalReportViewer1.DataBind()

Dilan Shaminda 1-Oct-14 8:08am

are you using OLEDB Connection?

Member 10808329 1-Oct-14 8:14am

no,i am not

Dilan Shaminda 1-Oct-14 11:09am

You have to merge your tables like below with your corresponding dataset

Dim dataSet As New DataSet("DS_CustomerTransaction")
Dim table As New DataTable("CustomerBill")
Dim table1 As New DataTable("Transactions")
dataSet.Tables[0].Merge(table)
dataSet.Tables[1].Merge(table1)

Member 10808329 2-Oct-14 1:19am

there is an error :
Cannot find table 1.

Dilan Shaminda 2-Oct-14 1:31am

change the datatable names according to your ones.I juts put table and table1 as names.

ex code : From Step by Step Creation of Crystal Report using its Features Group, Graph, Cross-Tab and Sub Report

Dim rptDoc As New ReportDocument
Dim ds As New dsTestCrystal
Dim sqlCon As SqlConnection
Dim dt As New DataTable
dt.TableName = "Crystal Report Example"
sqlCon = New SqlConnection("server='servername';
Initial Catalog='databasename';user id='userid';password='password'")
Dim da As New SqlDataAdapter("select Stud_Name, Class,
Subject, Marks from stud_details", sqlCon)
da.Fill(dt)
ds.Tables(0).Merge(dt)
rptDoc.Load(Server.MapPath("SimpleCrystal.rpt"))
rptDoc.SetDataSource(ds)
CrystalReportViewer1.ReportSource = rptDoc

Member 10808329 2-Oct-14 3:10am

i create new project but there is same error cannot find table 1
' Dim rptDoc As New ReportDocument
Dim ds As New DataSet("DS_CustomerTransaction")
Dim dt As New DataTable
dt.TableName = "CustomerBill"
Dim dat As New DataTable
dat.TableName = "PurchaseBill"
ds = cls.Search_Cust_Bill_RPT(ArrStr(0))
ds.Tables(0).Merge(dt)
ds.Tables(1).Merge(dat)
rptDoc.Load(Server.MapPath("CrystalReport.rpt"))
rptDoc.SetDataSource(ds)
CrystalReportViewer1.ReportSource = rptDoc

Dilan Shaminda 2-Oct-14 5:21am

did you create 2 datatables in your dataset which you have added to the report? also in your code bind customer bill data to dt datatable and purchase bill data to dat datatable.Then merge them with your dataset.Otherwise both tables contains null.

Member 10808329 4-Oct-14 1:31am

Yes ,I explain you all of steps that i did:
I create two table adapter in my data set and in crystal report i add two table adapter and link them with customer_no.after that i drag and drop my necessary fields.in my code behind.i define a instance of my dataset.at first i fill dataset by query after that define two datatable and merge them to my dataset .but i dont know why it can not find my tables

Member 10808329 4-Oct-14 1:41am

As i said, i fill my dataset by query at first and after that i define datatables and merge them.as i understand my crystal report fill by this query not datatables when i comment this line: ds = cls.Search_Cust_Bill_RPT(ArrStr(0)) it say i cant find table(0) but with this line crystal fill. it seems visual dosen not understand the atatables that i add to dataset

Dilan Shaminda 4-Oct-14 10:51am

here is my working sample code for binding data to crystal reports using two tables.Code is in C#. But it might help you :-)

ReportDocument rptDoc = new ReportDocument();

DataSetCashierReceiptsRes ds = new DataSetCashierReceiptsRes();
DataTable dt = new DataTable();
DataTable dt2 = new DataTable();

dt = print.CashierPrint(); // bind data to dt DataTable
dt2 = print.CashierTest(); // bind data to dt2 DataTable
ds.Tables["DataTable1"].Merge(dt);
ds.Tables["DataTable11"].Merge(dt2);
string path = Path.Combine(Environment.CurrentDirectory, @".\MyCrystalReport.rpt");
rptDoc.Load(path);
rptDoc.SetDataSource(ds);
rptDoc.DataSourceConnections.Clear();

crystalReportViewer1.ReportSource = rptDoc;

Member 10808329 7-Oct-14 6:42am

Thank you so much ,finally it works .
I really appreciate your help and attention.

Dilan Shaminda 7-Oct-14 9:21am

you are welcome :-)