jbo_master

hello all, Is it right that we can override the sorting order of a row or column group of a crosstab by a comparator expression? If we can, does anyone of you guys have an working example of such a "comparator expression"? Thanks for your help

hello all, i created a crosstable and placed it on the detail area of my main report. What i want to achieve is: When a placed field on the ColumnHeader changes its value, this value should be passed to the crosstable as a parameter for to use in its query? Is this possible? Are there any examples? :S

hello all, i placed 2 subreports on the summary area of my main report and set the position type of the lower subreport to "float". After that I exported the report to pdf file format. When I try to open the generated pdf-file I get the error message that the file is corrupted and can not be opened! Is this a bug or feature of jasper reports? Any ideas?

Hello all, is there a way to create a pdf-report and let jasperserver store it directly on the server file system? We only want to trigger the report creation and later access this file without using the jasperserver-ui. thanks in advance ;) Post Edited by jbo_master at 06/22/2009 09:25

1.) Deploy your report on jasperserver as reportUnit. 2.) Upload your image (for example "testimage.jpg") into "Resource" folder. 3.) Set path to the image as "repo:testimage.jpg" Or: On Jasperserver create a new folder called "images" under the "root"-folder. Set path to the image as "repo:/images/testimage.jpg"

Hello @ all, I wanted to create and store a report as pdf on my server using java.(JasperReport is running on a different Server.) How is it possible to make a connection to the JasperServer and retrieve a JRXML-File that was deployed as a ReportUnit? Is there something like a repository-service that can be accessed from outside? Does anyone have some code examples or can provide some good links? This is the piece of code I am currently using to create a pdf-file: Code:...public void createReport() throws JRException { JRXmlDataSource xmlDataSource = new JRXmlDataSource(TEST_DATA_PATH, ); JasperReport jasperReport; JasperPrint jasperPrint; jasperReport = JasperCompileManager.compileReport(REPORT_JRXML); jasperPrint = JasperFillManager.fillReport(jasperReport, new HashMap(), new JREmptyDataSource()); JasperExportManager.exportReportToPdfFile( jasperPrint, OUTPUT_PDF); }...

That was my mistake. I placed the $R{FOO} on a lable instead of a TextField. ;)

What I try: First I defined a Resource Bundle on the Main-Report settings. In my case Test. The I have created two property files called Test.properties and Test_de_DE.properties and placed some strings into these files. For example text.titlemessage = This is a test title message ... After that I dropped a textfield onto my subreport with the following Text Field Expression: $R{text.titlemessage} All files are in one and the same folder. I started my main-report and it shows the value $R{text.titlemessage} instead of the defined message of the properties file? Any suggestions?

Hello @ all, I have a question regarding localization /i18n of subreports. Is it possible to localize a subreport? I just tried it but without success. :(

I finally found the solution. ;) There are two possibilities. 1.) If the report is deployed as a "report unit" and the image is provided in the "Resources" folder, the path (image expression) has to be the following: "repo:imagename.jpg" By the way. The same could be applied to link a subreport to the main report. Add your Subreport-JRXML-File to the Resources of your Report-Unit and change the subreport expression to the following: "repo:nameOfYourSubreport.jrxml" 2.) Deploy your report as a "report unit", create a new folder for example "images" on the JasperServer with the help of the Webadmin-Interface, upload your image into this folder. The path (image expression) to your image would be the following: "repo:/images/imagename.jpg"

Hello @all, i have the following problem: I have a report with an image on it I have set the property of the image to "repo:/Reports/TestReport/Resources/image.jpg" I deployed the report with the help of the "repository server" to jasperserver. I uploaded the image to the Resource-folder. On executing the report i am getting the following error: com.jaspersoft.jasperserver.api.JSExceptionWrapper: Error loading byte data : repo:/Reports/TestReport/Resources/image.jpgcom.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Error loading byte data : repo:/Reports/TestReport/Resources/image.jpg It seems that JasperServer can not resolve the path to the image? Any ideas? Thanks in advance

