Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report Template driven by custom functions Post Reply Post New Topic
Author Message
Bigced21
Newbie
Newbie
Avatar

Joined: 25 Mar 2008
Online Status: Offline
Posts: 9
Quote Bigced21 Replybullet Topic: Report Template driven by custom functions
     Posted: 25 Mar 2008 at 11:30am

Hello,
I'm a newbie, and i'm trying to design a report template driven by a vw and/or stored proc to display information on a letterhead report. Such as names that can change at any time. I have another interface linked to the vw/sp to change that information at any time. What i'm trying to get is the idea of how to create a template letterhead report that i don't have to go back into crystal to change whenever the administration name changes.

Does anybody have any ideas or examples? I'm thinking Custom Functions are the way to go but, i just don't know how to get started with using them if that's the way to go.

Thanks in advance!

IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 25 Mar 2008 at 2:30pm
When you say that the names are changing, do you mean the field names? This can't be made dynamic. However, if you customize the SQL statement to use aliases, then you could give each field a generic name (Field1, Field2) and that way each view that uses this format could be printed from.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Bigced21
Newbie
Newbie
Avatar

Joined: 25 Mar 2008
Online Status: Offline
Posts: 9
Quote Bigced21 Replybullet Posted: 26 Mar 2008 at 6:45am

yes the field names can change.  Here's an example of the letterhead

ok you're the Director of the office and your name is on top of the letterhead which is deplayed by a field name from a view.  Also at the botttom of the letterhead your name is displayed again along with your Electronic signature, b/c we've stored a blob of signature. 
Now let's say 6 mos down the road you resign and I take your place.  Now instead of going into CR to make modifications  I have an external client that will automatically make the changes for me to the CR.  In order for my Name and elec. signature is displayed on the report. 
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum