Question

I m的任务是在档案制作人数据库中复制一份特别报告。产出应如此:

NAME       DATE       ITEM(S)
Joe      5/2/2012     Gum
                      Tape
                      Soap
Ann      5/1/2012     Paper
Bob      5/1/2012     Pen
                      Paper

记录如上所示(与“人”和“项目”表合并,具有1:many关系):

NAME       DATE       ITEM(S)
Joe      5/2/2012     Gum
Joe      5/2/2012     Tape
Joe      5/2/2012     Soap
Ann      5/1/2012     Paper
Bob      5/1/2012     Pen
Bob      5/1/2012     Paper

在该报告中,我需要第一个信息与分析小组在第一、一、一、一行中不断展示;如果有更多的项目,则只应在其后各行中列出(不应重复不结盟运动和国名数值)。

我不敢肯定,哪些树可以 bar树:

in RDL I can conditionally hide report items on a row-by-row basis... can I do that in Access reports (in Access continuous forms, I think one cannot do that -- the Visible setting applies to all rows simultaneously, I think)
can I do this with a Group, putting the first, complete row in the Group header and the subsequent rows in the Detail section? If so, I m not sure how I would get just the first item in the header, and how to suppress that first item in the details section
other ideas? do I need to think about a different record source, or sources?

我迄今所管理的唯一事情是把人与不结盟运动和吉布提集团负责人混为一谈,然后把所有项目详细列出,但这不是我要求做的事情。

“a->

Chris

Answer 1

It s the same in the reports, you can t apply conditional formatting the way you re able to in RDL.
This seems like the natural answer. It s essentially a grouping operation, so group by name and date, and put those two in the header, then put the items in the detail. The only thing is that, as I think you noted, the items would be offset by one row relative to what you re being asked.
You can put conditional logic in the query of course, but I don t think that works here, because the show/hide logic depends on the group query. See #2.

Answer 2

Add a group by on Name
Put all the fields in the detail
Turn Hide Duplicates on all the fields

将该专家组的名称放在一边,是为了阻止博博的日期和物品被安定的日期和物品隐藏起来。

除此以外,同一技术还用于Crystal和Jasper报告。

Layout view enter image description here

Design View enter image description here

Answer 3

In jaspersoft iReport 4.6.0

Choose "add Report Group" and then group with one field(eg.name) that you want to show once.
You need to add all the field in Detail band
Change in the properties of "print repeated values" (checkbox) off, which you want to show once.

友情链接