drummer54

I have to say it is really ridiculous that the subreports have to have the same number of columns and that the columns all have to be the same width to get this to work properly. I've also tried using tables to achieve this and the behavior is the same - if the tables either have a different number of columns or if the column widths differ then you get merged cells that prevent the user from sorting, even though each table, as is the case with the subreports, is being saved to a different worksheet. SSRS can handle this so I don't see where it's a fault of Excel, it's something in JasperReports.

There are no overlapping cells - I learned how to detect that in my first 5 minutes with JS. I don't have repeating column headers - we want one set of column headers at the top so that users can then sort the data. I played around with it some and found that by putting column headers in the title bar I could reduce the gap between pages to a single blank row, so now I need to figure out how to make it easy for users to remove the blank rows before sorting. Again, I can't use 'ignore pagination' because that causes a Java Heap Space error.

So it affects subreports in Excel even if the subreports are saved to different worksheets? What if the data being presented in each report doesn't lend itself to identical column widths? SQL Server Reporting Services doesn't have this problem. Not that I think it's an especially good tool, because it has a lot of faults, but it does handle creation of Excel columns well. The only way I have figured out how to mitigate this effect is to move all of my column headings into the title bar, make a single field with the date/time and place it over a data column that is the same width as the date/time field, and make certain that the report title is the same width as the data column under it. All of this seems to be an unnecessary restriction - again, SSRS handles this quite well. Our standard is that the report title is placed at the top left and the date/time is placed at the top right of the report. If I have a long report title (and we have many that are rather lengthy) or a right most data column that is very narrow (narrower than required by the date/time stamp), it fouls up the cells when exporting to Excel. Or we define cell widths just to accommodate this "bad programming" (vs bad report design) whether it fits the data or not.

Is there a way to remove page breaks when exporting to Excel other than by using the 'Ignore Pagination' property? I have some lengthy reports that our CEO and clients want to be able to export to Excel and to sort to their liking once in Excel (ignoring the problem where JS creates multiple Excel cells in many columns, making sorting problematic, an issue I am still awaiting an answer for). I know that setting 'Ignore Pagination' will remove the page breaks, but these reports are large enough so that setting that propery causes a 'Java heap space' error, so I'm stuck between the proverbial rock and hard place. I can either run the report in a format that our CEO and users likely won't accept when exported to Excel, or just not produce the report. Is there any answer for this?

I have reports that must be included in sets, thus the use of subreports, and that must be exported to Excel so that our CEO and clients can sort the data to their liking. I've been able to mostly remove unwanted cell merging using the net.sf.jasperreports.export.xls.column.width property, but only when exporting the report as the main report. When the report is included as a subreport and exported the numerous unwanted cell merges occur. Is there any way to rectify this? Image of report exported as subreport: Image of report exported as main report, with manageable cell merges:

Just had another similar problem, except this time the text looked normal in edit view but after I hit 'enter' it looked like this in designer: /sites/default/files/images/Screen%20Shot%202014-09-10%20at%2012_18_53%20PM.png Running the report produced a blank page. Closing and reopening Studio fixed it. I hope this is on someone's radar to fix. It's very annoying and impacts productivity.

Ever since the lastest Jaspersoft Studio update to version 5.6.1 I've been seeing the below when editing static text after having the app open for a short time. This used to happen after I had it open for an extended period of time and/or had a lot of reports open. Now it happens within a matter of less than an hour and with only a few reports open. It returns to normal if I close & reopen the app but obviously I shouldn't have to do that. What gives? I'm on a MacBook Pro with OS X 10.9.4.

I have a report that is comprised solely of two subreports in the detail band. The query returns only one record that is used to populate the subreports via parameters. The subreports are comprised of title, detail and page footer bands. I'm using the footer bands to insure that page numbers and user instructions are always printed at the bottom of each page. FYI, each subreport prints only one page each, so I've hard coded the page numbers as '1 of 2' and '2 of 2'. When I run the parent report everything works fine except that the page footers from both reports print on page 1, while only the page footer from the second report prints on page 2. I tried to add a page footer to the main report to resolve this and when I rain it the report statistics began to count pages in the thousands before I killed it. How can I make the page footer for the second subreport print only on page 2 and not on page 1?

I'm on 5.6 now as well and have given up on using the table object. At least the problems I was having with the designer that initially led me to try tables have been resolved so I'm now able to avoid the table object. I have some reports that require the crosstab but have learned how to get around its quirks for the most part.

Thanks. I suspected it was the data, but as it's being generated by a stored procedure for a current production report in SQL Server Reporting Services I'm not at liberty to modify it. I may just pull the SQL out of the stored procedure to embed in the JS report as a temporary solution.

