我在报表中显示数据时遇到问题，请帮帮我 [英] I am having problem to to display data in report somebode help me please

问题描述

有人可以帮我从datagridview控件的checkd值中准备vb.net和sql server数据库表中的Crystal报表(我的意思是使用不同的值)
我会很感激

谢谢
bhojendra

Some one help me please to prepare crystal report in vb.net and sql server database table from datagridview control checkd value (i mean using different values)
i will be very appreciate

thank you
bhojendra

推荐答案

可以使用数据表存储值，如果使用复选框或从girdview中选择行，则可以对数据表进行查询并存储重用进入dataview.

例如.

这是您可以存储在数据表中的数据库值.如果所选列不在数据库中，则可以在datatbale中添加列以从网格中获取所选记录.将此数据表分配给您的gridview.


ID名称所选年龄
1 A 21错误
2 B 64是
3 c 55 True
4 D 48错误

现在您可以查询数据表并将结果存储到数据视图中.
该代码
将dv dv作为新的数据视图(datatble("Selected = True")，按列排序，DataViewRowState.CurrentRows)

现在，将此数据视图分配给您的Crystal Report并进行检查.

You can use datatable to store your values and if you are using checkbox or something to select row from girdview then you can make query on datatable and store that reuslt into dataview.

For example.

This is your database value which you can store in datatable.If selected column is not in database you can add column in datatbale for fetching selected records from grid. Assign this data table to your gridview.


ID Name Age Selected
1 A 21 False
2 B 64 True
3 c 55 True
4 D 48 False

Now you can make query on datatable and store result into dataview.
Code for that
Dim dv as new dataview (datatble("Selected = True"),Sort by column, DataViewRowState.CurrentRows)

Now assign this dataview to your Crystal Report and check it.

这篇关于我在报表中显示数据时遇到问题，请帮帮我的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！