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

FileName garbled in preview

33 Views

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