I use several Announcements on the same portal.
I'd like to display the top 3 Announcements on my homepage (with a link).

I know nothing about SQL.
Can I begin with...

SELECT TOP 3

Title,

Description

FROM

Announcements

WHERE

PortalID=4

ORDER BY

PublishDate DESC

---

DNN skins Forums
using Tressleworks modules
DNN & webhosting

Bill,

A link to which page? The page where you display ALL of the Announcements? Simply find the URL of that page and use either an XSL or HTML template output for that.

Or are you wanting the title to link to the full text of the selected announcement? In that case, you'd need to use another Report module and use QueryStrings to pull up the desired announcement.

You may find it easier to use a different module for this. The Repository module or Ventrian News Articles module (www.ventrian.com) are ones that immediately spring to mind. The Form & List module might also suit your needs.

Bill,

If I were looking for a free solution, I'd probably go with the Form & List module. The settings of the Report module are only accessible to the Host user, while a portal Administrator COULD adjust F&L module settings.