General

1. Where can I find a pricelist?
2. Is ERES fully platform-independent?
3. I need to generate reports and dashboards for a very specific industry, can Quadbase help?
4. What file extensions are used in ERES?
5. The default ERES look doesn't match our company's webpage/IS.

Platform and Getting Started

1. Why can't I Install ERES? / I get a no Java virtual machine installed message when trying to install ERES.
2. Does ERES run well under Windows 7 (or Vista, 2008...)/MacOS/Linux?
3. Which browsers does ERES support?
4. I can't start ERES.
5. What Java version should I use?
6. I am not sure how to set some options during installation process.
7. What is an ERES database?

Working with ERES

1. When I export a report to PDF/XLS in IE7+, yellow bar with warning message shows up ("To help protect your security, Internet Explorer blocked this site from downloading files to your computer. Click here for options...").
2. I can't connect to my database (MSSQL, Oracle...). I get "ClassNotFound" error
3. How do we update the license after we copied/moved ERES to new machine?
4. After updating our ERES install, the evaluation message is displayed in reports and charts.
5. Export of big reports and charts are really slow / I get Out of memory or Java heap space error exporting big reports and charts.
6. ERES Organizer won't start.
7. I moved a dashboard to other location and it isn't working properly.
8. I exported a report or chart to PDF and fonts in the PDF are different than fonts in the ChartDesigner. / I have problems displaying Unicode characters in exported PDF.
9. I made some changes to a PAK file, saved the changes, but the changes weren't saved.
10. ERES Maps aren't working.
11. Maps aren't showing all of my data.
12. What is a "Virtual Directory"?
13. In scheduler, I chose "Email delivery", but no emails are sent.
14. I got an "java.lang.NullPointerException" error when working in QuickDesigner, MapsDesigner etc...
15. I moved a report with charts/subreports to other machine and the subreports/charts are missing.
16. I changed a data source (for example: query) in Organizer, but the changes did not appear in a report that uses this datasource.
17. I have modified some configuration files/options in Admin Console, but the ERES is still using the old settings.
18. I made a report/chart/dashboard, saved it, but forgot to insert it into organizer. Where do I find the file and how do I save it into Organizer?

API

1. How do I connect to my database?
2. Excel export isn't working in API.
3. Which JAR files do I have to add to my classpath if I want to work with the API?
4. I exported some reports via API, but there is "evaluation copy..." message in the reports.
5. Does the ERES Server need to be running if I want to generate reports via ERES API?
6. I don't know how to start, are there some working API examples with source code available?

Where can I find a pricelist?

Our products serve a wide range of customers with varying goals. To ensure the lowest costs and most effective results, we will create a custom package that works for you and your company's needs. Please contact our sales department at sales@quadbase.com to build your package.

Is ERES fully platform-independent?

Yes, it's written in pure java and can be run on any platform that supports Java.

I need to generate reports and dashboards for a very specific industry, can Quadbase help?

Our support team stands ready to help you design professional reports and dashboards for your targeted audience. We can even use samples from your actual data to provide meaningful templates and examples. Please contact Quadbase support at support@quadbase.com to discuss with a representative regarding your specific requirements. For more involved projects, please inquire about our professional services.

What file extensions are used in ERES?

ERES uses the following extensions:
RPT - Report Designer report
QRP - QuickDesigner report
CHT - ChartDesigner chart with data
QCH - QuickDesigner chart
TPL - ChartDesigner chart template
PAK - Report archive
DSB - Dashboard
GXML - Google map
SXML - SVG map
CXML - Google map coordinates
SVG - SVG map image

Why can't I Install ERES? / I get a no Java virtual machine installed message when trying to install ERES.

ERES requires a Oracle / Sun Java Development Kit (JDK) installed on your machine to install and run. If you only have a Java Runtime Environment (JRE) or if you don't have Java at all, please visit the Java SE Download Page and download the latest JDK.
If you have both JDK and JRE installed, make sure to select the JDK folder on the select Java VM panel in the installer.

