Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Dynamic Titles using the Report Title Special Field

Status
Not open for further replies.

geestrong

Programmer
Jun 24, 2005
58
US
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
 
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.
 
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
 
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
 
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
 
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!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top