huynhkchau

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

Hi, I have the same problem. Did you find out the solution for this? Regards, KChau

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

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

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 :)

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.

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

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

Thank kchaudhry, but I don't know how to horizontally stretch the Date colum to cover the Type colum. :(. Am I missing something ?

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.