Six Quick Crystal Reports Design Tips
page 8 of 9
by Jeff McWherter
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 86479/ 53

Text Watermark

A common report request is the ability to add a watermark to a report indicating that it is a draft. This example will show you how to accomplish this. In order to create the watermark, create a new header section, add a text object for the watermark and select the “Underlay Following Sections” option. This allows for new header to be above the rest of the sections of the report.

Figure 14: The Section Expert

Figure 15: The watermark in the designer

The text object that was added has a silver 72 point font set, font spacing of 80 and the text turned 90 degrees. The text rotation option is found off the common tab in the Section Expert.

Figure 16: Fulfillment report with draft watermark

Don't forget that you can suppress sections in Crystal Reports via code if you would like to provide an option to print the report without the watermark. Suppressing sections through code is out of scope of this document.

View Entire Article

User Comments

Title: Can's view the images of the article   
Name: Saif
Date: 2012-06-02 8:53:43 PM

I can not see the images of the article on below URL
for the topic "Showing a Check Box on a Report" Please help
Title: WaterMarks   
Name: Nitish
Date: 2011-12-16 3:34:03 AM
On Figure 16, the watermark does not underlay the lines in the detail secion of the report. Is there a way to make this happen?
Title: developer   
Name: Durgesh dixit
Date: 2011-06-08 12:54:39 AM
This artical is very helpful for us
Date: 2011-04-28 3:39:42 AM
Thanks for the information
------------ Showing a Check Box on a Report
this is very very usefull to me
Title: It Consultant   
Name: Jerry Jesiolowski
Date: 2011-03-14 11:01:13 AM
We are using Crystal Reports 2008. My question is can we install this on a Server such as Termial Servier where everyone could access the one copy and use the one copy of the SAP GUI as well. We are trying to keep lower our Total Cost of Ownership. If this can be done is there some features or subfeatures that might not be available. Our goal is to support up to serveral hundred power users. this implies the ability to create Crystal Reports.
Title: Mr   
Name: Todd Gen
Date: 2011-02-23 2:59:07 PM
Awesome tips... Found very useful... Some others I find helpful are at
Title: Other Fonts Too   
Name: Greyhound
Date: 2010-08-18 10:42:36 AM
GREAT!!! This opens the door to other symbols just by selecting other fonts. Thanks.
Title: DME Officer   
Name: Waqas
Date: 2010-08-03 8:06:07 AM
When i entered above mentioned formula in crystal report 10 this gave me an error of "string missing". Please advice me that how can i get rid from this problem and can use this formula. Thanks a lot...
Title: Tricks   
Name: Crystal report designer
Date: 2010-08-02 2:37:06 AM
Thanks a lot for the valuable information
Title: Six Quick Crystal Reports Design Tips   
Name: Vikas rathore
Date: 2010-07-28 8:56:38 AM
Nice tips thanx
Title: Copy watermark   
Name: Priya
Date: 2010-05-03 1:28:44 AM
Thats a nice article with simple explanation
Title: Watermark   
Name: kevin rogers
Date: 2009-11-25 4:35:03 AM
really helped thanks
Title: Getting picture to underlay horizontal lines   
Name: Steve
Date: 2009-10-05 10:04:16 AM
In figure 16, the horizontal lines get stuck "behind" the watermark. It seems that lines will do this, but the borders on text boxes do not. If you need a horizontal line, just create an empty text box and give it a top or bottom border, then put it where you need the horizontal line to appear.
Title: How can I change a date to the corresponding number?   
Name: Jay Thompson
Date: 2009-10-02 9:45:41 AM
I have this formula:

It produces this:

I would like for it to produce this:

I get the "13" once I export it to excel and reformat it to a number, but would like to get it to that number while it is in Crystal. How can I do this?
Title: Check Boxes   
Name: Joe
Date: 2009-08-13 4:21:47 PM
This method is solid. The only problem I have is that when you are is design mode you see a string of wingdings not the check boxes.

