This is a migrated thread and some comments may be shown as answers.

Timeline view won't render

1 Answer 90 Views
Scheduler
This is a migrated thread and some comments may be shown as answers.
Varp
Top achievements
Rank 2
Varp asked on 30 Jul 2008, 07:25 AM
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.


1 Answer, 1 is accepted

Sort by
0
Yana
Telerik team
answered on 31 Jul 2008, 10:36 AM
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.
Tags
Scheduler
Asked by
Varp
Top achievements
Rank 2
Answers by
Yana
Telerik team
Share this question
or