Missing fields

See more:

C#

SQL

Hi guys,
i am workin on a .NET application that rates team leader or supervisor based on a set questions presented in a questionnaire form. Basically ther about 40 questions and im supposed to come with averages for each question and then be able to generate a report. The user has to supply the team leader name and from this a report is generated. The report is divided into different categories of people who have rated the team leader so we have personal accountability, acting with intergrity, building relationships etc. From this i decided that using a stored procedure would be an ideal solution as it can accept parameters and i cud use this to filter the data depending on who is being rated so the procedure was created as follows

CREATE PROCEDURE dbo.spFeedbackReport
@leader nchar(10) AS
BEGIN
    /* AvgQ26 and AvgQ30 are views that i created */
    SELECT (dbo.AvgQ26.Q26 + dbo.AvgQ30.Q30) / 2 AS [Personal Accountability]
    FROM dbo.AvgQ26 CROSS JOIN 
dbo.AvgQ30
    WHERE (dbo.AvgQ26.LeaderID = @leader) AND (AvgQ26.Rater = 'Line Manager')
END
BEGIN
    SELECT AVG(AvgQ11.Q11) AS [Acting with Intergrity]
    FROM AvgQ11
    WHERE (AvgQ11.LeaderID = @leader) AND (AvgQ11.Rater = 'Line Manager')
END

the procedure goes on for another couple of select statements but the two are sufficent to show my problem. So when i create a report using microsoft report viewer im presented with a wizard where i choose the source nd i choose spFeedbackReport but only personal accountability is listed the rest of the select statements are simply not there. I tested the procedure directly from sql express (im using sql server express 2005) and it returns all of them so what im I doing wrong?