Building Reports Using ASP.NET and Crystal Reports - Part 6 - Build a Sales Forecast Report Using Parameter Fields: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Building Reports Using ASP.NET and Crystal Reports - Part 6 - Build a Sales Forecast Report Using Parameter Fields

page 9 of 12

by Vince Varallo
Feedback

Average Rating:

Views (Total / Last 10 Days): 56661/ 76

Article Contents:

Step 8: Add the selection formula

The next step is to add the selection formula so the report only selects the data between the start and end dates entered by the user.

1. From the Crystal Reports menu in Visual Studio select ReportàSelection FormulaàRecord…

2. Enter the following formula.

{SalesOrderHeader.OrderDate} >= {?Start Date} and 
      {SalesOrderHeader.OrderDate} <= {?End Date}
The parameter fields can be used in a formula by using the {?Start Date} and {?End Date} syntax.

3. Click Save and close.

« (Page 8)

View Entire Article

(Page 10) »

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