I'm trying to use the report and/or ReportGrid (not core moduel) to report on postings in several forums.  I'm guessing somebody else has done this before so thought I'd just ask before venturing out.

Basically, I can easily report on some data in the forums using something like:

select ff.ForumID, ft.ThreadID, ff.Name, fp.Subject, fp.Body
from forum_forums ff
inner join forum_threads ft on ft.forumid=ff.forumid
inner join forum_posts fp on fp.threadid = ft.threadid
where Name like 'Feature Requests' and ff.ForumID=13 and ft.ThreadID=16

To get at data I want with whatever restriction needed.  What I'm looking for is a way to easily render the data in the Body field into HTML that can be displayed easily in reporting module.  The data looks like:

<p>Here are some report ideas from a recent prospect RFP for re-usable container area.</p>
<p>
<table style="margin: auto auto auto -1.15pt; width: 354pt; border-collapse: collapse" cellspacing="0" cellpadding="0" width="590" border="0">
    <tbody>
        <tr style="height: 14.25pt">
            <td style="border-right: #f0f0f0; padding-right: 5.4pt; border-top: windowtext 1pt solid; padding-left: 5.4pt; padding-bottom: 0in; border-left: windowtext 1pt solid; width: 28pt; padding-top: 0in; border-bottom: windowtext 1pt solid; height: 14.25pt; background-color: transparent" valign="top" nowrap="nowrap" width="47">
            <div style="margin: 0in 0in 0pt" align="right"><strong><em><span style="font-size: 11pt">157</span></em></strong></div>
            </td>

So is there a stylesheet I could grab from somewhere that would easily format this back into HTML for rendering?  Thought it might save me some time.

Thanks!

Reasonable question.  Since I was trying to report on data stored in the forum database, I was hoping somebody had some experience doing that (Report Module was just an example I thought people would be familiar with).  The forum data doesn't appear to be stored in a way that I can easily summarize in output via a SQL query, so I have to reformat it.  Looks like I'll have to reverse the HTML rendering process which is not a huge thing but still inconvenient.  So was just looking to see if anybody else had done any other reporting or summary forum postings (whatever mechanism).  What I'm trying to do is sort through posts (parent level) and list them out for analysis.

Tx,
Ron

Example of forum report: http://components.init.si/HelpTutorials/SamplescriptForumreport/tabid/243/Default.aspx

Kind regards,

Primoz