Recent content by shams100

I could also create the sum. -I created another formula dim Y Y=tonumber({@MySecondFormula}) formula=Y -Insert it in the Subreport as field -Created sum for that field. Thanks

I did it like that First Formula: stringvar array x := split({MyFIeld},"|"); x[5] And Created another formula from the first one : stringvar array x := split({@MyFirstFormula},"~"); x[2] This worke fine. Now is there any way I can create SUM for that value

I have a sub report and there is a field in it is An Array. This is example to explain how the data display in that array field: valueA~1.10~1.10|ValueB~2.20~2.20|ValueC~3.30~3.30|ValueD~4.40~4.40|ValueE~5.50~5.00 Is there any way that I can get only the value for field valueC and the value...

Sorry, this is more clear: Use the display value for the max if max value is NULL Use the display value for the min if min value is NULL If ((DisplayValue < MinValue) or (DisplayValue > MaxValue)) then Issue=1 Else Issue=0 Eg. DispValue Min Max Issue...

This is another Example to make it very clear. This example for one month only. if Max is null use the DispValue field with condition that DispValuenot is not < then the Min field If Min is Null use the display field with condition that it is not > than the Max field DsipVAlue MIN MAX...

Month DispV Min Max 1 299 500 NULL 2 291 500 NULL 3 360 500 NULL 4 760 500 NULL 5 813 500 NULL 6 755 500 NULL 7 683 500 NULL 8 664 500 NULL 9 600 500 NULL 10 462 500 NULL 11 471 500 NULL 12 762 500 NULL 1 5.97 0 5 2 13.13 0 5 3 12.83 0 5 4 8.76 0 5 5 10.46 0 5 6 9.58 0 5 7 9.18 0 5 8 8.41 0 5 9...

Thanks for your respond: Sample of the data" Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 4 5 7 8 5 4 3 0 5 5 6 8 The report has year as a parameter. Thanks

I have this situation and I will appreciate any help: I have table with 4 fields. DispValue, Max , Min and month I want to write a formula to count the fields for every month with that condition: If Max is null use the DispValue field with condition that it is not < that the Min field If...

I really will appreciate any help I have table with 4 fields. DispValue, Max , Min and month I want to write a formula to count the fields for every month with that condition: If Max is null use the DispValue field with condition that it is not < that the Min field If Min is Null use the...

I solved the first part which if user pick up one value: I created @Age formula << numbervar a; stringvar e; if instr(e,{a.arrAge}) = 0 and {?Age}= split({a.arrAge},",") then e := e + {a.arrAge}+", "; {a.arrAge} in e >> and I added the formula in the report record selection. And this is...

Thank you very much This is working! Another issue show up: There are other parameters come as array field separated buy comma EX: [Children, Adults, Toddlers] So If user pick up Children will need to show all records which Age field has Children If user pick up All it should return all...

Any help will be appreciated: I need a parameter where a user can select "ALL" or "one division" So I create {?division} parameter and Added "All" to the values list and Under record selection Formula I added the below code: if {?division}<>"ALL" then {a.division} = {?division} else If...

lBass, Thank you very much. It is working. It was data problem. You are Star!!

I did that but still show sometime right data and sometime not EX: If I pick up Non-Hispanic it will display Non-Hispanic and also Hispanic one

{@ArrEthnicity_Array} and {@ArrAge_Array}and {@ArrRace_Array} I used your formula for each parameters : Ex: {@ArrAge_Array}: numbervar i; numbervar j := ubound({?Age}); stringvar x; for i := 1 to j do( if instr(x,{a.arrAge}) = 0 and {?Age}[i] = split({a.arrAge},",") then x := x +...