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:
RCRI0031{7f301c1f-aec7-4f7b-ab97-065592444a69}
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.
Thanks,
Ajay Audich