Timeline view won't render

[Varp]

I have a requirement to produce a year planner.  This will show employee roles as resources (e.g. Programmer, Test Engineer, Project Manager) and a headcount on a month-by-month basis.  I need the scheduler to show a line for each resource whether it has any appointment data or not.

In Design view I can get Day, Week and Month views to render, however Timeline view shows "error rendering the control".

At runtime the timeline view will render, but shows no resources data, just the navigation bar and timescale.  I also get no data rendering at runtime for any other view either (day, week, month). 

The Scheduler is filtered by a value selected from a combobox.

I have three SQL datasources, one for the grouping, one for the data and one for the combobox.

Combobox:

    <asp:DropDownList ID="ddProject" runat="server" DataSourceID="sdsProjects" DataTextField="Project"
        DataValueField="idProject" AutoPostBack="True">
    </asp:DropDownList>
    <asp:SqlDataSource ID="sdsProjects" runat="server" ConnectionString="<%$ ConnectionStrings:SkillsDB %>"
        SelectCommand="usp_Project_Select" SelectCommandType="StoredProcedure"></asp:SqlDataSource>

Scheduler:

        <telerik:RadScheduler ID="rsResourceProfile" runat="server" DataEndField="dteEndDate" DataKeyField="idResourceProfile" DataRecurrenceField="RecurrenceRule" DataRecurrenceParentKeyField="RecurrenceParentID" DataSourceID="sdsResourceProfile" DataStartField="dteStartDate" DataSubjectField="numHeadcount" Skin="Vista" GroupingDirection="Vertical" GroupBy="idProjectRole" ShowViewTabs="true" OverflowBehavior="Expand" Culture="English (United Kingdom)" DayEndTime="08:00:00" MinutesPerRow="1440" MonthVisibleAppointmentsPerDay="50" WorkDayEndTime="00:00:00" WorkDayStartTime="00:00:00" SelectedView="TimelineView">
            <TimelineView SlotDuration="30.00:00:00" HeaderDateFormat="MMMM yyyy" NumberOfSlots="12" GroupBy="idProjectRole" GroupingDirection="Vertical" />
        <ResourceTypes>
            <telerik:ResourceType KeyField="idProjectRole" Name="Role" TextField="Role" ForeignKeyField="idProjectRole" DataSourceID="sdsProjectRole" />
        </ResourceTypes>
            <MonthView VisibleAppointmentsPerDay="50" />
        </telerik:RadScheduler>

Data & Grouping Datasources:

    <asp:SqlDataSource ID="sdsResourceProfile" runat="server" ConnectionString="<%$ ConnectionStrings:SkillsDB %>" DeleteCommand="usp_ResourceProfile_Delete" DeleteCommandType="StoredProcedure" InsertCommand="usp_ResourceProfile_Insert" InsertCommandType="StoredProcedure" SelectCommand="usp_ResourceProfile_Select_ByProject" SelectCommandType="StoredProcedure" UpdateCommand="usp_ResourceProfile_Update" UpdateCommandType="StoredProcedure">
        <SelectParameters>
            <asp:ControlParameter ControlID="ddProject" DefaultValue="-1" Name="idProject" PropertyName="SelectedValue" Type="Int32" />
            <asp:ControlParameter ControlID="rsResourceProfile" DefaultValue="" Name="dateStartRange" PropertyName="VisibleRangeStart" Type="DateTime" />
            <asp:ControlParameter ControlID="rsResourceProfile" Name="dateEndRange" PropertyName="VisibleRangeEnd" Type="DateTime" />
        </SelectParameters>
        <InsertParameters>
            <asp:Parameter Name="idProjectRole" Type="Int32" />
            <asp:Parameter Name="dteDate" Type="DateTime" />
            <asp:Parameter Name="intMonth" Type="Int32" />
            <asp:Parameter Name="intYear" Type="Int32" />
            <asp:Parameter Name="numHeadcount" Type="Int64" />
        </InsertParameters>
        <UpdateParameters>
            <asp:Parameter Name="idResourceProfile" Type="Int32" />
            <asp:Parameter Name="idProjectRole" Type="Int32" />
            <asp:Parameter Name="dteDate" Type="DateTime" />
            <asp:Parameter Name="intMonth" Type="Int32" />
            <asp:Parameter Name="intYear" Type="Int32" />
            <asp:Parameter Name="numHeadcount" Type="Int64" />
        </UpdateParameters>
        <DeleteParameters>
            <asp:Parameter Name="idResourceProfile" Type="Int32" />
            <asp:Parameter Name="idProjectRole" Type="Int32" />
            <asp:Parameter Name="dteDate" Type="DateTime" />
            <asp:Parameter Name="intMonth" Type="Int32" />
            <asp:Parameter Name="intYear" Type="Int32" />
            <asp:Parameter Name="numHeadcount" Type="Decimal" />
        </DeleteParameters>
    </asp:SqlDataSource>
    <br />
    <asp:SqlDataSource ID="sdsProjectRole" runat="server" ConnectionString="<%$ ConnectionStrings:SkillsDB %>"
        SelectCommand="usp_ProjectRole_Select_ByProject_Grouping" SelectCommandType="StoredProcedure">
        <SelectParameters>
            <asp:ControlParameter ControlID="ddProject" Name="idProject" PropertyName="SelectedValue"
                Type="Int32" />
        </SelectParameters>
    </asp:SqlDataSource>

Not sure if the two problems are related to each other, but any assistance would be greatly appreciated.

[Yana]

Hello Varp,

Thank you for contacting us.

You should set the GroupBy property of RadScheduler to the name of the resource, in your case it is "Role".
Please check our online example about resource grouping.

Greetings,
Yana
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.