The default ERES look doesn't match our company's webpage/IS.

The ERES appearance can be easily modified without any programming by using the customization feature found under the Admin Console.

Does ERES run well under Windows 7 (or Vista, 2008...)/MacOS/Linux?

Absolutely. One of the advantages of having a Java based product is that it can run on any OS that supports Java.

Which browsers does ERES support?

Internet Explorer (6+) and Firefox. The Java plugin is required for designers using the Organizer. JavaScript and cookies must be enabled for all users.

I can't start ERES.

First, start Tomcat by navigating to <TomcatInstall>/bin/ and running startup.bat on Windows or startup.sh on Unix/Linux/Mac/etc. Next, open ERES start page in your favorite browser, the default address is http://<Host>:8080/ERES, but this can be altered during installation. Finally, click the Start button in the ERES Server section.

What Java version should I use?

The ERES Server requires Sun Java Development Kit (JDK) version 1.5. Any designers using the Organizer will need to have a JRE plugin for their browser. No Java is required to use the QuickDesigner, Map Builder, and Dashboard Builders remotely, and end users do not need Java to view finished reports, charts, maps, and dashboards.

I am not sure how to set some options during installation process.

You may find an answer in the User Guide

Click 1) Administration and then click 2.) Installation and Configuration

If you don't find the answer there, don't hesitate to contact us (support@quadbase.com).

What is an ERES database?

The ERES Database stores data critical to the ERES system such as like the Organizer file structure, security and permissions, etc. This is not to be confused with the data sources you will use to create reports and charts.

When I export a report to PDF/XLS in IE7+, yellow bar with warning message shows up ("To help protect your security, Internet Explorer blocked this site from downloading files to your computer. Click here for options...").

To turn off the warning for all websites:
In IE7+, click Tools -> Internet Options. Go to the "Security" tab and then click "Custom level". Scroll down to the "Downloads" section. Switch the "Automatic prompting for file downloads" to "Enable". Click OK, Yes, OK.

