Attempting to make a modification to UniformPaymentAdvice need to remove the first 2 characters from the Invoice ID. Attempted to use this - vldtstr:StrLTrim(tns:INVOICE_NO,'SI') and I get the below error when I try to render the PDF.
If I try to render again I get the below errors. And then the No Data Available error.
Hi,
I think the function statement is case sensitive. Try changing vldtstr:StrLTrim(tns:INVOICE_NO,'SI') to vldtstr:strLTrim(tns:INVOICE_NO,'SI') and you should be able to render the pdf.
Also that function will not work as it only will trim the first character ‘S’.
Try vldtstr:strReplace(tns:INVOICE_NO,0,2,'') should do the trick.
BR
Johan
Thanks Johan that has fixed my issue.
Happy to help!
Issue with Report Designer Aggregate Function
Report Designer Function Aggregate functions like Max, Min, Avg is applicable on Number format but not on dates.
I want to minimum of detail level dates, its not giving right information, please help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.