khahn

The data source that you set up in iReport is not saved in the jasperreport. You have to redefine the data source when you add the jasperreport as a resource to JasperReports Server. For example, right-click the Samples folder in server and choose Add Resource. Use the Add JasperReport wizard Data Source button to define the data source. The JasperReports Server User Guide has step-by-step instructions in chapter 5 for adding a simple report to the repository. I think it might help to take a look. There's an article about setting up data sources here: jasperforge.org/plugins/mwiki/index.php/Jasperserver Regarding your email question, Do you know if it is possible to create a new top menu? A new button like view and create? Yes, you can create a new top menu. 1. In the actionModel-navigation.xml, you create a menu mutton similar to the ones you see there (see code). 2. In pro_nav_messages.properties (JRS-pro) or jasperserver_messages.properties (community), define the NAV key for example NAV_032_MYMENU. 3. Add a navigation path in the actionModel.primaryNavigation.js. Here's a link to a document that describes making some similar (but not exactly what you asked about) customizations to JRS-pro that might help: jasperforge.org/uploads/forum/102/87270/customizing_server.pdf See also: jasperforge.org/projects/jasperserver/docs Code:<!--context for view option on primary menu--><context name="main_mytopmenu_mutton">. . .<option labelKey="NAV_032_MYTOPMENU" action="primaryNavModule.navigationOption"actionArgs="mytopmenu"/></selectAction></context> Post Edited by khahn at 02/20/2012 23:26

These steps describe how to hide the Create > Domain menu for users who are not assigned the role of ROLE_DEVELOPER. If you want to define ROLE_DEVELOPER at the organization level instead of the root level, you have to use a slightly different syntax in the XML file. (see below) Log in as Superuser. Create the role, ROLE_DEVELOPER at the root level. Create a user, for example userdeveloper. Give the userdeveloper the ROLE_DEVELOPER. Give the administrator user and any other user who should be able to create Domains the ROLE_DEVELOPER. Only users having ROLE_DEVELOPER will be able to create Domains. For example, you probably want jasperadmin or another administrative user to be able to create Domains. If you're using Tomcat, open <tomcat>/webapps/jasperserver-pro/WEB-INF/actionModel-navigation.xml. If you're using another application server, find actionModel-navigation.xml and open it. Change the following condition testArgs value in the main_create_mutton from "ROLE_ADMINISTRATOR" to "ROLE_DEVELOPER". See code snippet below. Restart Tomcat Code: Post Edited by khahn at 12/13/2011 22:26

Henry, The problem is not with you. There is a bug. Sorry you were inconvenienced. There is a workaround. Change this xml file as described if you installed the bundled Tomcat. If you use an existing Tomcat or another application server, find the actionModel-search.xml file and make this change in the file. This fixes the File menu issue. Code: Post Edited by khahn at 12/05/2011 17:09

Start MySQL service on Windows or the daemon on Linux if it is stopped. If you installed the bundled Tomcat on Windows, you can use the Control Panel (look for the service named jasperreportsTomcat) or you can use the Windows start/stop script to start Tomcat: Code:Click Start > All Programs > JasperReports Server (version) > Start or Stop Services > Start Service.On Linux, enter:cd <js-install>./ctlscript.sh start

If you use Tomcat, I think you need to do this: Code:1. Change the directory name of the <tomcat>/webapps/jasperserver to <tomcat>/webapps/mynewname.2. Open <tomcat>/webapps/mynewname/WEB-INF/web.xml and change this element:FROM: <param-value>jasperserver.root</param-value>TO: <param-value>mynewname.root</param-value>3. Delete <tomcat>\conf\Catalina\localhost\jasperserver.xml.4. Delete <tomcat>\work directory.5. Restart Tomcat.

You're very welcome. Yes, your solution seems much easier, and far superior in simplicity. Thanks for sharing, I'm sure others will appreciate it.

Hi Mwarne, In case you aren't monitoring the thread with synchro, I wanted to tell you about a workaround that will fix the missing File menu problem in your installation. Sorry you had this problem. We are fixing it. Thanks for your patience. Code:1. open <js-install>\apache-tomcat\webapps\jasperserver\WEB-INF\actionModel-search.xml.2. delete line 21 <condition test="isProVersion"> 3. delete line 25 </condition> Line 21 is the line after clientTest= . . .4. restart tomcat

Sorry for the inconvenience the missing File menu has caused you. We're looking into fixing this asap. In the meantime, there's a workaround. Delete the condition on line 21 and the close condition on line 25. See below. Regarding the exported files you have, any chance you can get the party who gave it to you to run the export command again with the options to export everything you need? Code:1. Open <js-install>\apache-tomcat\webapps\jasperserver\WEB-INF\actionModel-search.xml.2. Delete line 21: <condition test="isProVersion"> 3. Delete line 25: </condition>Restart Tomcat.

Yes. On the command line, on Windows: Code:cd <ireport-dir>/binireport.exe --jdkhome "<any java home directory>"This overrides the default, which goes to JAVA_HOME in your system environment. Post Edited by khahn at 12/01/2011 21:44

Thanks very much for sharing your solution for the auto-start on boot. You're absolutely right and I'm going to enter a bug about the script not being provided. I'll tell Matthew we need to replace the editor, in case he hasn't heard. Thanks.

