Creating a Crystal Report for Community Server
page 3 of 4
by Eric Landes
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 19326/ 81

Creating the report

Let us walk through the initial steps used to create this report.  Initially I used the new report Wizard.  In stepping through it for the new connection, select the OLEDB connection for SQL Server.  For this report the server name is (local) and the catalog is CommunityServer.  Once we create the connection, we can select the stored procedure.  I have included the stored procedure and crystal report on the code download file. 

To highlight the numbers that have not been answered, a chart has been created.  Below is a sample of that Chart which shows how many replies we have in each forum.  We could show the total in a different manner by stacking the totals using a bar stack format.

Figure 2

Below the chart is the grouping of the data.  It is grouped by Section and within ThreadID.  This keeps replies together (if you would like to include the replies with this report in a later version).  There is also a grouping section that includes counts of some type if necessary. 

This report also has a section parameter called SectionID.  This parameter is set to multiple values.  The record selection for the report filters by the SectionID parameter. The record selection filter also includes a filter on the NumberOfReplies.  We only want NumberOfReplies to equal 1 since that indicates that there is only one post.


[Download Sample]

View Entire Article

User Comments

No comments posted yet.

Product Spotlight
Product Spotlight 

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

©Copyright 1998-2024  |  Page Processed at 2024-05-28 10:32:31 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search