tarz87

Good evening, how I can convert this of Crystal report shared NumberVar Array array_indice3 ; "Pag." & ToText (array_indice3[GroupNumber],000) in Jaspersoft? You can help me, please? Thank you

Yes, the two parameters come from the query of the main report I am using Oracle as a data source Unfortunately, I can't use a SUM OVER because the two queries soon differ. I need the count to not reset when the multiple subreports is generated in the Detail Band of the main report

I have a subreport that receives two parameters and therefore generates as many reports as there are combinations of parameters, I have to put a row counter in the sub report but this must not reset every report generated by the sub report but must continue the numbering. Do you have any ideas? Can someone help me? Please Thanks a lot to everyone

Help me please

Hi guys, I have a question, I have a subreport that prints many lines because it is in the detail band, for me this is fine, but I want to filter the rows based on parameters when I print the report, I used the option "print when" to set the Boolean condition but not it works, this works with only one parameter. The condition is: (!"N".equals($P{Chk_Amministratori}) || ($F{nosCod} != $P{CheckDinamico1} || $F{nosCod} != $P{CheckDinamico2} || $F{nosCod} != $P{CheckDinamico3} || $F{nosCod} != $P{CheckDinamico4} || $F{nosCod} != $P{CheckDinamico5} || $F{nosCod} != $P{CheckDinamico6} || $F{nosCod} != $P{CheckDinamico7} || $F{nosCod} != $P{CheckDinamico8} || $F{nosCod} != $P{CheckDinamico9} || (!"N".equals($P{Chk_Amministratori}) || ($F{nosCod} != $P{CheckDinamico1} || $F{nosCod} != $P{CheckDinamico2} || $F{nosCod} != $P{CheckDinamico3} || $F{nosCod} != $P{CheckDinamico4} || $F{nosCod} != $P{CheckDinamico5} || $F{nosCod} != $P{CheckDinamico6} || $F{nosCod} != $P{CheckDinamico7} || $F{nosCod} != $P{CheckDinamico8} || $F{nosCod} != $P{CheckDinamico10}) ? Boolean.TRUE : Boolean.FALSE If I put a parameter it works, for example $F{nosCod} != $P{CheckDinamico10} ? Boolean.TRUE : Boolean.FALSE Can anyone help me?

Hello everyone, I have a report consisting of 20 sub reports, I put the sub reports in the detail band and when I print the report I print multiple pages. A sub report has several lines of output and therefore every time I replicate the sub reports that have only one line of output. I would like to print the report in such a way that each sub report is printed once and the sub report with many lines one row below the other. I tried to put all the sub reports in the summary band but it only gives me one page with little information Do you have any in mind what I can do? Thanks for your help

I have a problem, I must covert a report from Crystal Report to Jaspersoft Studio and in the crystal report I have this Selection Group in Workshop formula if IsNull (FIELD_1) then FIELD_2= Minimum (FIELD_2) else FILED_2= Minimum (FIELD_2) and FIELD_1= Minimum (FIELD_1) This formula causes data to be limited. I tried to use a parameter that changes by putting the parameter in the sql, but the query does not go wrong but returns me nothing. I used the formula in "filter expression" It should return at least one row Thank you very much for helping

In the crystal reports, I have this situation of a variable: numberVar nsup; numberVar nrec; if (field=17) and (filed="SS") then nsup:= nsup+1 else if ( ( (isnull(field)) or (field=1) ) ) and (field <> "PO" and Left(field,2)<>"SC") then nrec:= nrec+1 else nrec:= nrec; the result is: 1 2 3 1 2 how do you change numbers? is there a group? where can i check it? I must create a similar report with jaspersoft studio You can help me. Thank you

I have a problem. I have in all report any string with ' and jasper report put me the ? or when I have a character à or ò put me a strange symbol. You can help me? Thank you Best regards

Thank you! It is perfect.

I know the java's statement, but when I put field.isNumeric() in my statement jasper soft ask that is.Numeric() is not valid for the string. I want to see if my string is numeric or no and I want that gives me is the string is numeric a number otherwise 0. I try this statement field_string..isNaN() == 0 ? 0 : filed.intValue() or field_string.isNumeric() == 0 ? 0 : filed.intValue() but both return error. You can help me?

I have to create a variable into my report, but this variable was getting from a report created with crystal report. The variable in the crystal report is: IF (isnumeric(field.string)) then ToNumber({field.string}) else 0 I don't know how I can do this with the jasper report. I must create a variable with java and not with the component in jasper soft. You can help me! Thank you Best regards