If you installed Visual Studio 2010 you probably noticed something missing.  Yes, Crystal Reports is no longer installed as part of Visual Studio 2010.  But fear not, it didn't disappear.  It just needs to be downloaded separately.  The BETA for SAP Crystal Reports for Visual Studio 2010 can be downloaded here.  The production ready version is due out sometime in summer 2010.  Once you download and install it, it will appear in Visual Studio 2010 just like you are used to. 

One of the nice new features in the report viewer control is that reports can now be sorted dynamically by the end user.  There is also a new parameter panel that is displayed in the viewer control that allows the user to easily change parameters on a report.  Another nice feature is that the user can dynamically filter data once it has been retrieved from a database.  This article will review these new features with example code using the AdventureWorks sample database provided by Microsoft.  You can download the AdventureWorks database here.  Once you've installed the database you need to create a SQL Login that the ASP.NET application can use to connect to the database.  My sample code expects a SQL Login to be called "aspalliance" and the password should be set to "aspalliance".