myusername01011

I don't remember specifically. However, I had evetually reverted back to the (deprecated) 5.5 standalone desktop verision for possibly this and/or other reasons to include compatiblity with existng application jasper jars.

Any ideas?????? A clue: I changed my ORDER BY Clause back to how I had it previously and now my sheet names are properly Apple and Banana. Obviously, the problem is that one of my current user requirements is that the ORDER BY clause be changed! What the heck does the order by clause have to do with my sheet name????? Is this a bug? (This can't possibly be a feature, right??)

Why are my sheet name settings modified? Instead of my sheet names being set as Apple and Banana for instance, they are being set as Apple 1, Apple 2, Apple 3 ... Apple X. (Same as Bananas.) This was previously working, until I needed to modify my sql (see https://community.jaspersoft.com/questions/1067256/multiple-worksheets-single-excel-workbook-without-detail-splitting for details.)

I'm using Jaspersoft iReport Designer 5.5.0 with separate settings for Schema and User name for my embedded jdbc connected Jasper report. Unless I specify the schema name in from of my tables/views, it ignores my schema name and attempts an errorneous connection using my User name. How can I set things up so that it properly uses the Schema name?

Another clue: My "Column Print When" expression, new Boolean($F{DISTRICT}.toString().contains("Z")). does actually hide the first column in all sheets (both A & B sheets in my case since that's what my data respresents). Although, this is not the desired intent, it does provide some evidence that my table (component) "Column Print When" expression may in fact actually be getting evaluated. Evaluated how is my question? (Of course, there are no Z districts.) Perhaps, this points to "Column Print When" not fully handling and/or it's improper configuration for Excel specifically, despite having set net.sf.jasperreports.export.xls.one.page.per.sheet, seemingly appropriately? Perhaps, this may point to a bug/error in Jasper Excel (handling)? Any tips?

By the way, both A and B sheets have the same columns (details; separated only for statistical reasons), but the first column should be hidden in B since the business data in the first column on a B sheet makes no business sense to my business users (and I'm using a single query to provide all the data in an attempt to keep things as simple as they can be).

Hi, I'm using the table component to render Excel with multiple worksheets within a single Excel workbook with iReport 5.5. Sheets appear as District 1A, District 1B, District 2A, District 2B, District 3A, District 4B, etc ... The District "B"(s) must hide the first column. I don't have it working using new Boolean($F{DISTRICT}.toString().contains("A")) as the "Column Print When" expression to make the first column of a District XB hide. District XA or District XB are both in the table (component) details and also grouping by district (with District XA or District XB group names) allows me to alternate the sheets as outlined aboce. Please advise. (I'm beginning to suspect that perhaps the "Column Print When" expression may not be timed for evaluation properly and/or perhaps there is a "Column Export When" (or property) for Excel that I should be using for Excel sheets?) If needed, please see Multiple worksheets for a single Excel workbook for existing code.

Answering my own queston here: pageHeight="20000" (increasing the page height worked [without this, some worksheets/tabs had only 5 items, other worksheets/tabs had 35 ... there didn't seem to be a logical explanation to me before this pageHeight change)

Hi,I'm using (Luna Eclipse and) TIBCO Jaspersoft® Studio - Visual Designer for JasperReports: . JasperReports Library and Tools 6.4.0.final (without the server) with all the latest updates and with both preview and export being set to XLSx. My report preview rendered after an hour and resulted in eclipse.exe having a 14G Working Set and 14G Peak Working Set with on Windows 7 Professional w/16G of RAM, resulting in loss of use for anything during that hour while the preview (with exported Excel) rendered. On the other hand, Jaspersoft Ireport Designer 5.5.0 rendered the same report within a minute. Outside of setting my eclipse.ini to -Xms1024m and -Xmx40964m for Jaspersoft Studio 6.4.0.final, there were no configuration customatizations. Is there any advice on improving the performance of my Jaspersoft Studio 6.4.0.final installation?

Appears to be working now. Thanks darth_fader!

Hi,I'm using (Luna Eclipse and) TIBCO Jaspersoft® Studio - Visual Designer for JasperReports: . JasperReports Library and Tools 6.4.0.final (without the server) with both preview and export being set to XLSx. My table element (seleted from the Palette) appears to be giving me "Element reaches outside table detail contents .... ...JRDesignTextField...", despite having the following properties: <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> <property name="net.sf.jasperreports.export.xls.auto.fit.row" value="true"/> <property name="net.sf.jasperreports.print.keep.full.text" value="true"/> <property name="net.sf.jasperreports.export.xls.wrap.text" value="false"/> I did notice that despite these settings: the (seemingly required? parent elements') width settings on the column and reportElement are the likely culprits: <jr:column width="68" uuid="d674b459-5091-4f10-8450-d46ca9f04908"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:tableHeader style="Table_TH" height="30"/> <jr:detailCell style="Table_TD" height="30"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> <textField> <reportElement x="0" y="0" width="118" height="30" uuid="382cfbfc-4b32-47ba-b7ed-c4dc0790ac29"> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> <property name="net.sf.jasperreports.export.xls.auto.fit.row" value="true"/> <property name="net.sf.jasperreports.print.keep.full.text" value="true"/> <property name="net.sf.jasperreports.export.xls.wrap.text" value="false"/> </reportElement> <textFieldExpression><![CDATA[$F{Status}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> JasperSoft Studio reverted my pointless attempts at removing the column and reportElement widths. What changes must be made to get the full benefit of my excel properties inside my table element? Is there an auto width for column and reportElement (like a "reverse inheritance" since the width of the cell data should "propagate up")?

property was removed by Studio when entered manually through source tab. property does not appear as an option through "Edit Properties" for Column1's TextField nor Column1. All attempts to remove/delete the default width for the column have failed. Please advise.

Hi,I'm using (Luna Eclipse and) TIBCO Jaspersoft® Studio - Visual Designer for JasperReports: . JasperReports Library and Tools 6.4.0.final (without the server) with both preview and export being set to XLSx with my table element. Unfortunately, all my columns' data is truncated. How do I set this up to auto adjust based upon cell data width (contents)? Back in 2011, I saw where this was supposed to be in the next release? I will gladly take either a solution or a workaround. But, hopefully a workaround that would be much more effective than modifying hundreds of individual Jasper Elements.