Skip to Content
Aug 20, 2013 at 07:21 PM

FileName garbled in preview


Using SAP B1 ver 8.82 PL6 with CR 2008.

I created a CR and then put in a formula in foooter with FileName as follows:

LEFT(Mid (Filename ,InstrRev (Filename,"\") + 1),(InStr(Mid (Filename ,InstrRev (Filename,"\") + 1),".rpt")-1))

The preview in CR 2008 looks perfect but when I import the RPT to SAP it shows garbled as follows instead of the file name:


What do I need to do to make the FileName appear correctly when running report from within SAP B1? I do not want to hard-code the file name every time I change the report.


Ajay Audich