VS 2010中的复杂报告 [英] Complicated Report in VS 2010

问题描述

我正在尝试构建一个可以访问五个联接表的报表。这很容易。客户希望将结果分为四个频段。顶部乐队有三个框，其中包含三个表（组头）的结果。第二个乐队在一个表格中有三个单独的框中的详细信息。第三个乐队在另外四个单独的框中提供了详细信息。第四个乐队在第一个乐队的三个表中有一个有额外的结果（所以是一个组页脚？）所以报告看起来像：

I'm trying to build a report that hits five joined tables. That's the easy part. The customer wants the results in four bands. The top band has three boxes with results from three of the tables (group header). The second band has detail information from one table, in three separate boxes. The third band has detail information from another table, in four separate boxes. The fourth band has additional results from one of the three tables in the first band (so a group footer?) So the report looks something like:

Information about         General information about          Information about
engine goes here          results go here, again,            fuel used goes here
one row in query          one row from query                 one row from query

-----------------------------------------------------------------------------------
Specific information      More specific information from fourth table,
from fourth table         multiple rows, goes here too.
goes here, six rows       Again, six rows per
per query                 query

Third group of information from fourth table goes here
and here,
and here, still from the six rows per query.

-----------------------------------------------------------------------------------
Specific information from fifth table     Specific information from fifth table
goes here, *SEVEN* rows per query         goes here, six rows per query

Specific information from fifth table     Specific information from fifth table
goes here, six rows per query             goes here, six rows per query

-----------------------------------------------------------------------------------
Final information, from the second 
table goes here, from one row in query.

通知在第二个细节带中，第一个框有七行，用于背景值，但其他行只有六行。



这是一个与rdlc报告或Crystal报告有关的可行报告吗？这个比另一个更容易使用吗？我有这个权利，它是一个群组标题乐队，两个细节乐队和一个组页脚乐队？



谢谢！

Notice in the second detail band the first box has seven rows, for background values, but the others only have six.

Is this a feasible report to do with a rdlc report or Crystal reports? Is one easier to use for this than the other? Do I have this right that it's a group header band, two detail bands, and a group footer band?

Thanks!

推荐答案

您应该使用数据集类型的报告功能。



如果您使用，RDLC报告更好，您可以设计您的查询或数据集。即使你也可以运行查询特定的列值，检查代码项目也会得到aritcle相同。



谢谢。

You should use dataset kind of functionality for reports.

If you use, RDLC report is better you can design your query or dataset. Even you can run query for specific columns value also, Check in code project also you will get aritcle for same.

thank you.

这篇关于VS 2010中的复杂报告的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！