Hello all,
I am having trouble with the calculated column. everything works well until the calculated column is added then I get error message "Identifier expected".
Have gone through the documentations and examples but cannot figure out what's wrong and why it's not working.
Here is the code below. Any insight would be appreciated. Thanks!
<
telerik:RadGrid
ID
=
"ReportGrid"
runat
=
"server"
DataSourceID
=
"SearchResultDataSource"
>
<
MasterTableView
DataSourceID
=
"SearchResultDataSource"
AllowPaging
=
"false"
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"name_last_first"
HeaderText
=
"Name"
SortExpression
=
"name_last_first"
UniqueName
=
"name_last_first"
Aggregate
=
"CountDistinct"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"07"
HeaderText
=
"July"
SortExpression
=
"07"
UniqueName
=
"07"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"08"
HeaderText
=
"Aug"
SortExpression
=
"08"
UniqueName
=
"08"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"09"
HeaderText
=
"Sept"
SortExpression
=
"09"
UniqueName
=
"09"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"10"
HeaderText
=
"Oct"
SortExpression
=
"10"
UniqueName
=
"10"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"11"
HeaderText
=
"Nov"
SortExpression
=
"11"
UniqueName
=
"11"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"12"
HeaderText
=
"Dec"
SortExpression
=
"12"
UniqueName
=
"12"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"01"
HeaderText
=
"Jan"
SortExpression
=
"01"
UniqueName
=
"01"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"02"
HeaderText
=
"Feb"
SortExpression
=
"02"
UniqueName
=
"02"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"03"
HeaderText
=
"Mar"
SortExpression
=
"03"
UniqueName
=
"03"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"04"
HeaderText
=
"April"
SortExpression
=
"04"
UniqueName
=
"04"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"05"
HeaderText
=
"May"
SortExpression
=
"05"
UniqueName
=
"05"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridNumericColumn
DataField
=
"06"
HeaderText
=
"June"
SortExpression
=
"06"
UniqueName
=
"06"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
/>
<
telerik:GridCalculatedColumn
HeaderText
=
"Opened"
UniqueName
=
"Opened"
Aggregate
=
"Sum"
FooterAggregateFormatString="<b>{0:d}</
b
>"
DataFormatString="{0:d}"
DataType="System.Int32"
DataFields="01,02,03,04,05,06,07,08,09,10,11,12"
Expression="{0}+{1}+{2}+{3}+{4}+{5}+{6}+{7}+{8}+{9}+{10}+{11}"
/>
</
Columns
>
<
GroupByExpressions
>
<
telerik:GridGroupByExpression
>
<
GroupByFields
>
<
telerik:GridGroupByField
FieldName
=
"unit_type"
HeaderText
=
" "
SortOrder
=
"Ascending"
/>
</
GroupByFields
>
<
SelectFields
>
<
telerik:GridGroupByField
FieldName
=
"unit_type"
HeaderText
=
" "
HeaderValueSeparator
=
" "
SortOrder
=
"Ascending"
/>
</
SelectFields
>
</
telerik:GridGroupByExpression
>
<
telerik:GridGroupByExpression
>
<
GroupByFields
>
<
telerik:GridGroupByField
FieldName
=
"unit_name"
HeaderText
=
" "
SortOrder
=
"Ascending"
/>
</
GroupByFields
>
<
SelectFields
>
<
telerik:GridGroupByField
FieldName
=
"unit_name"
HeaderText
=
" "
HeaderValueSeparator
=
" "
SortOrder
=
"Ascending"
/>
</
SelectFields
>
</
telerik:GridGroupByExpression
>
</
GroupByExpressions
>
</
MasterTableView
>
</
telerik:RadGrid
>
<
asp:SqlDataSource
ID
=
"SearchResultDataSource"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
SelectCommand="rpt_getOpenAndAssignedByMonthForUnit" EnableCaching="False" SelectCommandType="StoredProcedure">
<
SelectParameters
>
<
asp:ControlParameter
Name
=
"int_fy"
Type
=
"Int32"
PropertyName
=
"Text"
ControlID
=
"YearTxt"
/>