writing binding expression

[Zeeshan]

how do i write a binding expression for a textbox like
=Sum(contractamount) where vendorid is not null

documentation doesn't seem to help much.

Thanks
Zeeshan HIrani

[Svetoslav]

Hello Zeeshan,

You can try with the IIF built-in function:

=IIF(ISNULL(vendorid, 0) = 0, '', SUM(contractamount))

but this will print the Sum only when venderid is not null.

Another approach is to group by vendorid and then calculate the Sum. You can also handle the ItemDataBound event for the textbox that should display the Sum and make all calculations by hand.

We can give you a more comprehensive solution if you send us more information about your data structure and what exactly you want your report to display.
 

Best wishes,
Svetoslav
the Telerik team

Instantly find answers to your questions at the new Telerik Support Center