Launch Visual Studio 2008 and select FileàNew
Web Site… from the menu.
Select the ASP.NET Web Site template. Set the Location to File System
and set the path to c:\Documents and Settings\YOURNAME\My Documents\Visual
Studio 2008\Projects\CrystalFormulas. Set the Language to C# and then click
the OK button. This will create the web site with the Default.aspx page and
the web.config file.
Right click on the project in the Solution Explorer and select Add New
Item… from the pop-up menu.
Select the Crystal Reports template and change the name of the file to
QuarterlySales.rpt. Click the Add button.
The Crystal Reports Gallery dialog will appear. Select the "As a
Blank Report" option and click the OK button. This will add the Crystal
Report file to your project and open up the Crystal Reports designer.
Now you need to connect to the database. Right click on the Database Fields
node in the Field Explorer and select Database Expert… from the pop-up menu.
The Database Expert dialog will appear. Click the plus sign next to
Create New Connection. Click the plus sign next to OLE DB (ADO). The OLE DB
(ADO) dialog box should appear.
Select SQL Native Client from the list of providers and click the Next
Enter your server name. You then have the option to either use a SQL
Login account to connect to the database of use integrated security. For this
example I'll use Integrated Security by checking the Integrated Security
the name of the database that was created in step 1, CrystalFormulas. Click
the Finish button.
should see the database listed under the OLE DB (ADO) node. Click the plus
sign next to the database to view the schemas. Click the plus sign next to dbo
to view the tables.
on the SalesHeader table and then click the > button to move this table to
the list of selected tables for this report.
the OK button.