[Opening file content resource (Excel) of JasperReports Server / Tomcat with Internet Explorer displays binary data inline]

same with 5.6.0 :-(

[Opening file content resource (Excel) of JasperReports Server / Tomcat with Internet Explorer displays binary data inline]

see comment under question above ... this answer should just trigger possible subscribers if the comment above does not and sadly I can't retag it to v5.5.0

[Opening file content resource (Excel) of JasperReports Server / Tomcat with Internet Explorer displays binary data inline]

it also does not work with the latest community edition v5.5.0 :-( we'll try with 5.6.0 as well

more details in the original posting

(sadly I can't edit my post above to add the info: on a save with the right capcha it says "your submission triggered the spam filter")

[Opening file content resource (Excel) of JasperReports Server / Tomcat with Internet Explorer displays binary data inline]

• Content-Type / Accept / MIME HTTP headers issue?
• JasperReports Server (5.2.0)
• running on Tomcat 7
• clients tried
  • Internet Explorer (9.0.8112.16421 64bit (default below) and 11.0.9600.17105 64bit)
  • Firefox 28.0
  • Chrome (34.0.1847.131 m)

If I navigate in the JasperReports Server Web GUI to my previously uploaded Inhaltsresource (content resource), a *.xlsx Excel document, it works well in Firefox and Chrome, by offering to save or open the file, but it fails in Internet Explorer, by displaying the files binary content in the tab :-(

I did quite some research, but could not find a definitive cause, although some points may point at the cause:

see more details in my original posting (preferably answering there, but I'll update findings in here as well)

[aggregate functions (count, sum, ...) broken (Jaspersoft Studio 5.5.0.final and 5.5.1.final)?]

removed the original comment since it would be confusing now that this has been clarified in the accepted answer above

(thanks anyways for one partial problem you mentioned!)

[aggregate functions (count, sum, ...) broken (Jaspersoft Studio 5.5.0.final and 5.5.1.final)?]

removed the original comment since it would be confusing now that this has been clarified in the accepted answer above

[aggregate functions (count, sum, ...) broken (Jaspersoft Studio 5.5.0.final and 5.5.1.final)?]

various solutions and obstacles can be found here: http://stackoverflow.com/q/22080406/1915920

[aggregate functions (count, sum, ...) broken (Jaspersoft Studio 5.5.0.final and 5.5.1.final)?]

also added the result.html (little broken that's why also result.jpg added) to easily see what it outputs for me

[aggregate functions (count, sum, ...) broken (Jaspersoft Studio 5.5.0.final and 5.5.1.final)?]

added test-report-ext.jrxml where I added some more aggregate fields, arranged it more userfriendly and color-marked corrent/incorrect values.

green - correct (sql-generated) aggregated data

blue - COUNT(ID) in the Summary Band is the only one that seems correct (in the Header Band its incorrect)

red - wrong (Jasper-generated) aggregated data

[aggregate functions (count, sum, ...) broken (Jaspersoft Studio 5.5.0.final and 5.5.1.final)?]

also posted the question here and will keep both up-to-date on important findings: http://stackoverflow.com/questions/22080406/aggregate-functions-count-sum-broken-jaspersoft-studio-5-5-0-final-and

[aggregate functions (count, sum, ...) broken (Jaspersoft Studio 5.5.0.final and 5.5.1.final)?]

All I actually like to have is a DISTINCT COUNT on a String column field, but it seems to me that all the aggregate functions behave as if they are simulating the "FIRST" functionality.

I can't believe this is broken and it seems more likely I am missing something very strange here.

(I am quite experienced already with JasperReports and worked with BIRT and other reporting frameworks before as well.)

Looking at the docs I can't see where the problem should be: http://www.jasperassistant.com/docs/guide/ch06s08.html

Finally I created the attached simple sample report based on the sample db and updated to the latest 5.5.1.final release without any progress.

Please anybody tell me the secrets I am missing or to my big surprise assure it's a bug indeed http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/cry_smile.gif

Thx

Andreas http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/regular_smile.gif

as you can see in the report there is just some page header and summary bands, containing the product id/name/cost labels, the name count, cost count, cost sum and all variations of name count increment types (report/column/page/none). the summary band holds the cost sum. the detail band contains just the details.

But none of the aggregate functions shows aggregated data, but only the first(xxx) result it seems. (so strange anyways that the count(name) shows the first rows name instead of a number :-( ).

http://community-static.jaspersoft.com/sites/default/files/questions/test-report-ext-result.jpg

[Combined Crosstabs]

see also possiblity and details how to do it here: http://stackoverflow.com/a/20141363/1915920

[SEMI SOLVED: Crosstab sorting]

see my post here for various rather good solutions: http://stackoverflow.com/questions/8172301/crosstab-sorting-in-jasperreports/21632977#21632977

[security error trying to reuse an input control]

same here :-( ... I ...

• set up a datasource (works since imported from Studio, in this case pointing to the JR metadata db itself)
• referenced by a set up query
• referenced by some set up control element
• to-be-referenced by some report as a selectable parameter, but crashes with the above error

[net.sf.jasperreports.engine.JRException: Unable to get next record]

see here for details about the path magic depending on where your report runs (designer, webapp, ...): http://stackoverflow.com/a/20374515/1915920

[atomatically compile subreports]

general solution/background regarding the path handling and compilation: http://stackoverflow.com/questions/4364205/jasperserver-unable-to-locate-the-subreport-exception/20374515#20374515

[Subreport Problem]

more general solution to this: http://stackoverflow.com/a/20374515/1915920

[RESOLVED: Problem with subreport reference after exporting from iReport to JasperServer]

general more robust solution can be found here: http://stackoverflow.com/a/20374515/1915920

[SOLVED: Subreport is not running on JasperServer]

a general solution to this is described here: http://stackoverflow.com/a/20374515/1915920

["com.jaspersoft.jasperserver.api.JSException: Error filling report" and "net.sf.jasperreports.engine.JRException: Resource not found"]

general solution to this is described here: http://stackoverflow.com/a/20374515/1915920

[DATABASE_TIMEZONE]

title and query are unrelated, but a general solution to the query is described here: http://stackoverflow.com/questions/4364205/jasperserver-unable-to-locate-the-subreport-exception/20374515#20374515

[unable to compile master report - pls advise]

general solution to this: http://stackoverflow.com/a/20374515/1915920

[Sub Report ".jrxml"/ ".jasper"]

general solutions for this: http://stackoverflow.com/a/20374515/1915920

[Subreports in iReports]

more details on this subject can be found here: http://stackoverflow.com/a/20374515/1915920

[Subreport: Could not load object from location]

all the solutions above are not working or clearly defining what to do in using designer preview and server functionality: see here for details how to solve it: http://stackoverflow.com/a/20374515/1915920