如何在单个RDLC报表的单个数据集中使用多个数据表
问题描述:
你好朋友,
我想在单个RDLC报表的单个数据源中的单个数据集中添加多个数据表.所以任何人都可以帮助我完成此任务.谢谢
问候,
Santosh更多
伙计们,请帮助我,这对我来说确实非常重要.
Hello Friends,
I want to add multiple datatables in single Dataset in Single datasource of single RDLC report .So can anybody help me to achieve this task.Thanks In advance
Regards,
Santosh More
Guys Please help me it is really very important for me.
答
您可以将多个数据集用作SSRS的数据源. 如何创建数据集(报表设计器) [ ^ ]
例如,创建4个数据集并为每个数据集分配不同的结果集.
现在,在设计时根据需要使用它.
此外,对于任何报告,您始终可以拥有子报告,这是一种在单个报告中拥有多个数据源的方法.
由于SSRS在DataSet上工作,因此在单个数据集中拥有多个DataTable可能无法正常工作-因此可能必须在此处获取多个数据集而不是datatable并继续.
如果您不希望拥有多个数据源,则可以尝试使用子报表. SSRS在数据集级别而非数据表级别进行交易.
You can have multiple datasets as a datasource for SSRS. How to create a dataset (Report Designer)[^]
For example, create 4 datasets and assign different resultset to each.
Now, use it as you need while designing.
Further, for any reporting, you can always have Sub-reports, a way you can have multiple datasource in a single report.
Having multiple DataTables in a single dataset might not work as SSRS works on DataSet - so might have to get multiple datasets here instead of datatable and move ahead.
If you *don''t want to* have multiple datasource than try with subreports. SSRS deals at dataset level and not datatable level.