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.
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.