In the world of ASP.NET I have run across many applications based on the .NET Framework applications, such as DotNetNuke, Rainbow Portal and others.  One that I have watched since the early days was .TEXT. In recent years, the company Telligent has taken .TEXT, the ASP.NET Forums, and nGallery and combined them to create the Community Server product.  They now include an Express edition which is a free version.  There are other versions with more features that cost money. 

This product contains a blog engine, a photo gallery and a forum product.  Community Server (CS) can be utilized as a customer support option.  For this article, let us assume that is how we are utilizing CS.  We will create a forum for customer support and then we will create a report showing how many unanswered posts are in one forum.  Instructions on setting up Community Server and creating the forums are beyond the scope of this article.  Please see the community server forums for any assistance on setting CS up.

System Requirements

ASP.NET 2.0

Community Server 2.0 Express Edition

SQL Server 2000

Crystal Reports XI