SELECT TOP (100) PERCENT dbo.yaf_Forum.Name, dbo.yaf_Topic.Topic, dbo.yaf_Message.Message, dbo.yaf_Message.TopicID, dbo.yaf_Message.Position, dbo.yaf_Message.MessageID, dbo.yaf_Message.IsDeleted,

yaf_User_1.Name AS Message_username, dbo.yaf_User.Name AS Expr1, dbo.yaf_Topic.Views, dbo.yaf_Message.Posted, dbo.yaf_Forum.ForumID

FROM dbo.yaf_Forum INNER JOIN

dbo.yaf_Topic ON dbo.yaf_Forum.ForumID = dbo.yaf_Topic.ForumID INNER JOIN

dbo.yaf_Message ON dbo.yaf_Topic.TopicID = dbo.yaf_Message.TopicID INNER JOIN

dbo.yaf_User ON dbo.yaf_Topic.UserID = dbo.yaf_User.UserID INNER JOIN

dbo.yaf_User AS yaf_User_1 ON dbo.yaf_Message.UserID = yaf_User_1.UserID

WHERE (dbo.yaf_Message.IsDeleted = 0)

ORDER BY dbo.yaf_Forum.Name, dbo.yaf_Topic.Topic, dbo.yaf_Message.Posted, dbo.yaf_Message.Position

The BIRT report is attached.

The best output is as a PDF. Changes need to be made to the view to remove illegal characters for .docx and .html files. Excel also works, but the nicest output is in PDF... I recommend turning on table of contents.

http://marinetteboat.net/docs/BoatandEngine.pdf