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

Step 3: Create the parameter fields

There are three parameter fields for this report.  The first is the forecast sales factor parameter.  This is the percentage applied to the original sales amount.  The second and third parameters are the start and end dates that should be used to filter the report.  Only records with an order date between the start and end date will be used to forecast the sales amount.

1.    Right click on the ParameterFields node in the FieldExplorer and select New… from the pop-up menu.

2.    Enter "Sales Forecast Factor" for the name.

3.    Enter "Enter the percentage to be applied." for the description.

4.    Select Number for the Value type.

5.    Click the OK button.

6.    You should now see a plus sign next to the ParameterFields node in the Field Explorer.  Click the plus sign to see the new parameter field you just created.

7.    Right click on the ParameterFields node in the FieldExplorer and select New… from the pop-up menu.

8.    Enter "Start Date" for the name.

9.    Enter "Enter the start date." for the description.

10. Select Date for the Value type.

11. Click the OK button.

12. Right click on the ParameterFields node in the FieldExplorer and select New… from the pop-up menu.

13. Enter "End Date" for the name.

14. Enter "Enter the end date." for the description.

15. Select Date for the Value type.

16. Click the OK button.

All three parameter fields should now appear under the ParameterFields node in the Field Explorer.


View Entire Article

User Comments

Title: Help   
Name: Arjun
Date: 2010-05-21 4:28:35 AM
Comment:
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
Comment:
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-2024 ASPAlliance.com  |  Page Processed at 2024-04-19 10:31:10 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search