To add ERES as a trusted website and turn off the warning for all trusted sites:
In IE7+, click Tools -> Internet Options. Go to the "Security" tab, click on the "Trusted sites" icon, and click on the "Sites" button. Type in the host for the ERES Server, (e.g. http://www.quadbase.com) the port number is not necessary. Uncheck the box "Require server verification (https:) for all sites in this zone". Click Close. With "Trusted sites" still selected, click on "Custom level". Scroll down to the "Downloads" section. Switch the "Automatic prompting for file downloads" to "Enable". Click OK, Yes, OK.

I can't connect to my database (MSSQL, Oracle...). I get "ClassNotFound" error.

You need to copy the correct database driver to the /WEB-INF/lib/ directory and restart the server. If using API, make sure to add the driver to the classpath. See this FAQ for details.

How do we update the license after we copied/moved ERES to new machine?

If you are copying the ERES to a new machine, you need to have a separate license key. The second license key can be used during installation or after the installation using the registration website. The registration site will generate a new qblicense.jar file specific to your machine.

If you are moving to another machine, the license key will be released when you uninstall ERES from the previous machine, so you can use the same license key during the installation on the new machine. You can also use the same key on the the registration website to generate the qblicense.jar file after installation.

If you use the website to generate the qblicense.jar file, make sure to copy and paste it into <ERESInstall>/lib/ and <ERESInstall>/WEB-INF/lib/ directories overwriting the files there and then restart the server.

After updating our ERES install, the evaluation message is displayed in reports and charts.

Go to /register.jsp to generate a new qblicense.jar and copy and paste it into <ERESInstall>/lib/ and <ERESInstall>/WEB-INF/lib/ directories.

Export of big reports and charts are really slow / I get Out of memory or Java heap space error exporting big reports and charts.

Increase the memory allocation to the application server. For Tomcat, go to /bin/ and edit catalina.bat (catalina.sh for non-Windows). Find the line:

set JAVA_OPTS=%JAVA_OPTS% -Xmx256M

Increase the 256 to a larger number. ERES also provides virtual memory and paging options to reduce memory usage for large reports. Please see the user guide under the "Virtual Memory/Paging Options" section.

ERES Organizer won't start.

If you are using .bat file, make sure that the ERES server is running. You might need to check your firewall settings as well and ensure that your machine is able to access the server host and the server port. If running from the web page, please make sure you have a JRE plugin installed on your browser.

I moved a dashboard to other location and it isn't working properly.

Use the Dashboard "Migration" feature described here.

I exported a report or chart to PDF and fonts in the PDF are different than fonts in the ChartDesigner. / I have problems displaying Unicode characters in exported PDF.

Make sure to set the "Font Mapping" correctly.
Documentation for Reports
Documentation for Charts

I made some changes to a PAK file, saved the changes, but the changes weren't saved.

PAK files unpack its contents every time you open them. You have to click "Save As" and choose the "Create PAK" option in order to modify PAK file.

ERES Maps aren't working.

Obtain Google maps API key. Please, keep in mind that you have to fill in the host name or IP address that will be used for connecting to ERES Maps. For example: If you fill in your domain name, Google maps will not work when you connect to ERES using IP address.

Maps aren't showing all of my data.

Make sure that you are using correct coordinates file.

What is a "Virtual Directory"?

When you want to add a file that is not currently accessible via your web server (Tomcat...), you have to manually add an URL that points to a folder that contains the file.

In scheduler, I chose "Email delivery", but no emails are sent.

Make sure to add your SMTP settings in the Admin Console. After you do so, restart the ERES server and try it again.

I got an "java.lang.NullPointerException" error when working in QuickDesigner, MapsDesigner, etc.

Did you use "back" button in your browser? Please, don't use browser back and forward buttons when working in ERES.

I moved a report with charts/subreports to other machine and the subreports/charts are missing.

Moving components of a report can become cumbersome, we recommend that you create PAK file for the report and simply move the PAK file.

I changed a data source (for example: query) in Organizer, but the changes did not appear in a report that uses this datasource.

The data source in the report is not linked with the data source in the data registry. You can either modify the data source in the report, or use the update option described here
Please note that there are certain requirements before you can use the update option.

I have modified some configuration files/options in Admin Console, but the ERES is still using the old settings.

Please restart the ERES Server. In order to shut the ERES Server down, you need to be logged in as an administrator.

I made a report/chart/dashboard, saved it, but forgot to insert it into organizer. Where do I find the file and how do I save it into Organizer?

Files are saved into the ReportFiles/ChartFiles/DashboardFiles directory by default. You can open the Organizer, click "Insert new file to current folder" button and insert the file.

How do I set-up a JDBC connection to my database?

Below are a collection of URL and Driver for common database connection and drivers.

Excel export isn't working in API

Add correct version of POI library to your classpath, it can be found under <ERESInstall>/WEB-INF/lib/.

Which JAR files do I have to add to my classpath if I want to work with the API?

Add at least ERESOrganizer.jar, ERESServer.jar and qblicence.jar. You might also need to add certain 3rd party jars like poi-30.jar (for Excel export), axercesImpl.jar and xml-apis.jar (for working with XML), FlashExport.jar (exporting to Flash), ExportLib.jar (PNG and other image formats), and database drivers (depend on the database you will be using).

I exported some reports via API, but there is "evaluation copy..." message in the reports

If you are running an evaluation copy, please contact our sales office (sales@quadbase.com) to get a release license key. Otherwise, make sure that you have added the correct qblicence.jar file into your classpath.

Does the ERES Server need to be running if I want to generate reports via ERES API?

It's up to you. Your application can be fully independent, or you can connect to the ERES Server. Pros and cons of both approaches are described in manual, section 7.1.3 - Interaction with ERES server.

I don't know how to start, are there some working API examples with source code available?

Yes, after starting the ERES server, click on the Quick Start API Examples link on the front page. There are some examples in the User's Guide and in the ERES installation directory.