Displaying Subtotals in XL-Report

[Former Member]

hi guys,

1. how to display the subtotals for userdefined fields for each column.

2.And i wanted to merge each User defined columns for displaying Sub-total for each every column,

this is an urgent requirement can give more suggestions about this issue.

Thanking u

Regards

Naga

[former_member346201 · Accepted solution]

Sub-totaling a UDF in XLR is just like sub-totalaling any other B1 field. In Report Designer you use the =SUM(ixRef(I9,2)) where I9 is the ceel you want to sub-total. The short cut for this function can be found on the XL Reporter toolbar under Formula Builder>Functions>Total>Column Total. I am assuming that you have already added your UDFs to XLR under the Tools>User-Defined Field Menu.

Dan

[Former Member · Accepted solution]

Hi,

I have a question for definition of =SUM(ixRef(I9,2)) you said.

At the end, I see the figure 2.

What does it describe?

It means you can show the figure with 2 decimal?

Thanks.