Building Reports Using ASP.NET and Crystal Reports - Part 2 - Quarterly Sales Report
page 8 of 15
by Vince Varallo
Feedback
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 16495/ 635

Step 7: Format the Cross Tab

You can adjust the size or font of any of the fields in the cross tab. By default, the summarized fields for the column and row totals are bold. Since we are summarizing a money field Crystal already formatted the numbers with a currency symbol and two decimals. For this report we want to remove the two decimals and make it a regular font instead of bold To do this, follow these steps.

1.    Hold the Ctrl key down and left click on the summary fields.

Figure 9

2.    Right click on any of the fields and select Format Multiple Objects from the pop-up menu.

3.    The Format Editor Dialog box should appear.Click on the Font tab.

4.    Change the Style drop down list to Regular.

5.    Click the Number tab and change the Style to $1,123. This will remove the decimal places.  Click the OK button.

6.    The row header for this cross table is the employee's name. You will need to expand the width of the row header to avoid truncating the name. Simply click on the Row #1 Name field and drag the right window handle to the right. The Total field will automatically change its width as you change the width of the Row #1 Name field.


View Entire Article

Article Feedback

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

User Comments

Title: Awesome   
Name: Rusty
Date: 8/27/2009 10:36:14 AM
Comment:
Awesome job. I am a brand new CR user and I found your article to be easy to understand, follow, and very helpful. Thanks and keep them coming.
Title: Superb   
Name: ramakrishna
Date: 8/1/2009 6:51:52 AM
Comment:
This article is very good to customise my website,
Title: great work   
Name: Ankit Agarwal
Date: 7/28/2009 12:48:39 AM
Comment:
u have done a great work
this article is really helpful
Title: Great Job   
Name: yin min
Date: 7/26/2009 5:52:54 AM
Comment:
Thanks for your step by step article.
Everyone who is new at crystal are looking for such a simple and very useful article.
Thanks again.
Title: Well Done   
Name: Muhammad Aijaz Rajput
Date: 7/10/2009 10:47:53 AM
Comment:
This is an excellent article. Thanks. I realy need the detailed step-by-step article approach that you take.
Title: Source coming soon   
Name: Vince
Date: 6/22/2009 9:20:19 AM
Comment:
The source should be posted soon.
Title: Excellent   
Name: Walter
Date: 6/16/2009 4:03:31 AM
Comment:
Hi Vince,

another excellent article. Thanks. I really like the detailed step-by-step approach that you take.

Will the source be available as a download?

Regards

Product Spotlight
Product Spotlight 



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


©Copyright 1998-2009 ASPAlliance.com  |  Page Processed at 11/22/2009 5:39:15 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search