Search results for query: *

Hi the formulas works and it's similar to what you did. However the problem is that, it's returning too much data and not within the range. Would you be able to find out what's wrong with the formula? Thanks.

Original DateRange formula: //WhilePrintingRecords ; Global DateVar Range DateRange ; DateRange:= (if {?Date Range} = "Last 7 Days" then CurrentDate-7 to CurrentDate else if {?Date Range} = "Last 30 Days" then CurrentDate-30 to CurrentDate else if {?Date Range} = "Last...

Attempting to round time to 2 decimal places. The result of formula gives value: (58:59 when rounding to 2 decimal places, but when rounding to 4 - 57:59, the value is correct) Formula is: totext(abs({procRptIndProdUserModuleTime;1.TotalTime} / 3600),"00") & ":" &...

column 2 row 2 contains 2 values that have a formula that looks like this: first value {@A}+{@B} second value: {@C}+{@D}+{@E}

i have a crystal report that will run on a scheduled basis. The crystal report contains a box that is editable field. The instance will be in the format of a pdf file and will be emailed.Once emailed, can the pdf be opened and can user edit the field and type in the editable field box? Also is...

Hi Ian Thanks. What if column 2 has different formulas already on it. Column 2 row 1 is headings Column 2 row 2 is values using diffrent formula Column 2 row 3 is values using different formula Would the above formula you provided change?

how would the formula look like?

I have a report that looks like a chart but it is created using lines and boxes. There are 3 columns and 3 rows looks something like this. It suppose to look almost like a crosstab but it is not. There is data in column 2. Column 1 and Column 3 have calculatoins that are based on Column 2 so...

do i need to enter x+1 in the formula/selection criteria?

yes that is correct.

Hi I would like to know how to create a conditional double page breaking in crystal report thank you

Thanks LB that work perfectly

when running the report: the error is produced: stringvar array z := split(y[2],"-"); a subscript must be between 1 and the size of the array

Hi LB you are right, my mistake: here is the revised formulas: 1) stringvar x:= {Objects.Address}; stringvar array y := split(x,":"); if isnull({Objects.Address}) or ubound(y) = 1 then {Objects.Address} else ( stringvar array z := split(y[2],"-"); stringvar elem1 :=""; stringvar elem2 :=""...

here are my three formulas: 1st formula: stringvar x:= {Object.Name}; stringvar array y := split(x,":"); if isnull({Object.Name}) or unbound(y) = 1 then {Object.Name} else ( stringvar array z := split(y[2],"-"); stringvar elem1 :=""; stringvar elem2 :=""; stringvar elem3 :=""; if unbound(z) >...

Hi LB this is what i have for the first formula field and is throwing me an error: higlighting unbound(y) : a number, currency amount, boolean, date time , date time or string is expected here stringvar x := {table.field}; stringvar array y := split(x,":"); if isnull({table.field}) or...

Hi Lb, The field always begins with "Original:" but anything after that may be different See example: Original: ABCDEFGHIJKLML - 12345678 - HelloWorld Original: ABCDEFGDG - 2343423 - Hello Original: AB - 3434434434 - World Thanks again

Hi LB, the field always starts with "Original". is correct. my 3 formula fields look like this: 1. stringvar x := {table.field}; stringvar array y := split(x,":"); stringvar array z := split(y[2],"-"); stringvar elem1 := ""; stringvar elem2 := ""; stringvar elem3 := ""; if ubound(z) >= 1 then...

The error I get is: a subscript must be between 1 and the size of the array and it highlights stringvar array z := split(y[2],"-"); in the formula.

Hi LB, thanks for your help. In your formula, is it possible to not hardcode it, because the field is in that format but not necessarily those values stringvar x := "Original: ABCDEFGHIJKLML - 12345678 - HelloWorld";