INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

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!

Join Tek-Tips
*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 from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Dynamic Titles using the Report Title Special Field

Dynamic Titles using the Report Title Special Field

(OP)
Hello,

I am using CR XI with Oracle 9 DB.  Is there a way to modify the Report Title special field in the Documents Property to append  mm/yyyy date format dynamically?

Thanks,
Greg

RE: Dynamic Titles using the Report Title Special Field

Not to my knowledge and I just tried it.  It is a special field, the summary info is taken out of the File\summary Information\Title field.

Why can't you just add the format to the print date  (or other date special field) special field.

RE: Dynamic Titles using the Report Title Special Field

Write a formula:

"This is my Report for"&totext(CurrentDate)

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports
www.gainfocus.biz

"making predictions is tough, especially about the future" - Yogi Berra

RE: Dynamic Titles using the Report Title Special Field

(OP)
Thanks for the quick reply. We are also using Crystal Report Server XI to schedule reports which are export to Excel. When the reports run, it uses the the report Title for the report name/file name. There are scripts that are running to move the reports. The reports that are moved to the achives folder and are replace over the previous report because the name is the same. I'll have to find another solution

Thanks

Gee

RE: Dynamic Titles using the Report Title Special Field

(OP)
I figured it out! When you at the Report Title field to the report right click and select Format Field... Half way down there is an option called Display Field. You can create a formula! The only thing is you have to initial input a title to the Document Properties. The formula will over ride it

Gee

RE: Dynamic Titles using the Report Title Special Field

Cool, I didn't think of that!

RE: Dynamic Titles using the Report Title Special Field

This is awesome- We're planning a migration from CR 8.5 with "home grown" asp web reporting to BOXI Premium, and I've got a pair of reports (on a CR XI test server) that basically run every 1st of the month and archive data into text files. I cant believe I didnt find this forum sooner... lots of good stuff like this!

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