[Subreports / Pagination]

I'm using iReport 3.5.2.

I have a report that has a few sub reports.

What is the best way to have each sub report begin on a new page?

 

 

 

Rod MacNeil

 

[Hyperlink to RemotePage]

I'm using iReports 3.5.2.

I am trying to create a hyperlink to page 2 of another pdf file.

When I try to compile my report I'm getting the error "Class class java.lang.String not supported for hyperlink page expression. Use java.lang.Integer instead"

The problem is, I am using Integer, my page expression is      new Integer(2)

Why does it think I'm trying to use a string?

 

Rod MacNeil

 

[Hyperlink to Non-Jasper PDF]

I'm using iReport 3.5.2.

I can get hyperlinks to work fine between pdf's created by Jasper.

But when I link to a bookmark in a pdf created by something else it always opens the target pdf at the top.

I've confirmed that the target pdf is version 1.4 same as iReports produces.

Has anyone been able to get that to work?

 

Rod MacNeil

[Adding New JDBC Driver]

I had to add the driver in the services window.

 

Rod MacNeil

[Adding New JDBC Driver]

In iReport 3.0.0 I placed my sqlite JDBC driver jar file in the lib folder and it then appeared in the driver list in the data connection dialog.

 

How do I install that driver in version 3.5.2, I have tried placing it in various locations, I have also tried listing the jar file explicitly on the classpath but so far it never shows up as an avaiable driver?

 

Rod MacNeil

 

[Samples Error]

Trying JasperReports for the first time. (3.5.2)

Following the getting started doc.

When I try to compile the sample reports I always get this error:

java.lang.NoClassDefFoundError: org.springframework.core.CollectionsFactory

Is anyone else having problems getting the samples to work?

 

Rod MacNeil

 

 

[Access to MySQL]

I've installed JasperServer 3.0 with bundled tomcat and bundled mysql.

What login and password can I use to access the mysql database using the mysql console program?

 

Rod MacNeil

 

[Bad Credentials]

It is a brand new install.

I uninstalled 3.1 and installed 3.0 and those creds (jasperadmin/jasperadmin) worked in 3.0.

I uninstalled 3.0 and re-installed 3.1 and jasperadmin/jasperadmin  does not work.

 

[Bad Credentials]

None of these work :(

 

jasperadmin/jasperadmin

JasperAdmin/JasperAdmin

jasperadmin/password

jasperadmin/Password

 

[Bad Credentials]

Trying to login as jasperadmin/jasperadmin to a fresh install (binary installer) of 3.1 gives me a 'bad credentials error.

Anyone know why?

[Manual Chart Series Error]

I'm trying to create a chart series manually using .addValueToSerie() and I'm getting this exception:

 

JRDefaultScriptlet cannot be cast to it.businesslogic.ireport.IReportScriptlet

 

Does anyone know whats causing this error?

 

Rod

[Custom Logo Per User]

I would like to customize the JasperIntelligence application so that the logos that appear at the top of the pages are different for different users or different roles. Is there a way to do this? Is it also possible to set the color scheme by user or role?

 

Thanks for any suggestions.

 

Rod

[How to use PostgreSQL]

Sorry, I think I got that wrong.

Try org.postgresql.Driver

 

Rod

[Creating a Dashboard]

I'd like to create a dashboard-like report to show several key business indicators on a page using several charts.

 

Is there a tutorial around on how to do that?

Would I create each of the charts as a subreport?

 

Thanks For Your Help

Rod MacNeil

[How to use PostgreSQL]

I think the JDBC Driver should be: postgresql.org.Driver

 

Rod

[postgresql data source]

Thanks I got it working.

 

Rod

[postgresql data source]

I am trying to setup a postgres data source for jasper server 1.2.

I downloaded a postgres JDBC driver from sun called postgresql-8.1-408.jdbc3.jar (I'm using postgres 8.1.2).

 

I've installed jasperserver in /opt/jasperserver-1.2

 

Where do I put the jar file and what are the correct data source parameters for Driver: and URL:

 

There's a mysql data source with Driver: com.mysql.jdbc.Driver

But the file name of the driver file is ./apache-tomcat/common/lib/mysql-connector-java-3.1.12-bin.jar

How does the file name relate to the driver file name.

 

Did I mention I know little about java?

 

TIA

 

Rod

[mysql startup error]

I have installed Jasper Intelligence 1.0.1 using the Linux installer on to a fedora core 3 server with the bundled tomcat and mysql.

 

The installation instructions say to start mysql like this:

 

/opt/jasperintelligence-1.0.1/mysql/bin/mysqld_sale start

 

This doesn't start the mysql server and i get an error file in the ./mysql/data directory that reads:

 

060928 10:30:04 mysqld started

/opt/jasperintelligence-1.0.1/mysql/bin/mysqld: Too many arguments (first extra is 'start').

Use --help to get a list of available options

060928 10:30:05 mysqld ended

 

This is probably a simple problem but I'm not familiar with mysql.

 

How should mysql be started for Jasper?

 

Also, which database engine does Jasper use for the repository?

 

Thanks in Advance for your help.

 

Rod