ssrs 2008 :不希望每个组都显示组标题

问题描述:

我需要生成 SSRS 报告,如上图所示(图像的顶部被剪掉了,但它有如下所示的标题,它应该只出现在每页的顶部).

I need to generate SSRS report as shown in the above picture (the top portion of the image got cut off but it has the header as shown below which should appear on only at top of each page).

HEADER如下

Bin ItemNr 描述 QtyOnHand

Bin ItemNr Description QtyOnHand

我的数据输出如下所示,我需要使用它来生成如上所示的报告格式.

My data output is as below which I need to use to generate report format as shown above.

![在此处输入图片说明][2]

![enter image description here][2]

我面临的问题

我使用了 2 个 tablix.第一个 tablix 在 ItemNr 上有 groupby,只有当记录的 binPriority 等于 0 时我才会显示.然后我在第一个 tablix 中添加了另一个 tablix 以找出 itemNumber 计数是否 >1(否则我隐藏这个 tablix).在这里,我打印了 binPriority 为 0 的行.

I used 2 tablix. The first tablix has groupby on ItemNr and I show only if the record has binPriority equal to 0. I then added another tablix within first tablix to findout if the itemNumber count is >1 (else I hide this tablix). Here I printed rows where binPriority is <> 0.

我得到的数据输出与我想要的有点相似,但每个项目都会出现标题行(其中 binPrority 为 0).我希望它只出现在每页.所以我所做的是将第一个 tablix 中的行标题设置为不可见,并在页眉中添加了文本框.我想这不是这样做的方法,但这是我目前为止的方法).

I get the data output somewhat similar to what I wanted but the header row appears for every item (where binPrority is 0). I want it to appear only per page. So what I did was I set the row header within first tablix as invisible and added the textboxes within the page header. I guess this is not the way to do it but this is where I am so far).

此外,当我导出为 PDF 时,我会在每个项目之间看到空行(见下图).对我来说,这条线看起来像是隐藏的第二个 tablix.当我在屏幕上查看时,报告格式/显示是完美的.

Also when I export to PDF, I see blank lines between each item (See image below). To me this lines looks like the 2nd tablix which is hidden. The report format/display is perfect when I view it on the screen.

报表设置为横向打印,所有边距均为 0.

The report is set to print in landscape and all the margins are 0.

请建议如何实现上述报告格式.

Please suggest how to achieve the above report format.

更新 1:我通过删除一些具有实时数据的图像来修改问题.

Update 1 : I have modified the question by removing some of the images that had live data.

我将此问题标记为已回答.我通过删除第二个 tablix 并使用分组来修改报告.

I am marking this question as answered. I modified the report by removing the 2nd tablix and using Grouping.