如何使用 SSRS 创建包含节和分页符的报告
我正在尝试创建一个如下所示的报告:
I'm trying to create a report that looks like this:
使用此表中的选择:(fiddler 此处用于查询和数据)
using a select from this table: (fiddler here for query and data)
CREATE TABLE StudentData
(
id int PRIMARY KEY IDENTITY,
name varchar(30),
subject varchar(30),
currentGrade varchar(2),
targetGrade varchar(2),
note1 varchar(100),
note2 varchar(100),
note3 varchar(100),
UNIQUE (id)
)
基本上我想在新页面上显示每个 student
,将他们的 subject
分成几个部分,以及他们的 grades
和 notes
在每个 subject
部分.
Basically I want to display each student
on a new page, with their subject
split up into sections, and their grades
and notes
in each of these subject
sections.
我正在尝试在 Business Intelligence Development Studio
任何有关我将如何处理的帮助都会很棒,谢谢.
Any help with how I would go about that would be great, thanks.
我现在可以上传图片了.
I can upload the images now.
首先,您将一个 List Tablix 添加到具有该名称的报告中,然后添加一个 TextBox
First you add a List Tablix to the report with the name and add a TextBox
将父组添加到行组类别的列表中
选择名称作为分组依据列
您将有两列,一列包含组,另一列包含先前创建的 TextBox
You will have two columns, one with the group and another with the TextBox created previously
添加更多 TextBox,但缺少其余列.
Add more TextBox with the rest of the columns missing.
现在我们要在每个组上设置中断,在行组部分选择组名并右键单击并选择组属性
Now we're going to set the break on each group, select on the Row Groups section the group name and right click and select Group Properties
选择分页符页面,然后选中在组的每个实例之间
你现在应该有这样的东西.
You should have something like this now.
现在让我们将名称配置为显示在每个页面的顶部,在 Row Groups 部分中选择 Details 组并添加一个 Total之前
Now let's configure the name to appear to the top of each page, select in the Row Groups section the Details Group and add a Total Before
在添加一些 TextBox 和一些颜色之后,你会得到这样的东西.
And after add some TextBox and some colors you will have something like this.
希望能帮到你.