Intersoft Community - WebGrid Enterprise - Aggregate function max for footer is not working

Aggregate function max for footer is not working

handy@intersoftpt.com — Fri, 25 Jan 2013 02:29:17 GMT

Hello,

It despends on what is your WebGrid structure. But I can give a sample snippet code about how to change it. All you need is, find the correct element. So, you will need to debug.

var grid = ISGetObject("WebGrid1");
var table = grid.RootTable;
table.GetElement(WG40.COLFOOTER, WG40.HTMLDIV).childNodes[0].childNodes[1].childNodes[1].childNodes[3].innerText = "0";

Regards,
Handy

Aggregate function max for footer is not working

kanimozhim — Mon, 21 Jan 2013 01:00:36 GMT

Hi Handy,

I will make sure of it next time.

Could you please let me know the steps to overwrite the value.

Thanks in Advance,

Kani

Aggregate function max for footer is not working

handy@intersoftpt.com — Sun, 20 Jan 2013 23:23:27 GMT

Hello,

Please post the question in the correct category for the next time. I moved it into the proper category. It should be in WebGrid category, not ClientUI.

I can replciate your issue as well in here. For now, you can overwrite the element of to show 0 value as temporary workaround.

Regards,
Handy

Aggregate function max for footer is not working

kanimozhim — Sat, 19 Jan 2013 02:36:58 GMT

Hi,

We were using the footer to display the aggregate value of Max. It is showing the max value properly when the grid is having values. When there is no data in the grid, it is not showing 0 or blank, it is showing -922337203684775808.00 in the footer. Is there a way to resolve this issue or to mask this value and show 0. Please suggest

ISWebGrid:WebGridColumn AggregateFunction="Max" Caption="Time to Repay(M)" DataFormatString="0.00"

DataMember="TimeToRepayMonthly" DataType="System.Decimal" Name="TimeToRepayMonthly"

Width="150px" DefaultValue="0">

<HeaderStyle Font-Bold="True" Font-Names="Tahoma" ForeColor="Black"

Font-Size="Small" Wrap="False"/>

<FooterStyle Font-Bold="True" Font-Names="Tahoma" ForeColor="Black"

Font-Size="Small" BackColor="#EAF3FF"/>

</ISWebGrid:WebGridColumn>