If you like to changed the view order, you can change the stored procedure
Blog_ListEntriesByPortal
Have a look at the end of the following SQL script.(ORDER BY)
CREATE PROCEDURE dbo.Blog_ListEntriesByPortal
@PortalID int,
@BlogDate datetime = null,
@ShowNonPublic bit = 0,
@ShowNonPublished bit=0,
@MaxEntries int = 10
AS
If @BlogDate IS NULL SET @BlogDate = GetUTCDate()
SET rowcount @MaxEntries
SELECT
U.[UserID],
U.[Username],
U.[FirstName] + ' ' + U.[LastName] AS UserFullName,
E.[EntryID],
E.[BlogID],
E.[Title],
E.[Description],
E.[Entry],
E.[AddedDate],
E.[Published],
E.[Copyright],
E.[PermaLink],
IsNull(E.[AllowComments],B.[AllowComments]) As AllowComments,
B.[ParentBlogID],
B.[AllowAnonymous],
B.[Syndicated] AS BlogSyndicated,
B.[Public] AS BlogPublic,
(Select Count(*) FROM dbo.Blog_Comments WHERE EntryID = E.EntryID AND (Approved = 1 OR Approved <> @ShowNonPublic)) As CommentCount
FROM dbo.Blog_Blogs B INNER JOIN
dbo.Blog_Entries E ON B.[BlogID] = E.[BlogID] INNER JOIN
dbo.Users U ON B.[UserID] = U.[UserID]
WHERE B.PortalID = @PortalID AND E.AddedDate <=@BlogDate
AND (E.[Published] = 1 OR E.[Published] <> @ShowNonPublished)
AND (B.[Public] = 1 OR B.[Public] <> @ShowNonPublic)
ORDER BY E.AddedDate DESC
GO
regards
HP