Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Crystal Reports File Path

Crystal Reports File Path

Crystal Reports File Path

I have created a formula called @TemplateFileName with the following codes
dim pos as number
dim pos2 as number
pos = InStrRev(Filename,"\")
if (pos = -1)then
pos2 = -1
elseif (pos > 0) then
pos2 = InStrRev(Filename,"\", pos -1)
pos2 = -1
end if
if (pos = -1) then
formula = Filename
elseif (pos2 > -1) then
formula = Mid (Filename, pos2 +1)
formula = Mid (Filename, pos + 1)
end if
If I use this formula in the report footer of Crystal Reports It gives me the following path:
Desktop\Talent Tenture Bonus.rpt

Once i save the report to Business Objects Enterprise in a folder TBG and sub folder Testing, the same formula gives me the following result:

How do I get the path for the folder to be
TBG\Testing\Talent Tenture Bonus.rpt


RE: Crystal Reports File Path

I believe you would have to hard code the path. Unfortunately once the report has been saved to Enterprise, it uses it's own internal format for the file path and report name. I do not know of a way around this issue.

RE: Crystal Reports File Path

The FileName special field gives you the actual physical file name of the the report. What you see after publishing the report to BO is the location of the report in the file repository. There is no way to get the information about which folder that's displayed in BO that the report is located in. This is something you'll have to hard-code into your report.


DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close