Can the data source of the crystal report use the data in the DataGridView

fenril

There is a DataGridView similar to the one below, where the data is not obtained directly from the database.
Some are calculated (field data is indeterminate).
———————————————————-
| Name | Basic salary | Performance allowance | Total |
| ————————————————————
| Lee | 1000 | 1000 | 2000 |
| ————————————————————
| Wang | 1000 | 1000 | 2000 |
| ————————————————————
| Total | 2000 | 2000 | 4000 |
———————————————————-
Ask how to use crystal reports to carry the data in this DataGridView?

shygza

The data of the DataGridView is also stored in the DataTable, just bind this DataTable directly
crystalReport1.ReportSource = DataTable;

njuwelkin

Ok

fenril

Part of the data is taken from the database, part of the data is calculated, you can not directly use the datatable.
In addition, can DataTable be used directly as a data source for crystal reports?

starsport

Both DataSet and DataTable can be used as data sources for crystal reports.

Another: Since you can send data to cr, why can't you send data to a datatable?

ak41sl

of course.

JINFENG99

Of course. Use the dataset, and directly from the datagridview to construct a new dataset class

fenril

I have seen many examples of fetching data from a certain table. In this case, the fields are generally fixed.
What I want to achieve is to use datatable as the data source, and the fields in the datatable are not fixed.
My thoughts are as follows:
new a reportdocument
reportdocument.load("... crystalReport.rpt")
reportdocument.setdatasource(....datatable or dataset)
rptViewer.datasource=reportdocument

How to set crystalReport.rpt at this time?