How to create report from two table in c#

Arunavally S

Hai,

I used reportviewer to display all test marks in particular student

Table: TestTable
StuId
BatchId
Testname
Mark
QualMark
Max Mark
Date

It displayed correct in reportviewer. But i want to display StuId, Batch Id, Course, BatchStartDate,BatchEndDate, Attendance from Batch Table.

It will display only once in report. But TestTable value displayed more records.

How can i do?
Kindly help me.

Thanks in advance

1 Reply

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

Santosh Thakur13y ago
Hi,

You need to bind the DataTable(s) that you intend to use instead of binding the entire DataSet. This SO answer shows a very good example: http://stackoverflow.com/a/8341474/283895
(Code copied from that article)
```
ReportDocument rpt = new ReportDocument(); rpt.load(); rpt.Database.Tables[0].SetDataSource(ds.Tables[0]);  this.crystalReportViewer1.ReportSource = rpt;
```