Hi, I have the following crosstable, which contains Products and differnet Seasons. Each product can have 3 Subtypes. Each Season can have differnet Dateranges. I defined a row-group that contains the product and another one for the corresponding Subtypes: I defined a column group for the Season. Now my problem is: How can I iterate through a list of dateranges that correspond to a specific season as it is shown in the below table?? I thought of placing a List-Component in another Column-group, passing it the parameter that contains the specific season and then it should iterate through the list and show all datenragens in a column. But it doesn't work. Any suggestions ?? Season A Season B 01.01.2009 to 31.01.2009 01.02.2009 to 28.02.2009 14.05.2009 to 16.05.2009 01.03.2009 to 30.03.2009 01.04.2009 to 31.04.2009 Product 1 Subtype A 23.99$ 21.87$ Subtype B 47.77$ 95.37$ Subtype C 28.39$ 75.39$ Product 2 Subtype A 2.55$ 12.23$ Subtype B 8.77$ 123.23$ Subtype C 4.29$ 1$

You can insert a so called "report group" to your report and group by your number-object.

any ideas ?? Post Edited by jbo_master at 06/11/2009 15:37

what about the following: .replaceAll("^0+", ""); Post Edited by jbo_master at 06/08/2009 11:10

XPath itself doesn't support sorting ! Mayby you can group your data on that specific field.

Hi, I have the following crosstable, which contains Products and differnet Seasons. Each product can have 3 Subtypes. Each Season can have differnet Dateranges. I defined a row-group that contains the product and another one for the corresponding Subtypes: I defined a column group for the Season. Now my problem is: How can I iterate through a list of dateranges that correspond to a specific season as it is shown in the below table?? I thought of placing a List-Component in another Column-group, passing it the parameter that contains the specific season and then it should iterate through the list and show all datenragens in a column. But it doesn't work. Any suggestions ?? Season A Season B 01.01.2009 to 31.01.2009 01.02.2009 to 28.02.2009 14.05.2009 to 16.05.2009 01.03.2009 to 30.03.2009 01.04.2009 to 31.04.2009 Product 1 Subtype A 23.99$ 21.87$ Subtype B 47.77$ 95.37$ Subtype C 28.39$ 75.39$ Product 2 Subtype A 2.55$ 12.23$ Subtype B 8.77$ 123.23$ Subtype C 4.29$ 1$ Post Edited by jbo_master at 06/11/2009 15:36

Thats very clear, but your are talking about how to delete a field. What I wanted to know is how to delete the complete total ROW? ;)

Hello everybody, Is it possible to place a specific measure field from the detail band of a crosstab to the columnheader of the same crosstab. I tryed it but it show always a "null" value. The reason could be that the measure field gets computated at a later time. I also tried to change the evaluation time of this element, but this feature is not supported inside crosstab cells. :( Any suggestions?

Hi everybody. how is it possible to remove the total row from a crosstab ???

Where can I find the window to manage / access a list of available resource files (locale resource bundles). I am using iReport 3.5.1 and I am missing the menu entry "Edit ➤Internationalization ➤Localization files." as it is written in giulios book "The def. guide to ireport" ??? Thanks for your help

I solved my problem by using a crosstab. ;)

"The records coming from a datasource (or from the execution of a query through a connection) can be ordered and filtered. Sort and filter options can be set from the Report query dialog box by clicking the buttons labeled Sort options and Filter Expressions. The filter expression must return a Boolean object: TRUE if a particular record can be kept, FALSE otherwise. The sorting is based on one or more fields. Each field can be sorted using an ascending or a descending order."

Here it comes .... You have to define a new xml-datasource that points to your xml-file. In the report properties you have to set the following properties: The language for the dataset query: xPath Query Text: /testRoot Then you have to create a field for example TEST_FIELD. The description property defines the xQuery to get the value of your testField element. In your case it must be: testField Create a Text Field on the detail band. Set the property "Text Field Expression" to the following value: $F{TEST_FIELD} That it. Check out the sample files....

Hello @ all, i have one question. I devided my detail band into several columns and switched the printing order to vertical. Now when a group changes, because of its group expression, is it possible to have something like "start on a new row" instead of "start on new column"? Thnaks in advance