Six Quick Crystal Reports Design Tips
page 1 of 9
Published: 27 Feb 2008
Abstract
Creating reports can be a daunting task. Reports can demand a great deal of effort and time, especially if you have not worked with Crystal Reports much. In this article, Jeff provides six quick Crystal Reports Design Tips to assist in creating killer reports with style and speed. Among other tips, you will learn how to add WaterMarks to your reports. Each tip has been deeply examined with the help of relevant explanations and screenshots for better understanding.
by Jeff McWherter
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 26130/ 790

Introduction

I have found myself working on projects where reports have been last minute additions that demanded a great deal of time and a certain touch of detail. Many times, reports are cobbled together, with good design and performance falling to the wayside.  Reports are the primary representation of the data on your system; after putting so much hard work into the application that is collecting data it is important to put a little extra effort forth to design truly "killer" reports for your application.

The development tips in this article are primarily intended for developers without much experience with Crystal Reports.  This article assumes the reader has a basic knowledge of Crystal Reports data access.

We will cover six quick tips that will enable you to quickly create reports that are richly featured. We will start with a basic report that a manager of a project may ask for; order fulfillment. The following examples will be created from the SQL Server 2000 Northwinds Trading Company sample database. The sample report referenced throughout this article pulls data from the Orders, Customers, and Products tables. The report is intended to be a representation of a typical order fulfillment report. It groups orders together, and displays information about each product under the order. The examples below are using Crystal Reports 2008, but have also been tested with Crystal Reports XI.


View Entire Article

Article Feedback

Title:  
Name:  
Url: ( Optional )
Comment:  
Please add 3 and 2 and type the answer here:

User Comments

Title: crystal reports   
Name: Vishal
Date: 11/19/2008 12:55:45 AM
Comment:
good article
Title: Good article   
Name: RamkumarM
Date: 11/3/2008 5:47:46 AM
Comment:
Very nice
Title: VP/CFO, CIO   
Name: Lee Pavis
Date: 10/31/2008 4:32:24 PM
Comment:
New to Crystal and would like to see a demo with sample reports.
Title: Good Article   
Name: RD
Date: 10/10/2008 4:16:23 PM
Comment:
Informative article, with easy to understand examples. Great job.
Title: Thanks for the info   
Name: KA
Date: 9/20/2008 10:50:50 AM
Comment:
Thanks
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: 9/17/2008 4:16:47 AM
Comment:
Great tips
Title: Watermark   
Name: gavin
Date: 8/11/2008 1:19:01 AM
Comment:
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: 8/8/2008 12:30:25 AM
Comment:
Hello,

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.

Regards,
Saqib Malick
Title: Helpful Article   
Name: Dulce Bautista
Date: 8/1/2008 10:28:58 AM
Comment:
Great tips!
Title: using templates/background images for reports   
Name: sixela
Date: 6/25/2008 4:32:07 AM
Comment:
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: 6/23/2008 8:36:38 AM
Comment:
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: 6/23/2008 8:31:18 AM
Comment:
Does it work in crystal report 8.5 version? I didn't get
Title: ASP.net   
Name: Din
Date: 6/12/2008 10:37:08 AM
Comment:
jeff,
The solution is working in the design time of crystal reports, but when I viewed it CrystalReportViewer control in aps.net it shows the strange symbol perhapes it is not applying the wingding font in aps.net.
Any solution for that?
thanks,
Din
Title: Its Good article   
Name: Mukunda
Date: 6/4/2008 5:36:10 AM
Comment:
It's really a good article, add some more examples

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

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


Thanks
Title: Mr.   
Name: allanamk
Date: 4/18/2008 2:17:43 PM
Comment:
This is really nice support to novice and vatirans.

Thanks
Title: Mr.   
Name: Mahmoud allan abu_Samra
Date: 4/18/2008 2:17:11 PM
Comment:
This is really nice support to novice and vatirans.

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

Product Spotlight
Product Spotlight 
Learn More
.NET Tools
asp.net shopping cart
asp.net chart control



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


©Copyright 1998-2008 ASPAlliance.com  |  Page Processed at 11/22/2008 6:49:18 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search