How to access two tables data view crystal report in c#

Gokul

hii, friends

i have create windows application but i need crystal report two tables data view but one table data 'select * from tablename' another table using where condition ,,

how can i make this

and i am using dataset

and query

SqlDataAdapter sda = new SqlDataAdapter("select * from tbl_stockout where billno='" + txtname.Text + "'", con);

con.Open();

DSadmin ds = new DSadmin();

sda.Fill(ds.tbl_stockout);

CRadmin ad = new CRadmin();

ad.SetDataSource(ds);

crystalReportViewer1.ReportSource = ad;

con.Close();

this is my query but i need two tables data view in crystal report windows application

2 Replies

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

Bikesh Srivastava10y ago
Hi Gokul,
There are explanation with multiple table in crystal report.
http://highoncoding.com/Articles/556_Creating_Crystal_Report_with_Multiple_Tables_in_ASP_NET.aspx
0
Manas Mohapatra10y ago
Try to add DataTable to DataSet and then set DataSet as datasource like below:

DataSet ds = new DataSet();
ds.Tables.Add(dt1);
ds.Tables.Add(dt);
rpt.SetDataSource(ds);

Follow below link:

http://highoncoding.com/Articles/556_Creating_Crystal_Report_with_Multiple_Tables_in_ASP_NET.aspx

http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-multiple-tables.htm
+1