In management reports that may not be to large of an issue. But if you are designing legal documents for example, you have 7 check boxes that are independently data driven. In design mode the layout would be confusing b/c you are not seeing the boxes, the layout takes longer, and maintining the doc long term may not be as easy.

This is how I do it. I too use the wingdings mentioned. I create a text field. I go the character map tool and select check box, then click select and copy. Now go back to CR, copy the clipboard into the text box. Do the same for the blank box to. So now have 2 new text boxes with box/chkbox. Position the blank box first. Once it is where you want it, right click and select Size and Position, note the X / Y coordinates and cancel. Now right click on the chkbox, and select X / Y coordinates. Enter the X / Y coordinates noted from the blank box. The last thing to do is add suppression logic to turn on/off the check box text fied. You don't have to add suppression logic to the blank box. It sits right under the chkbox, the size is controld by the Font sizer.

Also make it a little wider the the chkbox text box so that you will be able to select if you need to.

Hopes this helps.

Joe Cigno is a Crystal Reports developer with 15 years experience. He is availabe for contract work and support
Title: Shared Variables   
Name: Pieter
Date: 2009-07-20 4:20:51 AM
Hi, we would like to put a sub report into a sub report, but that's OK- the problem is putting Shared Variables in the report to read from sub reports into sub reports.
Title: Cygnet   
Name: .net development
Date: 2009-07-04 2:55:59 AM
Great Post! Really very useful information is given. Thanks for sharing.
Title: A new Crystal Report Learner   
Name: kim
Date: 2009-04-29 5:19:58 AM

I am a new to Crystal Report. I dont know how to create and design a report (.rpt)file for I dont know wich software or tools to create and design a Crystal Report. I am using Visual Studio6 for programming interface.

Please help me out with these things.

Thank you
Title: problem in gorup, afnd formulla in crystal report   
Name: subrat
Date: 2009-04-28 2:04:42 AM
i've problem in Group field, formulla fiels of crystal report.
How to create and set group in crystal report
How to create and set formulla field in crystal report.
i've make a project using,sqlserver and maked connection between frontend and backend and also maked a connection to crystal report but i dont know how to set gorup field , how to set formulla field, how to calculate total field, average,sum....etc.

so i need your help to solve my problem
Subrat kumar sar
United Arab Emirates
Title: Display String   
Name: Imran
Date: 2009-04-22 3:46:58 AM

I'm similar problem, but I need to see one text field only in some cases for example.
if {abc}= 5 then
{def}.visible = true
{def}.visible = false

Title: Crystal reports   
Name: Gopal
Date: 2009-02-28 6:06:44 AM
nice to learn
Title: dotnet Devoloper   
Name: haneefa
Date: 2009-02-07 12:15:00 AM
it is nice idea
Title: Make Crystal Reports   
Name: Uday
Date: 2008-12-23 4:57:17 AM
This artical is very helpful for us.
Title: The Putxi Project   
Name: Putxi
Date: 2008-11-22 7:17:45 PM
Very good article
Title: crystal reports   
Name: Vishal
Date: 2008-11-19 12:55:45 AM
good article
Title: Good article   
Name: RamkumarM
Date: 2008-11-03 5:47:46 AM
Very nice
Title: VP/CFO, CIO   
Name: Lee Pavis
Date: 2008-10-31 4:32:24 PM
New to Crystal and would like to see a demo with sample reports.
Title: Good Article   
Name: RD
Date: 2008-10-10 4:16:23 PM
Informative article, with easy to understand examples. Great job.
Title: Thanks for the info   
Name: KA
Date: 2008-09-20 10:50:50 AM
For all of the tips these will be very usful,and defenitly ones I didn't know about. Its always nice to learn something new, keep up the good work!
Title: Thank for sharing youe EXP   
Name: thanan
Date: 2008-09-17 4:16:47 AM
Great tips
Title: Watermark   
Name: gavin
Date: 2008-08-11 1:19:01 AM
On Figure 16, the watermark does not underlay the lines in the detail secion of the report. Is there a way to make this happen?
Title: Crystal Report through click on gridview button   
Name: Saqib
Date: 2008-08-08 12:30:25 AM

