如何使用 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 分成几个部分,以及他们的 gradesnotes 在每个 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.

  1. 首先,您将一个 List Tablix 添加到具有该名称的报告中,然后添加一个 TextBox

  1. 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.

希望能帮到你.