fcerbell

Hi, Did you try the "locate", "which", or "find" command to find the scripts ? Otherwise, if you connect as "superuser", you will find the import feature in the "Manage > Server" menu and the export feature in : - the repository view, by right clicking on a folder (left panel) - the repository view, by right clicking on an item (right side) - the menu "Manage > Server" Regards

Jaspersoft provides commercial support when you want to use a commercial edition. The community could provide help when you want to use a commercial edition. If you want to leave the commercial edition, you can only find help in the community. No editor, as far as I know, provide help to leave them. As long as your report dont use any of the commercial edition feature (fusion charts, fusion widgets, fusion maps, HTML5 high charts, domain queries, adhoc views, adhoc reports, dashboards, ...) the report sould be compatible with the community edition. So, exporting the repository and reimporting it in the community should do the job.

I would say that your tomcat process is dead. try to do a 'ps aux | grep [t]omcat' to see if there is still a tomcat process. If yes, you have to kill it with signal 15 and then with signal 9. Then, you can have a look at the catalina.out log file to have an idea of the reason and finally, you can try to restart your tomcat. Regards

Hi, In iReport or JasperSoft Studio : Add a background band to your report, Resize the band to fit you reports dimensions Add a Frame component in the background band (The previous answer uses a static text, which should also work, but the frame is a better fit) Adapt the Frame's dimensions to its parent (the band) Change the Frame background color. Regards

Hi, As far as I know, the latest release which supported Java 1.5 is the 4.2. In doubt, the 4.1. Regards

Hi, You have to create an input control in the report unit created in JasperReport Server. This Input Control needs to have an ID with the exact same syntax than the related parameter name in the report. Then, you will be able to add &ParameterName=Value to you URL Regards

You can find the list in the JasperReports-Server-Admin-Guide v5.5, chapter 4.4.2 Built-in Parameters for Query-based Input Controls, p 90, also available online : http://community.jaspersoft.com/documentation/jasperreports-server-administration-guide/v550/query-based-input-controls

If you have Adhoc, it means that you are using one of the commercial editions of JasperReports Server (Pro or Enterprise). So, you iReport Pro and Jaspersoft Studio Pro are included in your license

They are listed in one of the JasperReports Server guides (either ultimate guide, or admin or user guide), I don't remember exactly in which one.

Hi, You created your reports using the AdHoc editor. The charts in AdHoc are HTML5 charts (HighCharts) and dont support chart customizers. You can only use Chart customizers with JFreeCharts components. Regards François

Hi, You can create parameters in you report, with a specific name and datatype. Then these parameters will be automatically filled when the report is executed by JasperReports Server. There are about 10 such parameters. As an example, try to define a parameter in your report : LoggedInUsername (java.lang.String), with no defaut value. Then, you can use $P{LoggedInUsername} in a text field, in a query, in a printWhenExpression, ... Regards François

I like this idea, as it would always work and would help the end-user without boring him with technical details.

Jaspersoft Studio is Eclipse based. When you try to open a connection over SSL, java tries to validate the certificate using the known certificate issuers. Because a certificate which is signed (certified) by an untrusted person is useless and dangerous. Then, I think that the certificate/key pair used on your JRS server are signed by your own authority or self-signed. It means that Jaspersoft studio can not check the certificate validity as he does not know the CA and he does not have the CA certificate to validate the signature. Jaspersoft studio searches for the Keys and certificates in a keystore. So, you have to import in Jaspersoft Studio keystore the certificate of the CA who signed your server's certificate. Then, the CA will be known, trusted and JSS will have its certificate to check the server's certificate validity. You can use "keytool" to import your certificates. Describing the whole process in few lines is not easy, I hope that my explanations were clear. Regards François

I think that you added the variable in the main dataset, whereas you chart is using a sub-dataset.

Hi, The dataset sort feature is useful when the query language does not support the kind of sorting that you want to achieve. If you get a list of cities from a SQL database and you want to sort them on their population fetched from a webservice, for example. It can also be because you want to sort and the query language does not allow sorting at all. It your case, did you try to add an ORDER BY statement to your SQL query ? Did your qery returned what you expected when you ask to preview the data (the tab at the bottom of the query dialog) ? Regards François

Hi, I am not sure that the parameter would be null when you make no selection in a multi-select Input control. Could you try to change the query to something as : select name from accounts where $X{IN, billing_address_country, Country_multi_select} and $X{IN, billing_address_state, Cascading_state_multi_select} and ( billing_address_state is not null AND billing_address_state <> "" ) order by name It is just a try Regards François

Hi, If your date field is $F{DateField}, if it is a string, if you need to provide a java.util.date datatype, then instead of using the $F{DateField} expression, use the following expression : new SimpleDateFormat("yyyy/mm/dd").parse($F{DateField}) Possible optimization : If you use this information in several expressions, it might be better to evaluate it once for every row and to use this evaluation : create a variable with the previous expression and to use this variable instead of the field everywhere. The String to date conversion will occur only once and its result will be used everywhere. Regards François

Well, you dont have a lot of folder to remove from the repository, you have two schemas to remove from the database and about 15 lines to remove from one file. It seems to be feasible. But, reinstalling would be a good option as you missed some important informations from the install guide. You would have the opportunity to better understand and it would improve you knowledge on JRS. There is a note in the install guide against installing the packaged bundle in production. So, you have to execute the manual WAR installation which describes in detail all the steps. You should not install a product in *production* before reading the whole install guide. You are talking about production, not dev, not test, ...

I said "Maybe". It is just a possible explanation. And the releases notes are not here to list all the bugs closed. Their goal is to list the most significative and impacting changes since the last release. Of course, this could be improved. ;)

Hi, Well, I have split your question in 4 distinct points and I tried to answer each of them : 1 - The export bug in 5.1 was fixed. All the fixed bugs are not listed in each release note. Only the most important bugs. 2 - Page 141 of JRS 5.5 Install Guide does not say that the bug is fixed (even if it is). It gives a workaround to import a repository exported from JRS 5.1 web user interface. It is a process to follow, not a note, and it has to be in the Install or Admin guide. 3 - Why nothing in the releases note of JRS 5.2 : because of points 1 and 2 4 - Why nothing in JRS 5.2 Install Guide ? Maybe because the bug in 5.1 and/or its workaround for newer versions were discovered after 5.2 was released. Regards François

Hi, if you installed iReport, in <installdir>/demo/samples, you have a lot of examples. If you want to use this sample code, you have to add some JAR files distributed with iReport. But if you could explain "it does not work", you could have a more detailed answer

You should enter a bug in the tracker.

You could try to use the table component's PrintWhenExpression to hide the component when you have no data and to have a Statis Text component superposed to the table component with the opposite PrintWhenExpression.

Hi, Could you explain why you don't want to use the No Data Band, as it is exactly its goal. Regards François

Hi, I dont think that there is such a command. Furthermore, you will also have to remove the JNDI connections in the META-INF/context.xml file and in the copy of this file made by Tomcat in his configuration folder. Regards François