|Hide empty row in crosstab [message #637746]
||Mon, 08 November 2010 11:33
Registered: August 2009
I need to filter out lines where the values of a measure are null for each value of column dimensions.
See the following scotch for illustration:
| d1:1 | d1:2 |
| d2:1 | d2:2 | d2:1 | d2:2 |
d3:1 | m1 | 1 | 2 | null | 4 |
| m2 | null | null | null | null |
| m3 | null | null | 1 | 2 |
d3:2 | m1 | 1 | 2 | 3 | 4 |
| m2 | 1 | 2 | 3 | 4 |
| m3 | null | null | null | null |
Lines 2 and 6 should be hides.
There is a hide attribute for measures, but it is unconditional.
What is the right way for this.
[Updated on: Mon, 08 November 2010 11:43]
Report message to a moderator
|Re: Hide empty row in crosstab [message #645998 is a reply to message #645869]
||Tue, 21 December 2010 09:21
| Jason Weathersby
Registered: July 2009
Can you email it to me at jasonweathersby at windstream dot net?
On 12/20/2010 4:07 PM, Marco wrote:
> Hi Jason,
> I achieved to dynamically hide rows with setDisplay("none").
> The rows are completely gone in a html report on Linux. But in pdf there
> are still ugly and irritating artifacts left.
> The same artifacts are show in html under windows, just narrower.
> I have prepared small demo output in html and pdf. If you could tell me
> how, I would like to send it to you or publicize it.
Powered by FUDForum
. Page generated in 0.02513 seconds