stevenell

The 16 char limit is probably coming from the JDBC driver for our specific database... these issues don't occur when I test the report designer against MySQL. I reported this issue to our database vendor... their response: "...there is nothing in the driver that would cause this unless iReport is using max column size value to truncate aliases. The max column size is 16, but that doesn't affect the size of aliases..." They are still looking into it.. i will let you know if I hear anything else from them.

the query designer is looking pretty good.... but I have some problems with it there seems to be a 16 char limit on some of the strings... for instance... this code is generated by the query builder SELECT COMPANYMASTER."COMPANYCODE" AS COMPANYMASTER_CO, COMPANYMASTER."COMPANY_NAME" AS COMPANYMASTER_CO FROM "my-db"."COMPANYMASTER" COMPANYMASTER so that code doesnt work because of the identical aliases... i guess it should look like this SELECT COMPANYMASTER."COMPANYCODE" AS COMPANYMASTER_COMPANYCODE, COMPANYMASTER."COMPANY_NAME" AS COMPANYMASTER_COMPANY_NAME FROM "my-db"."COMPANYMASTER" COMPANYMASTER and ideally ( the root of my question actually ) i would like to be able to configure the querybuilder so that it does not prefix everything with the schemaname.tablename except in those cases where it is needed to prevent ambiguity... actually i would like the above query to just come out like this: SELECT COMPANYCODE, COMPANY_NAME FROM COMPANYMASTER maybe there are already some configuration options for this? thanks Steve Nell

We've found it easy to highlight every 3rd row in most cases, but in some reports we have group headers / footers that appear conditionally. Normally we would not want to include group headers / footers in the highlight count, but these special reports were designed to replicate the formatting on some legacy reports. The end result is that the group header and footer have a similar appearance to the detail row and therefore I have been asked to include those in the highlight count. I have tried using various types of variable counts / sums that when added to Page_COUNT would give me a running sequential number that I could use for conditional highlighting, but have been unsuccessful in that approach. Is there maybe an easier method that I am overlooking? thanks Steve

we have a report that looks like this: ( columns delimited by pipe character ) schedstep | description | predecessor 15 | foo1 | 14 16 | foo2 | 13 16 | foo2 | 14 16 | foo2 | 15 17 | foo3 | 16 but we want it to look like this schedstep | description | predecessor 15 | foo1 | 14 16 | foo2 | 13,14,15 17 | foo3 | 16 regards, Steve Nell

Teodor, giving the property 3 settings solves my concerns about unintentional behaviors... this sounds good. thanks Steve

Teodor, I vote for implementation #2 -- isFooterAtBottom should be weaker than isStartNewPage I dont want isFooterAtBottom to push any other components around on the page -- mostly because I think that type of behavior would be too complex to be understandable by the average report designer ( me ) . I see that a single group footer can have multiple bands... I assume the property would apply be set at the group level & would apply to all the bands in the footer? thanks, Steve

I see various mumblings about an eclipse plugin, but most of these are from a few years ago and/or reference a version of iReport prior to 3.0. Just curious if a current ( iReport 3.5.x and above ) version of an eclipse plugin exists... thanks Steve

Teodor, I would be very happy having the simpler implementation for now. Consider initially making the property only applicable to an outer group -- so as to leave open the possibility of implementing the more 'intuitive behavior' later. At first glance I cant see any benefit in introducing the functionality where setting this property on an inner group would cause a push of other content to a new page. Perhaps if that need arises it could be bound to a different property? thanks for your efforts, Steve

In general, I think it is reasonable to expect the user to manually set this property on all 'wrapping' or 'outer' groups. If the user sets the property for an interior group and doesnt set it for the exterior groups, then it is ineffective. The user should be able to look at the results and figure out that they didnt align the outer groupfooters to bottom -- easily corrected. answering other parts of your note: ---- Should the outermost group footer be rendered on the next page, since the middle group footer was force at the bottom? Or should the middle group footer force the outermost group footer to print at the bottom too, on on top of the other. ---- The middle groupfooter shouldnt force anything else out of place. ---- What If all three group footers have this option? Should they all overlap so that they all be at the bottom of the page at the same time? Or should they stack at the bottom of the page? ---- They should stack. From a user's perspective this is how I would describe the expected behavior: render the report as normal and dont pay any attention to the 'aligngroupfootertobottom' flag... after the report is rendered, go back and inspect all the group footers from outer to inner... if the property is set and there is empty space below that groupfooter then push it to the bottom of the available space. Dont force anything to a different page and dont let inner groupfooters push outergroupfooters around. thanks for your efforts, Steve

