jpauze

Not familiar with Fishbowl but I know that MID is a function available in Access but not part of the ANSI standard (to the best of my knowledge) so at least with MS-SQL you would use the SUBSTRING Function which does the same thing. Why SUBSTRING doesn't work in your case I can't comment on but the MID would be explainable. Do you have a link to a site for any docs on Fishbowl? I could take a look for you and see if i can figure anything out. Jeff

There are a number of threads on here to deal with Conditional Formatting, as a guide, check out the help documentation on Conditional Styles or search the formum for the same, the documentation is pretty comprehensive on the subject. Basically you create a Conditional Style with the expression you are looking for and the color style you want, then you assign the style to your text element and voila, when the expression evaluates to true the style kicks in and overrides. Thanks Jeff

Great write-up Carl, the setting to "System" will get you every time, I think everybody has run into this one and scratch your head after and wonder why the value is always null....

Should be able to righ click the sub-dataset in the report inspector and bring up the properties, within there if I recall is a parameter mapping section which allows you to map parameters in the sub-dataset from the calling report.

If you are trying to create sections that collapse/expand then there is no easy way to do this, I seem to recall that there is a potential using the generic element but I think it might be overly involved. Jasper/iReport is a reporting tool so you won't get User Interface style functionality.

Double check, when you added the group there should be a variable created specific to the group which can be used in the same manner as you were with the $V{REPORT_COUNT}. I recall by default the variable name will be GROUPNAME_COUNT where GROUPNAME is the name of the group you created. Hope that helps.

had some that didn't depend on order but wanted then in a specific order in the designer, also had some that required a specific order and at first i would add new band to the bottom then move all elements down one band and reset the print expressions to free up the band i wanted to add on. Total pain, the adjust through XML certainly makes life easier. At some point I will create a feature request to have an insert detail band from the designer.

Haven't done it myself but check out the following post and especially the last thread where the person posted the solution as well as code/report. http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=54524 Hope this helps Jeff

You could probably do it through a Chart Customizer although I am not sure the exact steps or the methods you would have to override. Matt has posted a great article on Chart Customizers and I have found it very useful, not exactly what you are looking for but might point you in the right direction. I was thinking that maybe there is a way to do this using a multi-axis chart, haven't tried it and just trying to be creative, what if you have two charts, the first chart has the full detail and you turn off the axis tickmarks and values completely, then you have another chart with all values set to 0 but the categories are different so that the labels space out, not sure if this will work because the multi axis charts may need to share the same horizontal axis (not 100% on that) and only differ in the vertical axis on the left and right. If I get a chance tonight I will play with it and see what happens. Jeff

See if these two posts help. Matt's chart customizer article http://mdahlman.wordpress.com/ Another related post: http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=85616

I haven't no, I have noticed periodically there is a delay in opening the report before i can select report elements but other than that performance has been great. Running 3.7.6, 4.01 and 4.02 all on 64-bit OS.

Sometimes it's the easy fix... Glad you are back to normal, that would have bugged me.

Check this, chnag eit to $V{totalDowntime} == null, the single = is an assignment operation that is trying to set the variable to null versus compare it to null.

Have you tried doing a Reset Windows action from the WIndows Menu? Might get you back to being able to dock left Jeff

Way too funny.... I think I got it to reproduce or something similar anyway.... I undocked the Report Inspector Window and then couldn't get it to dock back on the left side. I noticed that inside the undocked window there is a header bar that says "Report Inspector" you have to drag that column (inside the window) to the location you want it to be placed not the dock window itself. Hope that was clear and did what you are looking for? Let me know otherwise and I will send a screenshot. Jeff