Using Variables Within Crystal Report Formulas
page 6 of 6
by Vince Varallo
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 98151/ 139


Formula fields in Crystal Reports really empower you to manipulate your data in a variety of ways when a simple select statement can't do the trick.  The syntax is quite simple to use if you already know C# or VB and the help documentation is packed with samples.  Crystal also has numerous built in functions that you can use in your formulas.  There are built in functions for standard deviation, variance, Nth Largest, Nth Smallest, amortization, fair value, trim, and uppercase just to name a few.  You can also use looping structures such as for, while, and do loops.  You can even find the previous or next value of a field.  The power of the formulas and scripting language is tremendous and can allow you to accomplish almost any requirements defined by even your toughest users.

View Entire Article

User Comments

Title: Very goo   
Name: Shivayogi
Date: 2011-09-08 11:26:19 PM
This code is helped me a lot
Title: Formula fields in Crystal Reports   
Name: Esha
Date: 2010-07-01 3:11:46 AM
Very Good and useful example
Title: Surge Consulting Group   
Name: Surge Consulting Group
Date: 2010-05-07 4:14:41 PM
Very very cool! Thanks for the example!
Title: Using Variables Within Crystal Report Formulas   
Name: pavani
Date: 2010-04-28 3:22:02 AM
simple and easy to understand article.When i tried to add crystal report template in my vs2008 i could not find it so do i need to restall my vs 2008 ?

Product Spotlight
Product Spotlight 

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

©Copyright 1998-2022  |  Page Processed at 2022-10-06 4:27:04 AM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search