Hey Paul,

You might want to try creating the view within Query Analyser, saves you from the graphical designer errors.  The first error was raised because the graphical designer doesn't require the USE DATABASE statement - you've already specified the DB because you were in one and selected 'create new view'.  The second error is as you guessed - the graphical designer doesn't support case statements graphically but it doesn't stop you from using them - you just don't get a 'picture' ofyour query (ie the tables and the joins aren't shown like in a straight select).

THe last error is strange, every column has an alias in the query i posted, so i'm not sure how/where the columns lost their aliases.  You may want to take the entire script and paste it into query analyser.  To create the view, between tthe USE DATABASE ... GO statement and the start of the select, add the create view statement like CREATE VIEW vwMySnazzyView AS

so a short version of creating the view to give you an idea of the entire structure read s like ->

use database ReportServer

go

create view mySnazzyView AS

select top 5 * from ReportSchedule