Hi guys,
I have a grid that i added to it 2 columns that represents a calculated fields, the grid is like this and i'm using a stored procedure to get the data from SQL, the calculated columns are not returned in the query, i receive the following error when i load the page
Illegal Expression for column: BLBP
What it could be the problem?
thanks
I have a grid that i added to it 2 columns that represents a calculated fields, the grid is like this and i'm using a stored procedure to get the data from SQL, the calculated columns are not returned in the query, i receive the following error when i load the page
Illegal Expression for column: BLBP
What it could be the problem?
thanks
<
Telerik:RadGrid
ID
=
"DataGrid"
runat
=
"server"
Skin
=
"Simple"
SkinID
=
"Simple"
Width
=
"100%"
ShowStatusBar
=
"True"
AllowFilteringByColumn
=
"false"
AllowAutomaticDeletes
=
"false"
ShowFooter
=
"true"
AllowAutomaticInserts
=
"False"
AllowAutomaticUpdates
=
"False"
AllowPaging
=
"True"
AutoGenerateColumns
=
"False"
PageSize
=
"100"
GridLines
=
"Both"
>
<
PagerStyle
Mode
=
"NextPrevAndNumeric"
/>
<
MasterTableView
AutoGenerateColumns
=
"False"
AllowSorting
=
"false"
EditMode
=
"InPlace"
CommandItemDisplay
=
"none"
DataKeyNames
=
"ClientID"
EditFormSettings-EditFormType
=
"Template"
>
<
Columns
>
<
Telerik:GridBoundColumn
DataField
=
"ClientID"
Visible
=
"False"
HeaderText
=
"ClientID"
ReadOnly
=
"True"
SortExpression
=
"ClientID"
UniqueName
=
"ClientID"
/>
<
Telerik:GridBoundColumn
DataField
=
"ClientName"
Visible
=
"False"
HeaderText
=
"ClientName"
ReadOnly
=
"True"
SortExpression
=
"ClientName"
UniqueName
=
"ClientName"
/>
<
Telerik:GridBoundColumn
DataField
=
"ModifiedDate"
Visible
=
"True"
HeaderText
=
"Date"
ReadOnly
=
"True"
SortExpression
=
"ModifiedDate"
UniqueName
=
"ModifiedDate"
DataType
=
"System.DateTime"
DataFormatString
=
"{0:dddd dd/MM/yyyy}"
/>
<
Telerik:GridBoundColumn
DataField
=
"Notes"
Visible
=
"True"
HeaderText
=
"Description"
ReadOnly
=
"True"
SortExpression
=
"Notes"
UniqueName
=
"Notes"
/>
<
Telerik:GridNumericColumn
DataField
=
"BillNumber"
HeaderText
=
"Code"
SortExpression
=
"BillNumber"
UniqueName
=
"BillNumber"
FooterText
=
" "
DataFormatString
=
"{0:###,###.##}"
/>
<
Telerik:GridNumericColumn
DataField
=
"AmountLL"
Aggregate
=
"Sum"
HeaderText
=
"INV/LBP"
SortExpression
=
"AmountLL"
UniqueName
=
"AmountLL"
FooterText
=
" "
DataType
=
"System.Decimal"
DataFormatString
=
"{0:###,###.##}"
/>
<
Telerik:GridNumericColumn
DataField
=
"ValueLBP"
Aggregate
=
"Sum"
Visible
=
"true"
HeaderText
=
"Credit LBP"
SortExpression
=
"ValueLBP"
UniqueName
=
"ValueLBP"
FooterText
=
" "
DataType
=
"System.Decimal"
DataFormatString
=
"{0:###,###.##}"
/>
<
Telerik:GridCalculatedColumn
HeaderText
=
"Balance LBP"
UniqueName
=
"BLBP"
DataType
=
"System.Decimal"
DataFields
=
"AmountLL, ValueLBP"
Expression
=
"{5}-{6}"
/>
<
Telerik:GridNumericColumn
DataField
=
"AmountUSD"
Aggregate
=
"Sum"
Visible
=
"true"
HeaderText
=
"INV/USD"
SortExpression
=
"AmountUSD"
UniqueName
=
"AmountUSD"
FooterText
=
" "
DataType
=
"System.Decimal"
DataFormatString
=
"{0:###,###.##}"
/>
<
Telerik:GridNumericColumn
HeaderText
=
"Credit USD"
DataField
=
"ValueUSD"
Aggregate
=
"Sum"
Visible
=
"true"
SortExpression
=
"ValueUSD"
UniqueName
=
"ValueUSD"
FooterText
=
" "
DataType
=
"System.Decimal"
DataFormatString
=
"{0:###,###.##}"
/>
<
Telerik:GridCalculatedColumn
HeaderText
=
"Balance USD"
UniqueName
=
"BUSD"
DataType
=
"System.Double"
DataFields
=
"AmountUSD, ValueUSD"
Expression
=
"{5}-{6}"
/>
</
Columns
>
<
PagerStyle
Mode
=
"NextPrevNumericAndAdvanced"
PageButtonCount
=
"100"
/>
</
MasterTableView
>
<
ClientSettings
AllowColumnsReorder
=
"false"
EnableRowHoverStyle
=
"false"
>
<
Selecting
AllowRowSelect
=
"false"
/>
</
ClientSettings
>
</
Telerik:RadGrid
>