Well, I thought I'd tidy it up from being lots of views, and created a stored procedure. This now includes - Announcements, Events, Forums, NewsArticles, SimpleGallery and Wiki.

Cheers
Roger

Thanks Roger,

This has definatly given me a better way to do the whats new. I have wrote up the section for capturing blog info as well I figured I would post it here so if anyone wanted to add this.  Along with the code below being added to the create procedure you would also need to add @BlogRows = X, to the Report Query

 INSERT
        INTO    #WhatsNew
                (
                        Title        ,
                        Description  ,
                        PubDate      ,
                        Link         ,
                        Userid       ,
                        ModuleID     ,
                        LinkType     ,
                        ImageURL     ,
                        ImageLinkType,
                        ImageHeight  ,
                        ImageWidth
                )
        SELECT  top (@BlogRows) dbo.blog_entries.title,
                dbo.udf_HTMLDecode(dbo.blog_entries.description) AS Description,
                dbo.blog_entries.AddedDate AS PubDate,
                dbo.blog_entries.PermaLink AS Link,
                dbo.blog_blogs.userid ,
                '360'  AS ModuleID ,
                'http' AS linktype ,
                NULL   AS ImageURL ,
                'None' AS ImageLinkType ,
                ''     AS ImageHeight ,
                ''     AS ImageWidth
        FROM    blog_entries
                INNER JOIN dbo.blog_blogs
                ON      dbo.blog_blogs.blogid =dbo.blog_entries.Blogid
        WHERE   [dbo].[blog_blogs].[Public] <> 0
        ORDER BY pubdate DESC