[How to setup background color for subreports in Jaspersoft Studio]

Hi, the background in the subreport will be set in the subreport itself, and not inside the parent report as a property. Make sure you also activate OPAQUE checkbox property.

 

[Print When Expression. Sum() of group > 0]

Hi Javier,

you should set evaluatoin time for the content(Service:Transportation Text Field) to Group and apply print when experssion to those Text Fields.  I that case, if you would have some non-empty content, it should be displayed. But when it's empty, some space will be reserver.

Alternatively, you can create Subreport for that group header, and then size it to 0 in any condition in the parent report as well as the Group Header band height. It will stretch to the content when necessary.

Hope it helps,

Olga

[Not able to select/create a new report in iReport Designer 5.0.4]

it looks like your class and lib folders were not resolved correctly. Sincerely would suggest to unistall iReport completely, and install again. At least you have a valid JRE as you mentioned.

Good luck,

Olga

[preview OK but excel export fails]

Hi Eric,

a copy/screenshot with some dummy data would be extremely helpful to understand what mis-behavior you are talking about.

Kind regards,

Olga

[parameter problem jasper]

Hi Ironhide,

I assume you are trying to call  your report 3 times, passing different values for parameters id and id1. In that case, how do you declare parameters in your report - is it Integer type or String? How do you use parameters in your report - are they filters for your query? Do you have default values configured for your parameters?

If you need to pass several couples of parameters, you should use Collection java type, then you can have array of Id and Id1. Again, how's your implementation of the logic of those parameters?

Thanks and regards,

Olga

[iReport 5.0.1 - cannot run sample database (test.script.new not found)]

Hi,

Works fine for me under Windows64.

under which OS are you running iReport? Check the same folder for iReport-Professional-5.0.0demohsqldb and try to execute manually runServer.bat from CMD frame.

Regards,

Olga

[Exception while trying to generate a report with parameters]

Hi Amit, could you possibly open another case and attach the logs? Unfortunately this site is not very friendly for large content.

You can try to clear AdHoc cache - login as superuser, open Manage Server and clear cache from there.

As it's a commercial release, you either can use support@jaspersoft.com or sales@jaspersoft.com for your evaluation. Please contact appropriate, so you have dedicated people looking into this.

Regards,

Olga

[Problems on ireport with Characters In Japanese]

Hi Rafael,

definitely Helvetica font doesn't support Unicodes, but SansSerif is working fine for me in your report - it's system font and in my Wondows I have Japanese fonts. Are you able to use Japanese fonts properly in other applications?

Definitely annoying issue..

Olga

[Difference in the data when deploying the report on Jasper Server]

Hi Kumar,

unfortunately it's impossible without seeing your template and your data. Check with the guys who developed your report.

Olga

[Adding filter in adhoc report created from domain throws error]

Hi Nikita,

I tried the same in v5.0, seems no problem to select empty TEXT field as filter. Since you are playing with AdHocs, assume it's Professional edition, you can contact support or sales, guys will be able to help you. Attaching screenshot will be helpful also.

Enjoy AdHoc filters!

Olga

[Are Dashboards available in the Community Edition?]

Dashboards are only part of Professional and Enterprise Editions. Please check here: https://www.jaspersoft.com/editions

Happy dashboarding!

[How can i change an Ireport in fishbowl to add an item picture?]

Hi CZ,

Add image and fill the image expression with something like "c:image"+$F{product_name}

Don't forget to use IfError propery to put empty space or dummy image, otherwise if you product misses a picture, the complete report will be in error.

Happy Images! Olga

[SqlServer 2012]

Thanks Gil for update, happy it's solved!

[Matrix / table 2 dimensions]

Hi Waczek,

Please use Crosstab object. The wizard will allow you up to 2 attributes for columns and rows, so you can have something like

Rank*Person on Columns and

Country* Workplace on Rows.

Then you can add more levels Columns and Rows in the Report Inspector for your crossTab object, so you can make

Country* State*City*Workplace on Rows etc.

Happy reporting,

Olga

[Installation error on Win 7 64bit]

Nik, could you please attach complete log? Thanks..

[SqlServer 2012]

I understand this error comes from JasperReports Server? Is your iReport working fine?

First check all the user rights to access your DB.

 

[Error in Jaspersoft Studio connecting to JasperReports Server]

Studio would probably support Jaspersoft 4.7.1 onwards.

[Installation error on Win 7 64bit]

Hi Nik,

do you see something like this at the bottom? Looks like you don't have sufficient rights to create a new Database in Postgres. Please provide Read/Write right to the Data folder of Postgres.

/opt/jasperreports-server-4.7/buildomatic/bin/validation.xml:428: The followingerror occurred while executing this line:/opt/jasperreports-server-4.7/buildomatic/bin/validation.xml:464: Databasedoesn't exist. Treating problem with JDBC connection as unrecoverableTotal time: 1 second[/code]

Happy install,

Olga

[Pro Charts won't display/print]

Hi Sunny,

Flash chart appear only in PDF or HTML. No Word.

Maybe you can check Jaspersoft  Support since you are using Professional edition? Did you try HTML5 charts output? It's more stable than charts pro.

Happy charting,

Olga

[Title and text split problem!]

Try to use frames - set minimum height for frame, say 3rd of a page, so it will never break on smaller leftovers.

[Can we use XML as data source in ad hoc editor?]

Hi Shrestha,

1. There's internal example for XML and WebServices, I send you personal link. No support for samples.

2. Once XML source is there, you can try to setup Virtual DataSource to encompass XML/WebService but no guarantee at this point.

Regards,

Olga

[Trying to export data from DataSource to Excel, created jrxml using iReport Designer tool. Getting "java.lang.OutOfMemoryError: Java heap space" error with huge amout of data. Suggestions please.]

Hi There,

Is it problem only when you export to Excel or when you run the report also?

Do you have any calculation expressions? Try set -Xms1024m and -Xmx4096m if you have sufficient memory or just max out.

[Generating bar charts when using list bands]

Hi Meghrach, do you mind attaching your sample file?

[Multi Axis Chart with only one y-Axis]

Hi Rmjrao,

you can set Axis position to "Left Top" or "Bottom Right", but there's no option to hide it. Use colors for TickMarks and Values matching the Background for the effect of hiding.

Happy charting,

Olga

[Domain reports preview in IReport Designer?]

You can use Run Report from the Repository Navigator of iReport. That means you have to upload the report to the server, but you don't need to change GUI.

Happy Domain reporting!