INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

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!

*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.

Jobs

Crystal Reports File Path

Crystal Reports File Path

(OP)
I have created a formula called @TemplateFileName with the following codes
------------------------------------------------------
WhileReadingRecords
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)
else
pos2 = -1
end if
if (pos = -1) then
formula = Filename
elseif (pos2 > -1) then
formula = Mid (Filename, pos2 +1)
else
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:
5\~crw{20477165-33F1-4914-ABA8-2CA0C4048328}.rpt

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

Thanks
-P

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.

-Dell

DecisionFirst Technologies - Seven-time SAP BusinessObjects Solution Partner of the Year
www.decisionfirst.com

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!

Resources

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