Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Is there a way to change letterheads on multiple reports automatically (not manually)?

Posted on 2003-11-24
3
Medium Priority
?
347 Views
Last Modified: 2012-05-04
I have a large number of crystal reports that contain the same letterhead.

The company has recently moved and would like to change all the addresses in the letterheads (header of reports), is there a way of doing this automatically?

If I have no choice but to manually change each letterhead, is there way to avoid this problem in the future?  ie, can I link the company logo and text that is to appear in the letterhead form a word document (or some other way to minimize manual editing of a large number of reports (letters).

Thanks in advance

PS: I do not have a great deal of experience with crystal reports, so I apologize in advance if this is a silly question for all the seasoned experts.
0
Comment
Question by:rafyt
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 42

Expert Comment

by:frodoman
ID: 9817623
You can create a small report that contains only the logo and address information.  Then put this report into your main report headers as a subreport.  In the future you can just change the subreport and the changes will carry through to all of your main reports.

0
 
LVL 42

Accepted Solution

by:
frodoman earned 1200 total points
ID: 9817653
If you don't know about subreports, here's a little more detail:

Create a report that contains logo and address only.  Supress all other sections.  Save this report as "HeaderReport.rpt"

Open one of your main reports.  Select Insert -> Subreport from the menu, then browse to HeaderReport.rpt   Drop the rectangle in your RH (report header section).

Right-click on teh subreport and select "Format", then click the "Subreport" tab.  Make sure there is a checkmark in the "Re-import when opening" box.

Save your main report.

That should be it.  To test it, make a change to HeaderReport.rpt and save it, then open your main report and you should see the change.  

Repeat this process for each of your main reports.  No shortcut around modifying all 40 of them this time, but in the future you'll only have to make changes in one place.
0
 

Author Comment

by:rafyt
ID: 9820967
Thank you

I haven't had a chance to test it out... but it sounds like a good plan

Thank you
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This course is ideal for IT System Administrators working with VMware vSphere and its associated products in their company infrastructure. This course teaches you how to install and maintain this virtualization technology to store data, prevent vuln…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question