Smart questions
Smart answers
Smart people
Join Tek-Tips Forums

Member Login

Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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.

geestrong (Programmer) (OP)
8 Jun 06 15:16

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?

satinsilhouette (Instructor)
8 Jun 06 15:20
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.
dgillz (Instructor)
8 Jun 06 15:31
Write a formula:

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

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

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

geestrong (Programmer) (OP)
8 Jun 06 15:35
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


geestrong (Programmer) (OP)
8 Jun 06 16:45
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

satinsilhouette (Instructor)
8 Jun 06 16:46
Cool, I didn't think of that!
Ruune (Programmer)
9 Jun 06 9:29
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!

Back To Forum

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