[crosstab columns]

So there's any way to count the generated columns of the crosstab?.

Thanks

KChau 

[crosstab columns]

Hi,

I have the same problem. Did  you find  out  the  solution for this?

Regards,

KChau

[Crosstab border not consistent between pdf & html]

Hi,

When designing the crosstab with ireport 3.0.0, I have got a problem with filling background color. The background color of a cell override  the border of the previous cell in pdf preview (in html preview is ok). :(

Eclosed is jrxml file and the photos of two preview.

Any advices is appreciate. Thanks

Post Edited by huynhkchau at 05/06/2009 09:26

[Got error when compiling SQL in ireport 3.5 :(]

Hi all,

I've got a problem in with compiling SQL in ireport 3.5.

My SQL:  select * from table( GET_WEEKLY_STATISTIC_FILE(NUM_ARR(1,34),'WEEKLY') )

GET_WEEKLY_STATISTIC_FILE(NUM_ARR(1,34),'WEEKLY')  is a function return table type (STATISTIC_DOWNLOAD_TBL).

This SQL statement works well in ireport 3.0 and Oracle SQL Developer but when I run it in ireport 3.5, I've got error 

ORA-00904: "GET_WEEKLY_STATISTIC_FILE": invalid identifier 

I'm afraid that it don't understand nested table type, so I change SQL to 

select * from table(cast(GET_WEEKLY_STATISTIC_FILE(NUM_ARR(1,34),'WEEKLY') as STATISTIC_DOWNLOAD_TBL))

I still got error  java.sql.SQLException: ORA-00902: invalid datatype .

Am I missing something. :-/. Please help !.

Thanks

[display crosstab in summary with page header & ..]

Please regard this link http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=248

In short

1:create a dummy group
2:put your corsstab in the footer of the dummy
3:put your title at the header of the report
4:put your title at the footer of the report

Hope this help :)

 

[Long word has different output view in html & pdf]

Hi,

When I put a long word or url (no spaces)  into text field and "stretch with overflow" is checked; with pdf preview, I see that text field width is fixed and it vertically stretch (right way); but with html preview, the width is stretch and it horizontally stretch.

Actually, I can make line breaks by editing in expresstion editior ... but I do believe that it's not right method.

Is there any way to solve this ?

Thanks in advance.

[horizontally/vertically stretch cell in crosstab.]

Hi kchaudhry,

Thanks so much for your support. After reading your file, I solved the problem.:)

As I see, the Date header element  is not horizontally stretch only vertically stretch. So instead of bordering the  element  properties, I border the cell properties and set the Date header width to fix with its output result. The report will look like the above picture. 

But anyway, I still hope  that header element  can auto horizontally stretch :p.

Again,

Thanks

[horizontally/vertically stretch cell in crosstab.]

Sorry kchaudhry,

but seem it doesn't work to my report. With ireport 3.0.0 I tried "Enlarge between margins", the element width changed to 100 but I got error when compiling the code "Element reaches outside Date header width..."

With ireport 3.5.0 I tried "Adapt to parent" but it didn't work too...

Enlosed is the jrxml file.

Thanks

Code:

Post Edited by huynhkchau at 04/22/2009 03:41

Post Edited by huynhkchau at 04/22/2009 03:42

[horizontally/vertically stretch cell in crosstab.]

Thank kchaudhry,

but I don't know how to horizontally stretch the Date colum to cover the Type colum. :(.

Am I missing something ?

[horizontally/vertically stretch cell in crosstab.]

I'm new at iReport. In my project, i need to design two reports as follows. I use crosstab to present both but I have some problem with it. Please help me out. The deadline is coming :((

	Jan		Feb
	Produce	Sell	Produce	Sell
Product A	10	5	12	6
Product B	5	2	2	5

With this report, I can not horizontally stretch header cell Jan/Feb to fix with Produce+Sell like the figure.i.e. Produce=Sell=50 and Jan=100, but with crosstab I can only set  maximun of Jan is 50.

		Product A	Product B
Jan	Produce	10	5
	Sell	5	2
Feb	Produce	12	2
	Sell	6	5

With this report, I can vertically stretch header cell Jan/Feb.The alignment of crosstab when I preview in iReport is okb ut it is not proper in web. The Jan cell is stretched but it's height is not fix with the total height of Produce and Sell.

Note: I checked "Stretch with overflow" with stretch type is "Relative to band height'.

Thanks in advance.