Stump the Panel: SharePoint Q&A

We have two sites set up:
1) "Home". This is a main page with announcements, events calendar, useful links, documents, etc. Website = /CommunityTest/default.aspx
2) "Insight Blog". This is a blog page with topics, posts, archived posts, etc. Webiste = /CommunityTest/InsightBlog/default.aspx

There are tabs at the top of the page with both of the sites.

On the "Insight Blog" page, we've been able to create a Web Part that displays the most current blog. This was easy enough by setting the View to <Current View>.

In order to entice people to go to the Blog, we would like to have this most current post on the "Home" page as well. Since this main page is not a blog page, I'm finding it difficult to get just the post into a Web Part. I've tried several web pages as a Link for the Web Part:
1) /spn/CommunityTest/InsightsBlog/default.aspx. This shows the whole site.
2) /spn/CommunityTest/InsightsBlog/Lists/Posts. This shows all posts.
3) /spn/CommunityTest/InsightsBlog/Lists/Posts/Post.aspx?ID=13. This shows the post, but the whole site of the post.

Essentially, I would like this web part to look just like the Web Part on the "Insight Blog" page.

Any ideas on how to do that?

There are a few options that come to mind; data view web part, content query web part, page viewer web part, RSS.

Data View - don't seem to have this type.

Content Query - This doesn't work as it isn't a data file and we can't readily extract the information into a table.

Page Viewer - this is what we tried before where we could only view the entire web page

RSS - is that using an XML type of web part?


Again, we only want to see the original post of the newest post; no comments. This I think negates the Page Viewer idea completely.

Data views web parts are built in Sharepoint Designer. Content Query can roll up blogs, you just have to point it at the Posts content type. Page viewer web part could work with some tinkering in SPD so that the page only contains the minimum amount of information needed. Using either the RSS viewer web part or the XML web part to display the data.

BTW, I was able to do this with Sharepoint Designer, where we pulled in the post data source from the subsite. Works like a charm!