iReport - 组织列输出？ [英] iReport - organizing column output?

问题描述

我正在制作一份应如下所示的盈亏报告：

I am working on a profit and loss report that should look like this:

我的数据表如下所示：

And my data table looks like this:

对于此P& LI，查询＃1填充当前月份的数据， 3个月前。然后我有查询＃2来计算6个月的滚动平均值，然后查询＃3来计算年初至今的总数。他们都加入了工会声明。

For this P&L I have query #1 that populates the data for the current month and the 3 months prior. Then I have query #2 to calculate a 6-month rolling average, and then query #3 to calculate a year-to-date total. They're all joined with union statements.

我无法弄清楚在iReport中渲染它的最佳方法。现在我正在使用交叉表，我能够使用Bekwam的扩展交叉表技术。

I can't figure out the best way to get this to render in iReport. Right now I am using a crosstab, and I was able to finagle the "measures" labels into the customer column using Bekwam's "Expanding a Crosstab" technique.

所以我的问题是 - 有没有更简单的方法呢？每次我在交叉表中添加一个度量时，我都需要重新排列度量标签和字段。如果我在Excel中创建了一个数据透视表，我可以单击一个下拉框并选择显示或隐藏某些月份 - 有没有办法在iReport中执行此操作？我觉得我必须遗漏一些东西。如果有其他人在这样的列中显示数据，你是怎么做的？如果你在列中设置你的细节带，任何组织输出的提示让它看起来很专业吗？

So my questions are - is there any easier way to do this? Every time I add a measure to the crosstab I have to rearrange the measures labels and fields. If I made a pivot table in Excel, I could click a drop-down box and choose to show or hide certain months - is there any way to do that in iReport? I feel like I must be missing something. If anyone else out there is displaying data in columns like this, how are you doing it? If you set up your detail band in columns, any tips for organizing output so it looks professional?

谢谢，
Lisa

Thanks, Lisa

推荐答案

我决定在详细信息带中创建列。我将测量标签放在第一列中，并将它们设置为仅在该列中打印。然后我在每列中打印我的度量值。我希望我能告诉iReport在第2-n列中打印度量值，但我认为这是不可能的。

I decided to create columns in the detail band. I put my measure labels in the first column and set them to print in that column only. Then I have my measures values print in each column. I wish I could tell iReport to print the measures values in columns 2-n, but I don't think that's possible.

有些客户没有每个值都有价值查询＃1中的月份，因此我决定在日历表（日历表左连接查询＃1）上加入查询＃1，以添加空格作为占位符以保留格式。

Some customers will not have a value for each month in Query #1, so I've decided to join Query #1 on a calendar table (calendar table left join query #1) to add blanks as placeholders to preserve my formatting.

这篇关于iReport - 组织列输出？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！