desperate

... is this possible? Seems to be not. Reason: I generated a java.util.HashMap as variable, which I filled in the print-when-property of an invisible section: ($V{Map}.put($V{PAGE_NUMBER}, $V{countPerPage}) == null) ? false : false As I obtain nothing than null as result when extracting values from this map, I tried to set "new HashMap() one time as Initial Value of this variable and another time the same as Variable Expression. Result is still null. So it seems to be impossible to use CollectionTypes as variables inside IReport?

Unfortunately, in my case, this does not work (and I do not really know why not): I have one subreport inside main report's detail section. This subreport contains a counter of a special property's occurance per page (this counter is reset on every new page). This property's result per page of the subreport I want to see inside main report's page footer. The reason for this quite complicated procedure is, that I can not print out this property's result in the subreport's page footer (what would be really simple), because either it appears in the middle of a page not completely filled or, if I use the runToBottom-Property, I will have an empty page with overflown white space in the end of the report. The one as well as the other is not satisfactory and therefore no solution. In the main report, I have tried out every possible evaluation time, but only on the last page footer (not on the "normal" page footer) it reacts as I would suppose. I bound this counter to my subreport return value with Calculation Type "Highest" and Reset Type "Page". So it should show the highest counter result per page, but it shows null. What else can I do to see a per-page-count from sub report inside page footers of main report? Post Edited by desperate at 06/21/2012 14:57

If you only need this for export, you can set special propery to suppress all empty rows. Where you intentionally use empty rows (which will also disappear), just put empty fields to avoid suppression. Post Edited by desperate at 03/16/2012 09:26

Hello community, can anybody tell me how to use the following exporter properties: - net.sf.jasperreports.export.xls.detect.cell.type - net.sf.jasperreports.print.keep.full.text Detect cell type sounds for me like evaluating field types while exporting and converting their cells accordingly. But it does not seem like that. In my special case, I have a text field collecting float values. If nothing is found (NaN), " -- " is returned. In my excel export, every number is signed as text formatted number, but it is not automatically converted to a numerical type, not even using detect cell type property. What can I do to achieve that? Keep full text property sounds for me like setting cell height big enough to be able to read complete text inside. But this also does not seem to be like that. Cell height does not change by use of this property. How can this be done for text fields with dynamical height? I put these two properties one time for whole report and then also separately for every field concerned. Thank you in advance for your hints!

Now, I know that the problem were graphics inside subreport. If I set IS_IGNORE_GRAPHICS flag, my report looks like I want it to.

Yes, my subreport contains one graphic. But the empty space is as large as the whole subreport, not only as picture height. But however, this was the hint I needed - the empty space disappeared. Thank you for your help!

What I need is some kind of similar property suppressing whole empty bands, even if they contain something what is not visible.

This would not work, as for suppressing bands for export, special properties are needed, which you obviously can not access in conditional expressions. When the subreport returns its variable, it still does not know in which format it will be exported... You understand?

I can not use this, as multi sheet export is also important to have.

Hello community, as I know, there are properties for suppressing header/footer and other bands for a certain export format desired. In my report, everything disappears inside my excel export, what I do not want to have there. One problem remains: The contents' empty spaces are still there. There are several properties to suppress empty lines in between. Where empty lines are wanted, empty text fields can be placed. No problem so far. But using these flags, the empty band only containing my suppressed subreport, still remains, what does not look very good and seems quite senseless. What can I do to suppress whole bands (contents and space) - especially when they contain subreports?

As this thread is very new and I have similar problems, I allow to join here for my very first post /tools/fckeditor/editor/images/smiley/msn/wink_smile.gif. With the help of all answers from this topic, I have been able to successfully suppress for excel export a detail section containing a subreport as well as page header and footer. Now, there is one remaining problem: All contents are suppressed as I wanted, but the empty bands remain in the excel export, still wasting their space. How can I get rid of them? I have already tried the following: - net.sf.jasperreports.export.xls.remove.empty.space.between.rows - net.sf.jasperreports.export.xls.collapse.row.span - net.sf.jasperreports.export.xls.auto.fit.row This makes ALL empty row spaces disappear, but unfortunately, not the empty space of the band containing the suppressed subreport. As I willfully use some empty rows, this removes everything I want to keep and keeps everything I want to get rid of. The first issue, my willfully used empty rows, are no problem - I can keep them by inserting an empty static text field for every one. This is not a very elegant solution, I think, but at least, it fulfills its purpose. But what about the large empty space of my suppressed subreport - I do not have any idea how to get rid of it! I think, it remains, because the subreport only becomes invisible, but it is still printed - so it still uses its space. Does anybody have an idea how to completely suppress whole bands (not only their contents)? Thank you in advance for your helpful brainstorming! Post Edited by desperate at 03/12/2012 11:25