[Label format for pie chart]

I can't change my label format for a Pie chart?

Everytime  fill in something, it's just blank after saving?

[User Attributes - use in Query]

I added some attributes to users. Now I want to use the attributes in my SQL query for a report. How can I do that? It's notworking for me?

Can someone give me an example?

[Null 'key' argument - Charts]

Screenshot from my chart wizard:

This is my report:

 

 

[Null 'key' argument - Charts]

My reports is working. But at the moment I add a chart.. I always receive following error:

Null 'key' argument

This is since I upgraded frop iReport to Jaspersoft Studio!

full error message:

java.lang.IllegalArgumentException: Null 'key' argument.

at org.jfree.data.DefaultKeyedValues.setValue(DefaultKeyedValues.java:229)

at org.jfree.data.DefaultKeyedValues2D.setValue(DefaultKeyedValues2D.java:337)

at org.jfree.data.DefaultKeyedValues2D.addValue(DefaultKeyedValues2D.java:303)

at org.jfree.data.category.DefaultCategoryDataset.addValue(DefaultCategoryDataset.java:222)

at net.sf.jasperreports.charts.fill.JRFillCategoryDataset.customIncrement(JRFillCategoryDataset.java:143)

at net.sf.jasperreports.engine.fill.JRFillElementDataset.increment(JRFillElementDataset.java:191)

at net.sf.jasperreports.engine.fill.JRCalculator.calculateVariables(JRCalculator.java:183)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillDetail(JRVerticalFiller.java:740)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:263)

at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:123)

at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:539)

at net.sf.jasperreports.engine.fill.JRFiller.fill(JRFiller.java:153)

at net.sf.jasperreports.engine.JasperFillManager.fill(JasperFillManager.java:474)

at com.jaspersoft.studio.utils.ExpressionUtil.initBuiltInParameters(ExpressionUtil.java:339)

at com.jaspersoft.studio.editor.preview.view.control.ReportControler$5.run(ReportControler.java:330)

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

 

[Change height of multi-select parameter control]

There is somewhere in the code a parameter you can change I guess?? Otherwise it's not possible to display a control? A control have width and height... (I guess?)

 

[Change height of multi-select parameter control]

I am working with jasperserver 5.6.0.

I want to change the default height of the multi select parameter. Is that possible?

