row headers for multiple measures in crosstab

[marco12]

Hi,

I want to design a report which shows e.g. measures a and b for horizontal dimension h1 and h2 and vertical dimension v1 and v2.

The input might be:

h1	h2	v1	v2	a	b
101	201	301	401	1	"b1"
101	202	301	401	2	"b2"
101	202	302	402	3	"b3"

 The output should be:

			101
			201	202
301	401	a	1	2
		b	b1	b2
302	402	a		3
		b		b3

If I just create 2 row, 2 columns, and 2 measures there is no title/label/header for my measures ("a", "b").

If I create an additional row for measures and just 1 measure, I have the problem that the measures are of different types.

If I create an additional row for measures and still 2 measures I would get a lot of empty lines??? BTW how do I return EmptyValue from my custom DataSource?

 

I am lost. Please tell me the right approach.

 

Brgds,

Marco

[marco12]

 Hi,

 

sorry for nugging but I can't believe that there is no solution for such a trivial/common use case. But if you think it is not possible please just tell me.

 

Brgds,

Marco

[lucianc]

You could, for instance, add text fields for "a" and "b" in the header of the v2 row group.  Wouldn't that do?

Regards,

Lucian

[marco12]

 I produce my design programmatically with DynamicJasper. In DJ is no option to add an additional text field to the header of a crosstab row, there is just one String parameter for the row header. Is it really possible to add another text column to the header of a row. Or do you mean to concatenate the names of my measures to the values of the row dimensions?

In the second case I have the problem that I do not really want to print dimension values in the lines but print it as group titles:

	101
	201	202
301
401
a	1	2
b	b1	b2
302
402
a		3
b		b3

Thx,

Marco

[lucianc]

I can't offer any help related to DynamicJasper, as I don't know how it works.  Try the DJ forums, or maybe other people on this forum have experience with DJ and are willing to help.

Regards,

Lucian