如何使用ReportViewer设计将两个数据表添加到Tablix [英] How to Add Two DataTables to a Tablix Using ReportViewer Design
问题描述
我正在使用ReportViewer在报表中添加两个DataTable到表格(tablix)。
数据表
- dtPrograms 名称,说明)
- dtImprovements (改进)
我将列出一个程序,并列出每个程序的改进。
以下是我正在寻找的示例:
我不知道如何设计我的ReportViewer。使用表(tablix)是一种很好的方法,还是有更简单的方法呢?也许使用矩阵?您将如何设计包含两个DataTable的报表?
详细解决方案
我手动创建了一个DataSet( ds
),一个DataTable( dtTest
),并手动填充信息。例如:
ds.dtTest.Rows.Add(Test1,描述1,Test1的改进1 )
ds.dtTest.Rows.Add(Test1,描述1,Test1的改进2)
ds.dtTest.Rows.Add(Test1,描述1 Test1的改进3)
ds.dtTest.Rows.Add(Test1,描述1,Test1的改进4)
ds.dtTest.Rows.Add(Test2 ,描述2,Test2的改进1)
ds.dtTest.Rows.Add(Test2,描述2,Test2的改进2)
ds.dtTest.Rows 。添加(Test3,描述3,Test3的改进1)
ds.dtTest.Rows.Add(Test3,描述3,Test3的改进2)
ds.dtTest.Rows.Add(Test3,Description 3,Test3的改进3)
ds.dtTest.Rows.Add(Test3,Description 3,Improvement 4 for Test3)
ds.dtTest.Rows.Add(Test4,描述4,Test4的改进1)
1。将Tablix添加到报告
2。除去1列以外的所有内容。保留要重复的列
在我的情况下,我在这里添加了改进列。
< h2> 3。将父组添加到改进列
我右键单击改进单元格,添加组>父组(在组组下)
4。按名称分组
5。将一个子组添加到您的名字列
这是我添加描述的地方
6。添加说明
7。删除标题
结果
这是设计:
这里是最终结果:
I am trying to add two DataTables to a Table (tablix) in my report using ReportViewer.
DataTables
- dtPrograms (Name, Description)
- dtImprovements (Improvement)
I'll have a list of programs and a list of improvements for each program.
Here's an example of what I'm looking for:
I'm not sure how to design my ReportViewer. Is using a Table (tablix) a good method or are there easier methods of doing so? Perhaps using a Matrix? How would you go about designing a report that contains two DataTables?
Detailed Solution
I manually created a DataSet (ds
), a DataTable (dtTest
) and manually populated it with information. For example:
ds.dtTest.Rows.Add("Test1", "Description 1", "Improvement 1 for Test1")
ds.dtTest.Rows.Add("Test1", "Description 1", "Improvement 2 for Test1")
ds.dtTest.Rows.Add("Test1", "Description 1", "Improvement 3 for Test1")
ds.dtTest.Rows.Add("Test1", "Description 1", "Improvement 4 for Test1")
ds.dtTest.Rows.Add("Test2", "Description 2", "Improvement 1 for Test2")
ds.dtTest.Rows.Add("Test2", "Description 2", "Improvement 2 for Test2")
ds.dtTest.Rows.Add("Test3", "Description 3", "Improvement 1 for Test3")
ds.dtTest.Rows.Add("Test3", "Description 3", "Improvement 2 for Test3")
ds.dtTest.Rows.Add("Test3", "Description 3", "Improvement 3 for Test3")
ds.dtTest.Rows.Add("Test3", "Description 3", "Improvement 4 for Test3")
ds.dtTest.Rows.Add("Test4", "Description 4", "Improvement 1 for Test4")
1. Add the Tablix to the Report
2. Remove all but 1 column. Keep the column that will be repeated
In my case, I add the Improvement column here
3. Add Parent Group to the Improvement Column
I right click on the Improvement cell and Add Group > Parent Group (Under Row Groups)
4. Group By Name
5. Add a child group to your name column
This is where I add my description
6. Add Description
7. Remove Headers
Result
Here is the design:
Here is the final result:
这篇关于如何使用ReportViewer设计将两个数据表添加到Tablix的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!