[Upgrading jasperreports 6.4 -> 7.2 reports fail]

Hi,

It looks like you need to add the Microsoft SQL Server database driver to your 7.2 environment. Just grab the Driver JAR file from your 6.4 environment and put it in the TOMCAT_HOME/lib directory (server re-start required). Let me know if this helps.

[I am stuck while installing jasper report server in jboss EAP 7.2.8.GA. Below is the logs.]

Hi,

Installing JRS on JBoss is usually tricky ... did you manage to get past this problem? It usually requires a lot of troubleshooting to do it (it's much simpler on Tomcat). Contact me if you have questions.

Gonzalo

[How to display Gujarati collation of Unicode like :મુખ્ય using ireport 5.6.0 and JAVA]

Hi,

It's best for you to upgrade, I know that iReport is no longer supported by TIBCO, and you should use Jaspersoft Studio. What version of the server are you on?

[How to update iReport report in Jaspersoft]

This looks like some kind of a classpath error. Maybe you didn't install Jaspersoft Studio correctly. What version of iReport are you using? Do you have these reports already deployed in a server already?

[java.lang.NullPointerException Error from JasperReportsIntegration]

It sounds like maybe you're not passing in a datasource correctly. If it's working in Studio, then it's a matter of properly deploying it to Tomcat. I'm going to guess that you have deployed other reports to Tomcat without a problem, so the next most likely thing is a datasource problem.

[Whats the formula for counting inactive tickets?]

Not enough information to tell you. I think you should file a ticket with Support.

[FYI: Will be taking days off]

May she rest in peace, and my condolences. She will live on in your memories. Please accept my sympathies for your loss.

[com.jaspersoft.jasperserver.api.JSException: jsexception.error.creating.connection]

What kind of datasource is it? If it's a JDBC datasource, perhaps you can create a JNDI datasource instead.

[Calling Jasper Report from Python Program]

Although I couldn't find an example, I think that one approach would be to take advantage of JasperReports Server's web services functionality. I know that you can integrate web services call in Python, so that would be lightweight, loose coupling between the two. There's a web services guide under the docs folder where you installed JasperReports Server.

[how to read csv files from ftp]

 For what you describe, you'll need a custom datasource. Your other alternative is to set up an ETL job that connects to the FTP site, and pulls the file over to a file system where iReport can reach it.

[postgressql to MS SQLServer]

 Hi Benedikt - Unfortunately there's no support for JBoss 6.0 - take a look at this sheet: http://www.jaspersoft.com/sites/default/files/Jaspersoft%20Platform%20Support%20V4.7.pdf, page 2 has a list of supported application servers. It supports JBoss 5.1 and 7.1, but no 6.x.

[Is jasperserver what I\'m looking for?]

Jaspersoft also has some YouTube videos that showcase the different things the product can do - http://www.youtube.com/user/JaspersoftBISuite, including the self-service requirements you mention.

[Invalid email address in report scheduler]

Dane, what you found makes sense with what I found as well, some security checks are configurable, while others are hard-coded. The DefaultReportJobValidator class gets used by the defaultReportJobValidator bean in a Spring configuration file (applicationContext-report-scheduling.xml), so I suppose it would be straightforward enough to create your own validator class and swap out the one that's currently there. 

[Report with photo]

 Hi, you can do this by using the Image component (it's in the palette), and dragging it over to one of the report bands. Then, you're going to have to add an "Image Expression" (it's one of the properties for an Image; you can see the properties when you select the Image in the report).

For the Image Expression, you can give it a value like: "http://myserver.com/images/example.jpg" (that would be a hard-coded image reference), or you can create that image expression with variables or parameters. You'll get the dynamic JPEG images you want by defining that image expression with variables and parameters.

[Can JRXML access JasperServer file System]

 Hi Asif,

iReport lets you specify what to do in case the report can't find the image. There are three choices: "Error", "Blank", and "Icon". If you have "Error", then the report errors out and won't generate anything (that sounds like what's going on with your situation). "Blank" means that it will leave that area of the report blank, and generate the rest of the report. "Icon" puts a placeholder icon in there, in place of the missing image.

Open up the report in iReport, then select the image, and then look at the properties window. There's an image property called "On Error Type". Set the value to "Blank", and then re-upload the report to the server and test. I hope that helps, good luck!

 

[MS SQL and JasperServer Community Edition]

 Not sure why that is, but perhaps you can try the jtds driver? It works with Microsoft SQL Server. You can find it here: http://sourceforge.net/projects/jtds/files/.

 

[Moving report from iReport to Reports Server]

 It's complaining about "Attribute 'uuid' is not allowed to appear in element 'jasperReport'."

Since you're using iReport 4.6 on JasperReports Server 4.5, I would try setting the iReport compability to JasperReports 4.5, and then re-save your report, and then upload it again to the server using the repository navigator.

You can set the compatibility by going to "Tools -> Options" then choosing the "iReport" button at the top, then the "General -> Compatibility" tab. Choose JasperReports 4.5.0 from the drop-down list, and see what happens.

[Invalid email address in report scheduler]

This may sound weird, but try it, just to see. So you've already modified the Validator regex. First try saving a schedule with an email that doesn't have a '+'. Then open it up again, and add the '+" sign back in. Do you still get the error message?

(I'm suggesting this because that's how I dealt with a Validator issue on a different screen, and that worked).

[How do I open multiple instances of Jasper iReport?]

I tried a couple of different ways, I couldn't get it to do it. You could try running two similar versions of iReport, that works. For example, I have versions 4.5.1 and 4.6, and I'm able to run both those at the same time. So that suggests if you want to run the same version, you may to re-install it but set it up in a different directory. Is there a particular reason you need to run more than one instance of iReport?

[postgressql to MS SQLServer]

Ok! It sounds like you haven't got much more to go. It's a good sign you got the "Build Successful" message after running the install script.

Since the install script doesn't actually start up your application server (I'm assuming you're using Tomcat), first make sure that you've started it up, and then hit the http://localhost:8080/jasperserver-pro landing page.

If you got the error after starting up the server, what did the server log say? You can check the server log under [TOMCAT_HOME]/webapps/jasperserver-pro/WEB-INF/logs/jasperserver.log.

 

[postgressql to MS SQLServer]

Hi, gr33nhat. Thanks for clarifying that you're using the community edition. Unfortunately, the community edition doesn't come with the database creation scripts for MS SQL. You would have to take the database creation scripts for MySQL or Postgres and port them yourself to MS SQL. I searched on the forums and found these topics that say the same thing:

 

MS SQL and JS CE  - http://community.jaspersoft.com/questions/539193/mssql-and-js-ce

MSSQL database schema's and data - http://community.jaspersoft.com/questions/532474/mssql-database-schemas-and-data

Installing JasperServer (3.5.0-CE) on MSSQLServer? - http://community.jaspersoft.com/questions/528952/installing-jasperserver-350-ce-mssqlserver

I would suggest that if at this stage you're just testing the product, continue using the postgressql database as the repository. Having it as a repository won't stop you from using MS SQL Server as a datasource for your reports.

 

The advantage of this approach is that you can go ahead and test the product functionality, and worry about the MS SQL problem only when you're ready to move forward with JasperReports Server. At that point, you can either move to the professional version, or concentrate on porting the database creation scripts for use with MS SQL Server (if you decide to stay with the community edition).

 

 

[postgressql to MS SQLServer]

Hi, gr33nhat. If you're using the professional edition of JasperReports Server, you can backup your postgres database using the export script under the buildomatic directory. This will export the repository data that JasperReports Server needs to run, and it will export it in a database-neutral way.

Then you would have to configure your default_master.properties file (also under the buildomatic directory) to point at your MS SQL database. You would then have to run the buildomatic scripts that create and populate the repository database that JasperReports Server will need.

Once that's done, you would then import the repository file you backed up previously into your new MS SQL database. All these steps are documented in the installation guide.

Regarding the second question, that's also explained in the installation guide.

[Prompt Option in Parameter]

 Hi  clshafer - you can find the documentation on setting up an input control in the user guide, which you can download from here -  http://jasperforge.org/espdocs/docsbrowse.php?id=87&type=docs&group_id=112&fid=365. It's a PDF, there's some instructions on page 49.

[Jasperserver-pro Adding Map Resource from iReport Error]

It sounds like you have installed Tomcat as a service, and are trying to modify settings using the GUI - that's the right way. When the GUI shows up, what do you see in the "Java" tab? 

[Jasperserver-pro Adding Map Resource from iReport Error]

Welcome! I see an Out of Memory error, so I would deal with that problem first. Since it's happening at the server level, try adding more memory to Tomcat's JVM - start with 2 or 4 GB. Then re-start your server, and see if you get that "out of memory" error again.