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.