javalogan

Thanks for the help Tchen. This works... but then the only problem is that the column data is only distrubted evenly before the page break. After the page break it only fills column 1 (unless it reaches the end of the page again and then starts to fill column 2 from the top). So we get the following (first part of the group starts close to the end of the page - which is why it overflows to the next page) (GROUP) CHILDREN - GIRLS Claire Kylie Evelyn Margaret Jessica Olivia <PAGE BREAK> CHILDREN - GIRLS (CONTINUED) Rosy Stephanie Tara Tracy Vanessa Vivian -------------------------------------- I need the data that follows onto the next page after the page break to also distribute evenly between the columns even if it does not reach the end of the page... Basically, the data needs to distribute evenly between the columns all the time and not only before a page break. Even a normal group which fits on one page (no page break) needs to be distributed evenly instead of first filling the first column till the end of the page and then only starting to fill column2.

Using iReport 4.0.1 (jasperreports 4.0.1) JDK 5

At the moment I have something like the following: Grouped by CHILDRENData sorted alphabetically (top to bottom / left to right)2 columns of data (distributed evenly between both columns - last column might have one name less if the array is of an odd numbered size)-------------------------------------------- (GROUP) CHILDREN - GIRLS Claire Rosy Evelyn Stephanie Jessica Tara Kylie Tracy Margret Vanessa Olivia Vivian -------------------------------------------- PROBLEM:When there is a page break for the group, the data still just flows within the columns over the pages as follows: -------------------------------------------- (GROUP) CHILDREN - GIRLS Claire Rosy Evelyn Stephanie Jessica Tara <PAGE BREAK> CHILDREN - GIRLS (CONTINUED) Kylie Tracy Margret Vanessa Olivia Vivian -------------------------------------------- SO NOW WE HAVE: Page 1: Column 1: C > J Page 1: Column 2: R > T Page 2: Column 1: K > O Page 2: Column 2: T > V REQUIREMENT:When there is a page break for the group, the COLUMN data should not flow over pages but should first display it alphabetically on the first page (between the two columns) and then continue on the second page alphabetically again. -------------------------------------------- (GROUP) CHILDREN - GIRLS Claire Kylie Evelyn Margaret Jessica Olivia <PAGE BREAK> CHILDREN - GIRLS (CONTINUED) Rosy Tracy Stephanie Vanessa Tara Vivian -------------------------------------------- SO NOW WE NEED... Page 1: Column 1: C > J Page 1: Column 2: K > O Page 2: Column 1: R > T Page 2: Column 2: T > V CURRENT DATA:Currently to get the data I do the following: Populate an alphabeticalList containing all the girlsUse some processing to split the list into two listscolumn1ListClaireEvelynJessicaKylieMargaretOliviacolumn2ListRosyStephanieTaraTracyVanessaVivianAdd each list to a subreport.column1List assigned to COLUMN1(subreport) in detail bandcolumn2List assigned to COLUMN2(subreport) in detail band QUESTION:Is there ANY way that I can achieve this? Either through Java before I send it to Jasper, or on the iReport side? Maybe even a scriptlet? I need the data to sort alphabetically in a group between the two columns, but if there is going to be a page break it needs to know how much data it can fit in on the page in the group before the page break so that the alphabetical list does not continue to the next page but rather first go to the next column... and then on the next page it should continue as normal. Explaining this sounds confusing so I hope my explanations above are more clear.

Hi, I'm using JasperReports 4.0.1. When I export a report to EXCEL, there seems to be many extra columns and rows if the reports elements are not aligned perfectly. I have tried using the following code but the extra columns and rows still show. I'm trying to use the same report for PDF exporting as well as EXCEL exporting but I'm sure there must be an easier way to get rid of the extra columns than to align ALLLLL of the elements perfectly. Anyone have any suggestions? :) Code: exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);exporter .setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, Boolean.TRUE);[/code]

Does anyone know how to put an input control for the report format so that it's automatically generated in that format when the user runs the report? I know you can export to any format using the EXPORT options once the report has already been generated but is there a way we can do this so that it generates correctly the first time?

Hi Does someone know a link to all the reserved parameters that we can use when requesting a jasperserver report? In the JasperServer Ultimate Guide it says the following: "The report execution parameters can either be reserved parameters that the server uses to determine general attributes of the report execution, or they can be arbitrary parameters that correspond to the report’s input controls/parameters." The JasperServer Ultimate guide only mentions a few of the "reserved parameters". For example, it doesn't include the "decorate" parameter which I found online. Where can I find a list of all the parameters we can use? I currently add "&decorate=no" to my URL but it still shows the "Back" button which allows users to browse the repository which we dont want. How can we go about disabling that from the URL?

Thank you! =D

Just to confirm, is it JasperServer 4.1 or iReport 4.1 which I will need to upgrade to? Thanks so much!

Well, my general requirement is to just get the organization name on the report without hardcoding it, but seems like thats not possible so we're going to try using a scriptlet instead. Will see if that works :)

Hi Everyone, From the forums I found the solution to internationalizing the labels for input controls by using net.sf.jasperreports.prompt.label.>name< in your resource bundle which corresponds with the labels id. However, I'm now stuck with internationalizing the list of values in a single / multi select list of values. I tried using the same solution above but it doesn't work. In the List of Values properties, you can define the Name and the Value. I've tried different ways of implementing the above but I'm still not able to internationalize the list options. Does anyone have any solution to this? Thanks!

Does this still only work via the Web UI?

This is still not working. It needs to be the organization of of the report and not the organization of the logged in user. Can anyone offer any suggestions?

Have tried using the domain parameters but as you also said, the tenantid is not the actual name. I'll try add a query in the report as suggested. Thanks

Hi, does anyone know how to display the Organization name in a report? If the structure is (for example): Organizations/Test_Organization If I have a report in the Test_Organization, how can I display the organizations name in the report? Thanks Post Edited by javalogan at 04/07/2011 14:57 Post Edited by javalogan at 04/07/2011 15:33

Hmm that's interesting, I have never used the Last Page Footer band yet. My Page footer normally shows on the last page anyway. Is it two different subreports which you need ? one for the page footer and then a different one for the last page footer? If not, and its the same subreport, just remove the last page footer band and the page footer should display on the last page too.