marlin_snyder

I have a report that creates several columns to hold misc data as the stored procedure runs. For instance call stored_proc(1) returns the static fields plus misc_1 and misc_2. call stored_proc(2) returns the static fields plus misc_1, misc_3 and misc_4. The report fails with 2 because it can't find misc_2. Is there a way to force the report to refresh the field names at runtime?

I thought I had tried all combinations of reset type, calculation type and increment type. Just to make sure, i went back and set them as recommended. The variable still changes with each group. Thank you for the suggestion.

I have a report using many variables to calculate a rolling inventory over 16 months. The users are requesting some difficult calculations in the rolling (or carryover) such as only carryover amounts > 0, but only for some categories(groups), and then add the carryover from one category to the carryover in another category. I have most of the issues worked out, but I need to set a variable for the carryover ONLY when the group ="XXX", and maintain that variable value even when the group changes. I can easily set the variable to change over categories (groups) $F{group1}=="XXX"?QTY_ON_HAND - QTY_ORDERED:0.0, but when the group changes to "YYY" and then to "ZZZ" the value of the variable changes to 0. I need to use the value of the varialble when it is in the "XXX" group as part of the calculation when it gets to group "ZZZ", but if it resets to 0 at that time, it is useless. I have the Calculation set to "No Calculation", Increment and Reset types set to "None" I am using Studio 5.5, but the same would apply to IReport Designer. Thank you for your assistance. Marlin Snyder I have tried setting the Calculation Type to "First" and various settings on the Reset Type. Group will set the value to 0. None sets the value correctly, but it still changes with each group change.

We are using iReport 5 and JasperServer 5. W have a report based on a MySQL Stored procedure that runs fine in the Designer, but throws a 6632 error running from the server. The stored procedure accepts 3 parameters, I have set the parameters up as Input Controls on the server. When we run the report from the server, we get the following error: An error has occurred. Please contact your system administrator. (6632) In previous versions, this was reported as needing a regular expression for the SQL Validation property, or needing to lengthen the size of the number of characters in the underlying query, both of which we have attempted without success. I will attach the xml for the report, if that helps

I have a Nested IF expression working in Crystal Reports: if {@%Effect} <= 0 then {@CoCalcPL}else if {@%Effect} < 80 then {@CoCalcPL} * (1 - ({@%Effect}/100))else if {@%Effect} < 120 then 0else if {@%Effect} > 120 then ({@CashGL} * 1.2) - ({@CoCalcPL} * -1)else 0I'm struggling getting it to work properly in iReport: $V{PctEffect} < 0.0 ? 0.0 : $V{PctEffect} < .8 ? $V{CoCalcPL}*(1.0-$V{PctEffect}) : $V{PctEffect} < 1.2 ? 0.0 : $V{PctEffect} > 1.2 ? ($V{CashGL}*1.2)-($V{CoCalcPL}*-1.0) : 0.0 If I remove any two of the nested expressions, it will work fine, but when I add back even one nested expression, I get a compile error before the report even begins to fill. I have looked at several examples of nested IF expressions online and tried all of the various recommendations for enclosing in parenthesis, and haven't found anything to work with more than two expressions. I'll post the xml below

I see that this question has been asked several times, and I also see that it has been answered, but usually not with much detail, and I apologize if I have just missed it somewhere. I have a report with about 50 variable fields on it. In each of those fields, I want to show the currency formatted number in black, bold if it is 0 or greater than 0, and change only the color to red if it is less than 0. I am testing this on one field only right now, I will also attach the full xml file as well. I'm certain that there is something I am missing relatively simple here. I also have a couple of questions related to this. Is there no way to apply a generic 'conditional format' to all fields on the report? Am I reading correctly that I will need to create a set of conditional styles for each field, and then apply the style (what I'm calling 'Normal') to each field?I also downloaded and read the Ultimate User Guide, which only has a few bits of information on how this feature works. Perhaps there is an online tutorial for this somewhere? I'm happy to research it if pointed in the right direction. Sincerely, M. Snyder

Thank you Aitor, This method does work (although in the ("$0.00") I did have to escape the $, so ("$0.00")). It accomplishes what I was trying to do dynamically, and overcomes the roadblocks I was hitting... Sincerely, M. Snyder

That kindof works David, in fact, that's how I have it set up now. The problem is that the Parameters allow for all kinds of entry, for instance, the user could enter 3, or 1.5 (for $3.00 and $1.50 respectively) and if they do that, the resulting string shows as "(+/- $3.0 Fut ~ +/- $1.5 Opt)". I can also append the second 0 at the end of the Parameter, but then if they do enter 3.00 and 1.50, or something like 1.05 it would not show correctly. In the meantime though, thank you for the information, and we can use it until we find another solution.

I have an expression for a variable where we are concatenating a string, a double datatype parameter (entered at runtime), another string, another double datatype parameter, and a final string. The expression is shown below: "(+/- " + $P{LCF} + (" Fut ~ +/- ") + $P{LCO} + " Opt)" I would like the two parameters formatted as currency, no matter what the user enters. So they may enter 3, or 1.5, or .4, and they should be formatted as $3.00, $1.50, $0.40 ($.40 would be acceptable). Any recommendations? Thank you, M. Snyder

**

Excellent! Thanks much for the pointer, that worked perfectly. I did find a 'workaround' by clicking directly on the field in the report, I was able to apply the rounding function at that level (certainly after the variable has been evaluated, so going around the issue I was having), and it worked. I have now removed that field level formatting and applied it to the variable after moving the dependent variable up in the list. Thank you again, M. Snyder

We are using 5.0.1, and have converted many of our Crystal Reports projects over to iReport/Jasperserver and are happy with the results so far. I am converting a summary report now that has variable fields in the detail section, multiplying a combination of integer fields and float fields from the database. I am suppressing the detail section using the Print When Expression, and have created 3 variables to sum the total of the 3 associated variables in the detail section. The business rule is to round the result in the summary, so, in the Variable Expression of the 3 summing variables in the group footer, I am wrapping Math.round() around the variable name from the detail section in all 3 of the summary variable properties. Two of them work flawlessly, one does not. We have double and triple checked to make sure that the summary variables have exactly the same properties, even copying from the working one(s) to the non-working and then renaming. We have checked the Variable Class to make sure it is Float datatype, and we have checked the data to make sure there are no NULL, empty string, or character data where there should not be. I have also run the report using the Empty Datasource, and it compiles and runs, but obviously with no results. If I remove the Math.round() wrapper, the report will compile and run with the other two summary variables rounding fine, but as soon as I add the wrapper function to the 3rd variable, the report throws an error: Error evaluating expression...then flags Math.round(LCIncr_Total), which is the offending variable name. I will attach the .jrxml and .jasper files to this request. Any assistance is appreciated greatly... M. Snyder