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

Step 1: Create the Database

1.    Open SQL Server Management Studio 2008 and connect to your server.

2.    Create a new database and name it CrystalFormulas.

3.    This database will contain only one table called SalesHeader. Create this table with the following fields.

Field Name


Allow Nulls


Int (Identity)








I pre-populated this table with records for January through June.  You can download the script to create this table and the seed records here.  You can run this script in SQL Management Studio to build the table and insert the records or you can comment out the creation of the table and just run the insert statements if you created the table manually.

You can use either Integrated Security when connecting to this database or create a SQL Login.  Either way you need to remember which method you used when you are ready to connect to the database as defined in the steps below.

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