[Solved] Format issue with Report Total

Dempewolff · Post by **Dempewolff** » Fri Feb 20, 2015 5:22 am

Probably an easy fix to this one, but i'm

I have a report using the report builder with grouping and group total and report total. Everything works as expected except the report total forces a new page before it prints.

report footer properties:
force new page=None.

The accumulator field properties:
visable=yes
print repeated values=no
print when group changes=yes

I would like it to print after the last group total (if there is room). I have attached a screen shot with the report footer selected and properties showing:

Any ideas or help with this would be appreciated.
Thanks, Peter

Post by **charlie.it** » Fri Feb 20, 2015 9:49 am

Hi, help us to help you: post your file.

Dempewolff · Post by **Dempewolff** » Fri Feb 20, 2015 4:59 pm

I have the DB attached.

Had to delete a few items to get to < 128KB; this one is operational for this purpose.

The report "Daily Log by Catagory with Hours GT test" uses the Query "Daily Log by Catagory with Hours" with a date criteria of February and a calculated field.

Other than this, there are other issues that need to be addressed in another thread; briefly: a lot of crashes with report builder and corrupted forms.

Thanks, Peter

Post by **F3K Total** » Fri Feb 20, 2015 8:39 pm

Hi,
maybe by introducing a column "One", for all records the same, and grouping by "One"?
R

Dempewolff · Post by **Dempewolff** » Fri Feb 20, 2015 9:36 pm

Thanks!
Well that worked. Now, I have to figure out why. Good excercise for me to ponder on.
Thanks again for your efforts,
Peter

Edit: