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.