JasperStudio variable for crystal report

[er.navneetverma]

Hi Everyone,

I need to convert below crystal report formula in Jasper Studio. Please help.

 

dim ary() as string, formatOK as boolean
formatOK = true
ary = split({?dte_book_dt}, "/")
if ubound(ary) <> 3 then
    formatOK = false
elseif not(isnumeric(ary(1)) and isnumeric(ary(2)) and isnumeric(ary(3))) then
    formatOK = false
end if
if formatOK = true then
    if {?dte_book_dt} = "" or isnull({?dte_book_dt}) then 
        formula = ""
    else
        formula = totext(datevalue(tonumber(ary(3)),tonumber(ary(2)),tonumber(ary(1))),"dd-MMM-yyyy")
    end if
else
    formula = "Date Format should be in DD/MM/YYYY"
end if

 

 

Thanks

Navneet

[hozawa]

JasperReports only supports 1 line in expression.

[prusyn]

Not being familar with crystal reports, this is not much helpful. Can you specify what are you trying to acheive?

 

As I understand you are trying to build date out of three integers. Is that correct?