[Login with Locale parameter 'French' - Inputcontrols invisible and can't logout]

When I login with a user and change the 'Locale' Parameter (under the passwordfield), I can't see the inputcontrols of my reports. Also when I click on logout, nothing happens..

When I change the locale parameter to english, everything works... So nobody in the french department of the company can execute a report, except when they change the locale parameter everytime they login..

This problem occured since I upgraded to the newest community version..

[jaspersoft studio https connection]

I tried some things. Now I don't receive an error about my certificate. But I have following error (after import certificate into keystore). I refresh my connection and I receive following error:

 

org.apache.http.client.HttpResponseException: Not Found

 

 

at com.jaspersoft.studio.server.protocol.restv2.RESTv2ExceptionHandler.handleException(RESTv2ExceptionHandler.java:65)

 

at com.jaspersoft.studio.server.protocol.restv2.ARestV2ConnectionJersey.toObj(ARestV2ConnectionJersey.java:35)

 

at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.getServerInfo(RestV2ConnectionJersey.java:108)

 

at com.jaspersoft.studio.server.protocol.restv2.RestV2ConnectionJersey.connect(RestV2ConnectionJersey.java:99)

 

at com.jaspersoft.studio.server.protocol.ProxyConnection.connect(ProxyConnection.java:61)

 

at com.jaspersoft.studio.server.WSClientHelper.connect(WSClientHelper.java:70)

 

at com.jaspersoft.studio.server.WSClientHelper.connectGetData(WSClientHelper.java:96)

 

at com.jaspersoft.studio.server.action.server.EditServerAction$1.run(EditServerAction.java:95)

 

at org.eclipse.core.internal.jobs.Worker.run(Worker.java:54)

 

 

[jaspersoft studio https connection]

I now used the keytool from windows. Executed the same command as in my linux server:

keytool -importkeystore -srckeystore keystore.pkcs12 -srcstoretype PKCS12

-destkeystore keystore-name

 

But what now? I copied the keystore to finalfeaturesjre.win32.win32.x86_64.feature_1.7.0.u25jrelibsecurity

 

I don't know what to do.. Still the same error

[jaspersoft studio https connection]

I want to add a new server to my studio. I always receive following error:

PKIX path building failed:... unable to find valid certification path to requested target

I know following link:

http://community.jaspersoft.com/wiki/using-ssl-certificate-jaspersoft-studio-55

 

But I don't know how that works? I copied the keystore from my ubuntu server in windows.. But that doesn't work.. Can someone help me?

[Default Value 'All' for multi select parameter]

How can I set the default value = ALL for a multi select query parameter?

I have a collectionparamter in my IREPORT...

[single select list of values parameter]

I created a single select list of value parameter in my JASPERSERVER (that is ok)

Now I want to integrate that parameter in my query in IREPORT.. But there I can't add such a parameter? How can I integrate such a parameter in IREPORT (query)

 

Someone can help me and make that clear?

[Jasperserver / ireport and Delphi]

Is it possible to open a report in a Delphi application?

Maybe connect with the Delphi application to the jasperserver, or to load a .jrxml or .jasper file?

 

[execute report - loading]

Every time when I login and run a report, there is always the loading screen... I can wait for 5,10,20,30 minutes, it is always loading.. When I refresh the page and do it again, the report is executed in 1 second...

 

 

[Read out parameter from a stored procedure]

I have a mysql stored procedure:

CREATE PROCEDURE `vtigercrm`.`tester` (out aantal int(255))
BEGIN
*SQL QUERY*

set @aantal = FOUND_ROWS();
select @aantal as 'Aantal';
END

I call the stored procedure:

call tester(@aantal);

Is it possible to read the out parameter in ireport?

I can't display it at the moment. Is that possbile in ireport, to display the returned result from a stored procedure?

[Java JVM Options - War installation]

I succesfully installed the WAR installation for Jasperserver.

But now there is one line in the manual that I don't understand:

 

Set Java JVM Options, as described in 6.2, “Setting JVM Options for Application Servers,” on page 43. This step is

required.

 

I tried it, but I don't know how to do it.. Can someone explain me which lines I have to add..

I have tomcat6 installed and java-6-openjdk on a Ubuntu 10.04 server

[Installation jasperserver - Existing Tomcat problem]

ok thanks,

But maybe I don't have to install the war distribution, because the only reason i should do that is because I have following problem:

 

http://community.jaspersoft.com/questions/817167/make-jasperserver-default-webapp-tomcat

 

Do you know how I can do that?

 

[Installation jasperserver - Existing Tomcat problem]

I installed tomcat6 on my Ubuntu server

apt-get install tomcat6

Now I want to install jasperserver - I choose with an existing tomcat 

I have to insert the tomcat location..

i tried /etc/tomcat6

/usr/share/tomcat6

everytime I receive an error: The directory you selected does not seem to be a valid Tomcat directory...

What is the location then??

[Make jasperserver default webapp (tomcat)]

I installed jasperserver (default installation) with bundled tomcat

 

Now I want to make my jasperserver application my default application.

 

When I go now to http://address:8080/ --> I see tomcat page

I want to go to jasperserver

How can I do that?

[Relative Dates - Parameter MONTH, YEAR]

How can I open that example in ireport?

[Relative Dates - Parameter MONTH, YEAR]

new net.sf.jasperreports.types.date.DateRangeBuilder("MONTH-1").toDateRange()

Can I insert a parameter instead of a hardcoded MONTH -1?

I tried with a string parameter:

new net.sf.jasperreports.types.date.DateRangeBuilder($P{parameter1}).toDateRange()

But that doesn't work..

 

[Selectionlist parameter]

How can I display a combobox / Dropdownlist / ... to give the user the choice between year, month, last week, last year..

Is that parameter type available?

 

 

[Firebird JDBC Driver]

Problem was solved:

Added the database like I said in previous post.

Then I created a new datasource/database --> netbeans database JDBC connection

Everything works now!

[Firebird JDBC Driver]

I added in the screen Services - Databases - Drivers a new driver (Firebird)

Then I selected Connect using ...

Now I have the JDBC Firebird SQL connection to my Database. I see all my tables.

But the problem is when I want to add a new datasource, I can't select the firebird driver... I copied to the folder you said, still no luck..

I can't use my Database in services tab, when I create a report.. 

[Firebird JDBC Driver]

Can someone explain me how to add the firebird JDBC Driver.. 

I added in the classpath + Services - Databases - Drivers

 

But I can't select the driver in the New Connection / Datasource screen...