FileName garbled in preview

[Former Member]

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

[DellSC · Accepted solution]

When you publish the file, it's actual file name changes to the format that you're seeing.  So you're getting the actual file name of the report as it exists on the server.  If your "file name" will change for every version of the report, you'll have to hardcode what you want into a text field.

-Dell