I am using VS-2005 for creating my website.

My records display in gridview, and I created a link button name "PreviewQuotation" on gridview row for each record . On the other side I created a page to use crystal report viewer to show the selected record of the Gridview Row.

But I have no idea how to pass my Primary Key field value to Crystal Report page to preview the particular row recod when click on "PreviewQuotation" button on gridview.

Saqib Malick
Title: Helpful Article   
Name: Dulce Bautista
Date: 2008-08-01 10:28:58 AM
Great tips!
Title: using templates/background images for reports   
Name: sixela
Date: 2008-06-25 4:32:07 AM
hi all, will it be possible to use templates/background images in previewing a report, but excluding it from printing? can i ask for references in suppressing sections through code? since watermarking images in reports might be one way to solve this problem...thanks!
Title: Working in Crystal report 8.0   
Name: JP
Date: 2008-06-23 8:36:38 AM
I am using crystal report ver 8.0
I tried this but 'FORMAT EDITOR DISPLAY STRING" is not available. Could anyone suggest how it is possible???
Title: Crystal report 8,8.5,10 version   
Name: JP
Date: 2008-06-23 8:31:18 AM
Does it work in crystal report 8.5 version? I didn't get
Name: Din
Date: 2008-06-12 10:37:08 AM
The solution is working in the design time of crystal reports, but when I viewed it CrystalReportViewer control in it shows the strange symbol perhapes it is not applying the wingding font in
Any solution for that?
Title: Its Good article   
Name: Mukunda
Date: 2008-06-04 5:36:10 AM
It's really a good article, add some more examples

Title: Its very nice one   
Name: Jyotsna
Date: 2008-05-29 7:23:08 AM
feeling good abt this article..very helpful
Title: Crystal report   
Name: Velika
Date: 2008-05-25 4:07:08 PM
Thanks for this very helpful article.
Can you tell me how to count the record number(or groupnumber) for any group like this:
Please help.
Title: Good   
Name: Rajani
Date: 2008-05-22 6:53:02 AM
It was good for desinging crystal reports in different way
Title: Good one   
Name: sneha
Date: 2008-05-15 8:34:19 AM
Good one for the beginners....
Thanks it helped me too.
Title: Super   
Name: saima
Date: 2008-05-11 6:57:38 AM
Its really super jeff. very helpful
Title: Six Quick Crystal Reports Design Tips   
Name: Shohagh
Date: 2008-04-24 1:04:15 AM
ThankS for such an important post. It will help me designing a Crystal Report... ... ...
Title: Mr.   
Name: allanamk
Date: 2008-04-18 4:44:42 PM

I tried that check box from the Windings in the Boolean format field -string formula from common tab...But still shows me 0 in the preview screen

Title: Mr.   
Name: allanamk
Date: 2008-04-18 2:17:43 PM
This is really nice support to novice and vatirans.

Title: Six Quick Crystal Reports Design Tips   
Name: saaden
Date: 2008-04-17 6:28:14 AM
I need to start,so
It's really a good starting step.
Title: Tips on Crystal Reports   
Name: John
Date: 2008-04-16 10:39:38 AM
Great tips thanks.
Title: Thanks   
Name: Mukunda
Date: 2008-04-15 11:21:18 PM
Its good article,it's helps me.
Title: Thanks   
Name: Narendra
Date: 2008-04-02 9:13:27 PM
It's really a good article,it's helps both beginers and develeopers
Title: Thank you   
Name: Ajeet
Date: 2008-03-28 11:07:08 AM
Thanks Jeff, that was helpful.
Title: Crystal Report   
Name: Janu
Date: 2008-03-25 7:08:22 AM
Title: Crystal Report   
Name: Seema
Date: 2008-03-24 6:14:46 AM
It is really excellent.
Title: version of CR?   
Name: Eric Moreau
Date: 2008-03-11 8:04:22 PM
Which version of Crystal Reports your article is focusing on? The one provided with VS2008?

Product Spotlight
Product Spotlight 

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2024  |  Page Processed at 2024-07-23 12:59:02 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search