report total skipping to next page 3

[GShen]

Is there a way of keeping a Report Total on the same page in a multi column report ? If the report has room left in the 1st column the total comes at the bottom with no problem. However, if it runs into column 2 (assuming 2 columns on this report), then it skips to the top of the next page to print the total.
I can understand why it is doing this, I just wondering if I can override this some how.
When the totals print on a new page, they get lost by the user.
Thanks.

Remember when... everything worked and there was a reason for it?

 

[dhookom]

You could try create a new top level sorting and grouping on a constant expression like =1. Display the Group Footer for this level and use this rather than the Report Footer.

Duane
Hook'D on Access
MS Access MVP

 

[GShen]

dhookem,
Great! Works like a charm. I passed a dummy value like you said of 1 in the stored procedure to the report. Then grouped this field high order and display the footer as my totals. I got rid of the report footer. It is just what I want. I can probably use this in other spots as well. The overhead in non-existent.

Thanks!!

Remember when... everything worked and there was a reason for it?

 

[dhookom]

You don't even have to pass a dummy value. You can simply set the Field/Expression to:
=1


Duane
Hook'D on Access
MS Access MVP

 

[GShen]

So create a field with nothing in it (null) in the stored procedure and then set the value in the report equal to 1?
I have to pass something to the report or else you can't group on it. Unless there is something I don't know about.

Remember when... everything worked and there was a reason for it?

 

[dhookom]

You don't need to add anything to your stored procedure columns. The Field/Expression in the sorting and grouping accepts almost anything that you could type into a control source of a text box. You could use a field name or something like:[tt][blue]
=[Lastname] & [Firstname]
=Left([Lastname],1)
=[Dept]="HR"
=1[/blue][/tt]
If you use more than just a field name, the expression must begin with [tt][blue]= (equal sign)[/blue][/tt].


Duane
Hook'D on Access
MS Access MVP

 

[GShen]

Thanks. I removed the dummy field and changed the high order grouping to =1. I didn't know you can do that. That will also come in handy in the future (and past).

Remember when... everything worked and there was a reason for it?