Teodor, I appreciate your attention on this. A fixed size group footer aligned to bottom would not meet our needs in this instance. Some additional info: With the introduction of the 'runToBottom' property I was able to create a subreport with runToBottom set to true and house my signature block in that footer of that subreport. So that pushes it to the bottom. However... that approach forces me to use a fixed height for the signature block. Initially that was ok but then I discovered that we have varying length text that sits above the signature block, so it can be 2 or 3 or 10 lines of legal jargon followed by the signature block. So I have to set the height to accommodate the maximum number of lines and that results in wasted space most of the time since most of our customers only use 1 line of text. So we have a workaround but it is still not ideal. ( And even if it did work completely I would still prefer a way to do this without resorting to a subreport. ) Let me know if you need a report sample or other info. thanks Steve

problem: I took the 'list' sample in 3.5.2 and ran 'ant test' and everything worked... then I modified the report to use groovy as the scripting language -- whan I ran the 'ant test' script on the modified sample I got the error below... [java] java.lang.NoClassDefFoundError: org/codehaus/groovy/runtime/callsite/CallSiteArray resolution: I found the problem... turns out that I had this file in my ant directory. C:apache-ant-1.7.1libgroovy-all-1.6.0.jar Post Edited by stevenell at 08/13/2009 23:33

I am using iReport 3.5.2, JasperReports 3.5.2 when I compile my reports with Ant, I get the following when I try to run the reports (java.lang.RuntimeException: Class not found: org/codehaus/groovy/runtime/callsite/CallSiteArray) but if I compile the reports with iReport I dont have this problem. the relevant parts of my buildfile are below. thanks Steve <path id="compile-classpath"> <fileset dir="d:/iReport-nb-3.5.2/ireport/modules/ext"> <include name="**/*.jar"/> </fileset> <pathelement location="c:/p4ws/ihms/main/lib/ihms-ireport-helpers.jar"/> </path> <taskdef name="jrc" classname="net.sf.jasperreports.ant.JRAntCompileTask" > <classpath refid="compile-classpath" /> </taskdef> .... .... .... <jrc srcdir="c:/p4ws/ihms/main/reports/src" destdir="${g.target.env.home}/lib/ihms-common/com/ame/ihms/reports" tempdir="${g.target.env.home}/lib/ihms-common/com/ame/ihms/reports" keepjava="false" xmlvalidation="true"> <classpath refid="compile-classpath"/> <include name="**/*.jrxml"/> </jrc>

thanks -- that does work Steve

Repeating the group header when it splits onto a new page works nicely, but i would like to add the something like "continued" when it repeats. i.e. ASSETS ------ page break --- ASSETS ( continued... ) I've searched but didnt find anything obvious -- is this possible? thanks Steve

using iReport 3.5.1 1 ) when I add a style reference to the 'styles' node in the 'Report Inspector' pane, I would then expect to see any styles contained in the referenced .jrtx to appear in the drop down for 'style' in the properties pane when applying a style to a control... but they dont show in the dropdown and I have to type it in... 2 ) it is kind of a pain to set style references on every element by digging through the properties... after adding my style template reference as mentioned above, it would be nice to see the contained styles show up as child nodes of that template node in the report inspector pane... ( would also be nice if they would appear in hierarchical layout honoring the 'parent style' property ) and then be able to drag a 'style' node onto an element to apply the style.... ( these enhancements may be more appropriate in the 'style library window', but it would be nice to be able to do from both areas because it seems the 'styles library window' is more of a 'per iReport installation', so being able to apply from the report pane would be easier to keep configured in situations with multiple developers ) 3) when I do set a style as described in #1, the control that received the applied style does not adjust to reflect the new style ( font size for instance... ) so this is a little cumbersome because I have to set the font size manually so it will be readable in the designer and then also set the style I am new to styles, so I could be off base on all of these -- but if they are accurate let me know and I will post feature / bug requests as appropriate. thanks Steve