I'm using Crystal Report 11.0 to display data from a system that sits on Sql database server. The application system is from a vendor and I have no control over they system.

Currently, I'm displaying the file name and path using the "File Path And Name" at Special Fields in Crystal Report. Unfortunately, it's displaying the location of the report which in my case the report folder in a server. How can I make it to display only the filename without the location or path?

Previously, in a different company I have the control on the application system. Thus, I pass a formula/parameter from the application system that contains the filename into the crystal report. Since I don't have any control on this application system I'm not sure how can I do this. Please advise.