Tuesday 27 February 2018

Find index of any character in a string in crystal report formula field.

mid({vw_ExportLaden.LSize},instr({vw_ExportLaden.LSize},'-') +1,2)

Thursday 8 February 2018

New line in crystal report.

// replace dollar sign with new line in a string for crystal report formula field

if {vw_CashBank.VType} = 1 or {vw_CashBank.VType} = 3 then Replace ({vw_CashBank.DebitHead},"$" , ChrW(13))
else Replace ({vw_CashBank.CreditHead},"$" , ChrW(13))

//build a string with new line for crystal report formula field.

        While rdr.Read
            strYardDetails += """" & rdr("Title") & """ + ChrW(13) + "
        End While

Sunday 4 February 2018

Remove decimal point in crystal report formula field.

 totext({vw_ExportEmptyLaden.Size},0,"")