Quadbase / Support/Services / FAQs / EspressReport ES Tech Support FAQ

Quadbase

EspressReport ES Tech Support FAQ

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.
  6. How to move a licensed ERES from one machine to another?

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?
  8. What should I do if I failed to register license in the ERES installation?

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. A Data Registry issue with Java8.
  8. I moved a dashboard to other location and it isn't working properly.
  9. 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.
  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?
  19. How to do single sign-on? How to embed reports, dashboards in custom web pages?

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

PAC - ChartDesigner chart package (with data, background images etc.)
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

GPAK - Google map package

SPAK - SVG map package

DPAK - Dashboard package

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.

How to move a licensed ERES from one machine to another?

If you want to move a licensed ERES from one machine to another, you may re-use the same license key by the following procedure, as an example.
(1) On Windows machine that has installed the licensed version, go to <ERES installed directory>\UninstallerData\Uninstall_ERES.exe and run it by double clicking from Windows Explorer
Or you may use the Windows shortcut, Start /All Programs / ERES /Uninstall ERES
(2) Move InstallERES66.exe to another machine and use the same license key again.
(3) The above procedure also works on non-Windows machine where you should use a Command Prompt and run the corresponding file in the UninstallerData directory.

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.

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+), Safari 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 /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://: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

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 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.

What should I do if I failed to register license in the ERES installation?
In ERES installation, if you failed to register license, you can go to http://www.quadbase.com/license-registration-1/ to get a new qblicense.jar, remove each original qblicense.jar in <ERES>/lib/ and <ERES>/WEB-INF/lib/ and copy the new jar file into these two directories.

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 /lib/ and /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 /lib/ and /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.

Export from browser (Menu Page, Dashboard, generated URL) is done on the server side. Export from Report Designer is done on the client side. So if you export large report from Report Designer, you should also increase the memory on the client. But server side is still used for getting the data, so server side memory should be increased as well. You can quite easily recognize, where you have insufficient memory. If the OutOfMemory error is reported in the Tomcat log, it is a server side memory. If it is in the Java Console, it is client side memory. Therefore,
if the errors happen in the server:
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% -Xmx512M
Increase the 512 to a larger number. ERES also provides virtual memory and paging options to reduce memory usage for large reports. Please see the user guide.
if the error happens in the client:
On Windows 7 or 8, increase client side java memory by double clicking the java lcon from control panel / Programs, select the ‘Java’ tab and click ‘view…’ button, ‘Java Runtime Environment Settings’ window pops up, under ‘user’ tab, double click on the ‘Runtime Parameters’ and add, for example, “-Xmx512M” (Set Java maximum heap size to 512 MB).

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.

A Data Registry issue with Java8.

Java8 has stopped supporting jdbc-odbc bridge connection. The ODBC Datasource connection in DataRegistry is still working with lower versions of java such as Java7 but not Java8. Available workaround must be used for ODBC connection to Access database if Java8 were used.

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

Use the "Dashboard and Map" Packages  feature described here (navigate to section 2.1.4.4). It allows you to pack all files that are connected with the dashboard into a single file which can be easily moved elsewhere.

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

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 to do single sign-on? How to embed reports, dashboards in custom web pages?

It’s a common practice for users to integrate ERES into an existing application. This implementation requires single sign-on and to embed reports, charts, dashboards in custom web pages.
Integrate Users/Groups/Relationships into ERES
To do single sign-on, first, users need to integrate their existing users, groups, and relationships into ERES system. The details can be found in Section 8.2 - Integrating Existing Users and Groups
If existing user information are stored in LDAP, please find details in Section 1.4.1.4 - LDAP Settings.
Extension class UserSecurityProvider provides a flexible way to retrieve/implement users and groups from any source, please find details in Section 8.2.2 - Implementing UserSeurityProvider
Pass login information into ERES to load Chart/Report/Dashboard
After users login their application, and then click ERES links, the login information can be passed to ERES internally, so users don’t have to login one more time for ERES.

Single Sign-On details and example are in Section 7.3.3 - Single Sign-On
User login information can also be included in a URL of a chart image, a report, or a dashboard. It’s straightforward to generate a URL from ERES Organizer. To do so, select a chart, report, or dashboard, right click to find Generate URL in popup menu, make sure to check “For Current User” option. The menu details is in Section 2.1.2.1.3 - Publish Menu
URL Examples
The values of USERNAME and PASS can be encrypted or not.
Chart
http://ServerName:8080/ERES/servlet/LookupServlet?USERNAME=qEJAY5c24h&PASS=qEJAY5c24h&URLTYPE=FORCHART&ChartPathEN=http%3A%2F%2FServerName%3A8080%2FERES%2Fhelp%2Fexamples%2Fdashboard2%2FAlerts+Dashboard%2F*m-47-46-32-4bmx-53-3b-51O-50zxsT-46mL-4ey-48M-56aa2eg&DisplayType=JPG&ExportMethod=B&JPEGQuality=99
Report
http://ServerName:8080/ERES/servlet/LookupServlet?USERNAME=qEJAY5c24h&PASS=qEJAY5c24h&URLTYPE=FORREPORT&TemplatePathEN=http%3A%2F%2FServerName%3A8080%2FERES%2Fhelp%2Fexamples%2Fdashboard2%2F*-06JIoN-74xEtOw-58-1ar-59-07P-02-1eL-12Q-20Qd32fh&ExportFormat=DHTML&OptimizeMemory=false&MultiPageExport=false&QueryParamName=category&QueryParamSize=1&QueryParamValue=Arm Chairs
Dashboard
http://ServerName:8080/ERES/Dashboard/Dashboard.jsp?OpenFile=http%3A%2F%2F ServerName%3A8080%2FERES%2Fhelp%2Fexamples%2Fdashboard2%2FCampaigns.dsb&USERNAME=qEJAY5c24h&PASS=qEJAY5c24h&USESESSION=FALSE
Embed Report/Dashboard using iframe
Report/Dashboard can be included in web pages using iframe, for example:
<html>
<body>
<iframe src="http://ServerName:8080/ERES/Dashboard/Dashboard.jsp?OpenFile=http%3A%2F%2FServerName%3A8080%2FERES%2Fhelp%2Fexamples%2Fdashboard2%2FCampaigns.dsb&USERNAME=qEJAY5c24h&PASS=qEJAY5c24h&USESESSION=FALSE" width=100% height=100%>
  <p>Your browser does not support iframes.</p>