I'm using whatever chart control is included with JSS 5.6 and selecting stacked bar chart as the chart type. I don't see anywhere to add a Measure. The only really extensive chart examples I've located in the documentation and elsewhere on the web are for a pie chart, and I haven't been able to translate that into the kind of bar chart I require. I get all kinds of weird results no matter how I set up. I'm wondering if the series data all needs to be on the same row of data?

Can someone explain to me how to create a stacked bar chart that looks like the attached TIFF file (created with SQL Server Reporting Services) using a dataset like that shown in the attached Excel spreadsheet? In the event that it's not clear, each bar shows the percent of the total represented by the number of items that are late, missing or compliant. There is one bar per category. I'm using JasperSoft Studio 5.6.final. Thanks.

Figured it out. I'm not using page numbers on this report so it took me awhile to think of this solution. Reset the page number variable with each group change and only print the "continued" text if page number != 1. Very simple.

I have a report that includes a group header that is only to be printed at the beginning of the group. If there is enough data in the group to print to a second page the group header is not reprinted. I would like to be able to add text at the top of the second page that basically indicates that the data on this page is a continuation from the previous page. What I have then is printing that is conditioned on whether or not a group header has been printed on the page. Is this possible? I'm using JasperSoft Studio 5.6.0.final. Thanks.

Should this method still work with JasperSoft Studio? I just tried it and every cell in my crosstab ended up with a null value.

I have the same requirement, and it's not a "crazy client request" in our case. We have a number of multi-page forms created for clients off of a single database record. It's quite easy to do in SQL Server Reporting Services but I don't see a way to accomplish it with JasperSoft Studio 5.6. Can someone show me where I'm wrong?

I realize they are in the properties view, but when I first started using JasperSoft Studio several weeks ago they were available above the design window, always accessible rather than having to be on the correct tab of the properties view. It's more inefficient for them not to be in the toolbar. I'm curious what the 'Text Properties' item under Preferences / Jaspersoft Studio / Report Designer / Toolbars is for if not for something like this?

5.6.0.final /sites/default/files/images/Screen%20Shot%202014-06-09%20at%207_20_21%20PM.png

I just realized that some of the toolbar items I became accustomed to are missing - text justification (left/center/right and top/middle/bottom), font size, bold, etc. How do I get these back? Under Preferences / Jaspersoft Studio / Report Designer / Toolbars the only items not checked are Element Order, Exporters Actions and Move Bands.

Sorry if I'm being a pain in the neck with this, but I finally have realized I've been doing this stuff for FAR too long (since 1982, or 1972 if you go back to programming classes I took in college) and have been through so many technology upheavals that my patience is wearing thin! 8-) Thanks for your patience!

Thanks for the feedback. I've created multiple versions of this report as I've tried to replicate our current SSRS report and have moved on to other issues since posting this, so am not exactly sure where I left off. Given the problems I've had with changing crosstab groupings once the original groupings are in place, I'll probably have to start from scratch once again to see if I can get this to work properly.

I didn't realize there was a distinction between JasperReports and JasperSoft Studio. Again, I'm new to both and never used iReport, which I assumed was quite different. Much of the help I've found for iReports features references to things that don't seem to exist in Studio. Anyway...I figured out the problem, and I would consider it a bug, but that's just my take on it. The Reset Type property in Object properties doesn't include 'Group' in the drop down, which is why I was getting running totals in the group footers. I stumbled on 'Group' in the Advanced tab. I rarely used the Advanced properties because when I first starting using JasperSoft Studio I would often set a property in the Advanced tab but the value would immediately revert back to the original value. As you can imagine, that became frustrating so I quit using the Advanced tab.

Having same problem with 5.6....except that I've never used iReport so have no basis for comparison. The instructions on adding a custom Jar to JS Studio are sketchy at best, though maybe it's my lack of familiarity with the product (which honestly I don't like at all) and with Java. I posted a question here but have had 0 responses (8 views) so far, so apparently I'm not the only one who still doesn't know how to do this. This is likely the most frustrating piece of software I've ever used, and I've been forced to use some doozies in my 32 years of working in IT.

I created a Java class and created a jar file, but how do I add it to JasperSoft Studio and use it in an expression? Thanks.

In the attached report, is it possible to merge the cells in the region group footer and in the company group footer? I've tried grouping the 3 columns at various levels (group headers, group footers, detail) but each grouping mangles the report: rows are added that can't be edited, columns are moved from their intended locations, some column headers are moved and can't be realigned with the remaining headers. Worse, the Undo function doesn't generally Undo unintended consequences of these groups, so I have to close the report without saving and reopen. I'm stunned at how bug-ridden the table and crosstab objects are.