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
Average Rating: 
Views (Total / Last 10 Days): 63149/ 80

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.

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:21:35 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search