Download 1.6.27 (http://www.oracle.com/technetwork/java/javasebusiness/downloads/java-archive-downloads-javase6-419409.html#jdk-6u27-oth-JPR) and re-set your JAVA_HOME environment variable in the Control Panel.

Some customers have reported the hanging issue when trying to connect to SQL Server 2005. We just traced it back to a buggy JDK update 1.6.29. You can determine which Java version iReport is using by clicking Help>About iReport. It might not be the one you think.

I think your repository is messed up from importing the old repository that needed to be upgraded first. The upgrade chapters of the install guide talk about this. The menu problem is probably caused by the incompatible repository you imported. Do you know which version of JasperServer the files came from? The procedure you need to follow depends on the version.

There's an answer from the distinguished S. Wood in reply to this forum post, which says that what you need to do is start Tomcat at boot time and here's some instructions for doing it.

Sorry you're having problems and for the delay in answering. You shouldn't have to manually import anything--images, input controls, or any other resources. The engineer is working on a release right now, but please give me a little information, so I'll can ask for a recommendation about how you should proceed. 1. Did you install using the WAR file distribution? If so, see the attached chapter from the install guide and check your import-export utilities. Check your js.jdbc.properties as explained in the chapter if you used the WAR file distribution. 2. Which operating system, database, and application server are you using? 3. What version of JasperServer were you using before installing 4.2? To answer your question about what happened to the File menu, it's here: click View > Repository. Right-click a folder and select Add Resource>File>Image. You have to right-click a folder where you have write permission. If you installed sample reports, try Reports. Post Edited by khahn at 11/30/2011 00:47 Post Edited by khahn at 11/30/2011 00:52

I haven't tested these steps, but hope they give you the general idea. After adding the menu, you won't be able to see the Manage menu. By using Themes, you move one the new menu to the right so it doesn't hide the Manage menu. Code: Post Edited by khahn at 11/29/2011 23:20

Today, I posted an article written by Product Management: http://jasperforge.org/plugins/mwiki/index.php/Jasperserver/REST_Web_Services_API It includes an example that you can download. The REST API is documented in the JasperReports Server Web Services Guide, Release 4.2. You can download the trial version of the commercial JasperReports Server and find the Web Services Guide with the other PDF manuals in the docs directory. In the next release, more documentation about the REST API will be added. Post Edited by khahn at 12/02/2011 21:51

Thanks for letting us know. Glad you had better luck this time and sorry you had a problem.

To return different data to users of the same report, you define data-level security based on user roles and profile attributes. This is available in the commercial version for reports based on a Domain, Domain Topic, or OLAP client connection. On the community project version, perhaps you could include a check for the user role in a custom input control. I'm just guessing, but could probably get a definitive answer. Are you interested in writing a JSP to create a custom input control (see attached how to)?

You use existing Tomcat and PostgreSQL, right? Not the versions bundled with JasperReportsServer, right? I think you need to restart both, but do not use "./ctlscript.sh . . . ". This is for use only with the Tomcat and PostgreSQL bundled with the JasperReports Server. Please restart the database: Start/Stop login as root su postgres pg_ctl -D /opt/PostgreSQL/9.0/data start pg_ctl -D /opt/PostgreSQL/9.0/data stop Then restart Tomcat.

You're welcome. Yes, I unzipped the rar and looked at the JPGs, but I didn't understand. I think you need to create a custom data source. JasperReports open source library has a set of free JasperReports samples. To learn about custom data sources, please see the Data Sources section of: Samples reference There are many samples. Attached are your jpgs in a Windows compressed zip file so others can unpack them easily. Post Edited by khahn at 11/24/2011 17:08

Hi Jack, Sorry for the delay in answering. Please see the attached PDF that shows how to set up a connection to a database in iReport, create the query, design a table report using two columns like UserName and UserAge. Does this help? Post Edited by khahn at 11/24/2011 05:35

Maybe the problem is your SQL Server 2008 R2 needs to allow remote connections. Please try this: 1. Start the SQL Server Browser. 2. Enable TCP/IP protocol for SQL Server 2008. Use the SQL Server Configuration Manager. 3. In SQL Server Management Studio, enable SQL Server and Windows Authentication mode. 4. Restart the database service. I successfully connected using SQL Server 2008 R2, iReport 4.0.2, JDK 1.6, and the sqljdbc-1.6.jar shipped with JasperReports Server. I had to add the JAR to iReport classpath. To add the JAR on iReport 4.0.2, you click Tools>Options, go to the classpath tab under the iReport category. See attached image for connection settings. Post Edited by khahn at 11/22/2011 19:56 Post Edited by khahn at 11/23/2011 00:56

Delighted to hear of your success. Thanks for your interest in the product.

The data source can be different from the database configured for JasperReports Server if the application server can find its driver. For example, in a default installation of JasperReports Server, Tomcat looks for data source drivers in(js-install-directory)/apache-tomcat/lib. Put a copy of the driver in this location. Use the JDBC driver mysql-connector-java-5.1.17-bin.jar or later. Do the User Guide instructions for adding a report unit to the JasperReports Server help? Post Edited by khahn at 11/17/2011 02:17