Building Reports Using ASP.NET and Crystal Reports - Part 6 - Build a Sales Forecast Report Using Parameter Fields
page 7 of 12
by Vince Varallo
Average Rating: 
Views (Total / Last 10 Days): 63149/ 81

Step 6: Create the Forecast Sales cross tab

The next step is to create the cross tab that displays the data with the Sales Forecast Factor applied.

1.    Right click the Report Header1 section header. Select Insert Section Below from the pop-up menu.

2.    Right click in ReportHeaderSection1 and select InsertàCross Tab… from the pop-up menu.

3.    The Cross Tab Expert should appear.  Click on the Forecast formula field in the Available Field listbox.  Click the > button next to the Summary Fields listbox.

4.    Expand the SalesTerritory table in the Available Fields list and click on the CountryRegionCode field.  Click the > button to the left of the Rows listbox.

5.    Click the Name field under the SalesTerritory table and click the > button to the left of the Rows listbox.

6.    Scroll up to the OrderDate field under the SalesOrderHeader table in the Available Fields listbox.  Click the > button to the left of the Columns listbox.

7.    Click on the Group Options button under the Columns listbox.

8.    In the "The column will be printed:" dropdown select "for each quarter." and click the OK button.

9.    Click the OK button.  The cross tab will appear in the ReportHeaderSection1 section.

10. Change the font for the summary field to regular and resize the fields as you did in Step 5.

View Entire Article

User Comments

Title: Help   
Name: Arjun
Date: 2010-05-21 4:28:35 AM
Hi! anybody body can assit me to generate Accouting report trial balance, profit & loss, and balance sheet. using crystal report with ASP.NET with C#
Title: Nice Article   
Name: Rick
Date: 2009-12-01 4:56:29 PM
I read the entire series and I fell more comforable with reports. They were all put together well and every piece of code worked as expected. Thank for taking the time to share.

Product Spotlight
Product Spotlight 

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

©Copyright 1998-2021  |  Page Processed at 2021-12-04 6:25:29 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search