</iframe>
</body>
</html>

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.

Hsql (Hypersonic sql) database server (EspressReport example database datasource)
Hsql JDBC Driver (in-process or standalone mode)
jdbc classes: hsqldb.jar under $espressreport_install_dir$/help/examples/DataSources/database/hsqldb.jar
database url (relative path): hsqldb:help/examples/DataSources/database/woodview
database url (absolute path | windows): hsqldb:C:/espress-report/help/examples/DataSources/database/woodview
database url (absolute path | unix): hsqldb:/usr/espress-report/help/examples/DataSources/database/woodview
jdbc driver: org.hsqldb.jdbcDriver

Hsql JDBC Driver (server mode)
jdbc classes: hsqldb.jar under $espressreport_install_dir$/help/examples/DataSources/database/hsqldb.jar
database url (1 db on 1 machine): jdbc:hsqldb:hsql://machineName
database url (> 1 db on 1 machine): jdbc:hsqldb:hsql://machineName:port
jdbc driver: org.hsqldb.jdbcDriver

documentation: frame | no frame

 

IBM's DB2 v8
JDBC Type 2 driver implementation: the legacy/CLI JDBC driver
jdbc driver: COM.ibm.db2.jdbc.net.DB2Driver | COM.ibm.db2.jdbc.app.DB2Driver
jdbc classes: db2java.zip
database url: jdbc:db2://machine/database | jdbc:db2:database
download: Find it in $(db2-install)/java/db2java.zip

Universal JDBC driver
jdbc driver: com.ibm.db2.jcc.DB2Driver
jdbc classes: db2jcc.jar, jd2jcc_license_cu.jar (license)
database url: jdbc:db2://host:port/database (ex. jdbc:db2://server1:50000/phonedb)
download: http://www.ibm.com or find it in $(db2-install)/java/db2jcc.jar and jd2jcc_license_cu.jar

 

MS SQL Server 2000
JDBC Drivers from Microsoft
jdbc classes: msbase.jar, mssqlserver.jar, msutil.jar
database url: jdbc:microsoft:sqlserver://host:port
jdbc driver: com.microsoft.jdbc.sqlserver.SQLServerDriver

JSQLConnect from JDBC Drivers from Microsoft
jdbc classes: msbase.jar, mssqlserver.jar, msutil.jar
database url: jdbc:microsoft:sqlserver://host:port
jdbc driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
download: Net Direct

 

MS SQL Server 2005
JDBC Driver from Microsoft
jdbc class: sqljdbc.jar
database url: jdbc:sqlserver://host:port
jdbc driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

Link:
MS SQL Server 2005 JDBC Driver Download
http://msdn.microsoft.com/en-us/data/aa937724.aspx

 

MySql

MySQL Connector/J from MySql (www.mysql.com)
jdbc classes: mysql-connector-java-2.0.14-bin.jar (download from www.mysql.com)
dtabase url: jdbc:mysql://host/database
jdbc driver: com.mysql.jdbc.Driver

 

OpenBase
JDBC Driver from OpenBase
jdbc classes: OpenBaseJDBC.jar (download from www.openbase.com)
dtabase url: jdbc:openbase://host/database
jdbc driver: com.openbase.jdbc.ObDriver

 

Oracle
JDBC Thin Driver
database url: jdbc:oracle:thin:@host:port:sid
jdbc driver: oracle.jdbc.driver.OracleDriver
jdbc classes: ojdbc14.jar (download from www.oracle.com)

OCI Driver
database url: jdbc:oracle:oci8:@{your-tns-name}
jdbc driver : oracle.jdbc.driver.OracleDriver
jdbc classes: ojdbc14.jar (download from www.oracle.com)

Links:
Oracle11g JDBC Developer's Guide and Reference
http://download.oracle.com/docs/cd/E11882_01/appdev.112/e12137/toc.htm

Oracle JDBC Driver download
http://www.oracle.com/technetwork/database/features/jdbc/index-091264.html

 

Sybase
JConn2 driver from Sybase
jdbc classes: jconnect2.jar
database url: jdbc:sybase:Tds:host:port
jdbc driver: com.sybase.jdbc2.SybDriver

 

PostgreSQL
database url: jdbc:postgresql://:/
jdbc driver: org.postgresql.Driver
jdbc classes: postgresql-8.4-701.jdbc4.jar (download from http://jdbc.postgresql.org/download.html)

 

Informix
database url: jdbc:informix-sqli://:/:informixserver=
jdbc driver: com.informix.jdbc.IfxDriver
jdbc classes: ifxjdbc.jar (download from http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxjdbc)

 

Excel export isn't working in API

Add correct version of POI library to your classpath, it can be found under /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.

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.

Sitemap | Contact us | Products | Hosted Services | Gallery | Sales | Support/Services | Company