Sorting by sum of Arrears

[musini]

Hi All,

In the report I have two groups group1 and group2 and I have the sum the arrears in the group2 footer. The details and group1 header are supressed, so the froup2 footer is shown as details.

Now the report is sorted on the grouped fields, is there any way that I could sort it according to the sum of the arrears field which is in gorup2 footer.

Thanks,
M

 

[lbass]

If the sum is an inserted summary, you can go to report->group sort->Group#2 tab and select sum of arrears as your group sort field.

-LB

 

[musini]

Thanks LB.

It worked perfect, first I was using running totals and so I could not do it but with summary column I could useit. I have one more question. Is there any way I could display tje group header on each page of the report.

Thanks,
M

 

[lbass]

What is the problem you are running into? Which group header--#1? Is there a new page before set on the group header?

-LB

 

[musini]

Thanks for the response LB.

I have found the answe, I have used the repeat group header on each page option.

Thanks,
M