Ask Your Question
0

How to place a "grand total" on report

asked 2019-02-01 17:18:36 +0200

dougmn gravatar image

updated 2019-02-01 20:21:14 +0200

I have a report for an accounting database that shows detail for all transactions grouped by category. I have placed totals for the amounts in the group footer. That part works well. I'm stuck on how and where to place a "Grand total" at the end of the report. I want it to show only one time, at the end of the report.

edit: images of properties of the accumulation control, placed in the report footer:

image description

image description

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-02-01 18:13:01 +0200

Ratslinger gravatar image

updated 2019-02-02 06:25:44 +0200

Hello,

This is nearly identical to the total you already have. Your current accumulation should be based on a scope of the group. For the entire report, place a field on the Report Footer and the accumulation is a scope of Report.

Edit:

Using this version on Mint 18.3:

Version: 6.1.4.2
Build ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk2; 
Locale: en-US (en_US.UTF-8); Calc: group threaded

I tend to stay away from versions other than TDF or PPA. Have no current problems with group or report accumulation. See if my sample works for you. Simple but effective nonsense report based upon a query.

Sample ------ TotalDemo.odb

Have seen similar problem as you describe in an older version but with a bit of playing around with (don't remember how I got around it or the exact version this was a problem in) I was still doable. Seems I had to enter & re-enter or maybe even save the re-do - just not sure. This is not a problem in current TDF version.

Edit #2:

Just jumped over to Ubuntu 18.04 Mate and again no problems with this version:

Version: 6.1.4.2
Build ID: 1:6.1.4-0ubuntu0.18.04.1~lo1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: group threaded
edit flag offensive delete link more

Comments

It was pretty easy to place it in the Report Footer, and set the scope to "Report," but it doesn't show up when displaying the report. What am I missing? (see images of control properties added to the original question above).

dougmn gravatar imagedougmn ( 2019-02-01 20:12:14 +0200 )edit

Can't say for certain since a current test shows it is as simple as my answer states. The accumulation should be based upon the detail of each transaction the same as totaling the group.

Other than this, need to see a sample to figure out just what you have.

Ratslinger gravatar imageRatslinger ( 2019-02-01 20:34:06 +0200 )edit

Just saw additional information. I'm sure this is NOT how you generated the group totals. Should be something like:

Data Field Type         Function
Data Field                  (choose the field to accumulate here)
Function                    Accumulation
Scope                        Report
Ratslinger gravatar imageRatslinger ( 2019-02-01 20:36:53 +0200 )edit

This does not work. I'm beginning to suspect a bug. Here are the steps I’m going through: 1. Place a text box in the form footer. 2. In the properties-data tab of the text box, I select: ◦ Data field type: “function” ◦ Data field: “Dollar_Amount” ◦ Function: “Accumulation” This blanks out the “Function” box, and in the data field box I now have “[AccumulationDollar_AmountReport]” ◦ In the scope box, the only option is “Report.” I select this, but nothing happens. Running the report shows no totals in the report footer of any page.

The result is exactly the same if I start by inserting the data field and then setting it as a function.

Here's the verion information:

Version: 6.1.4.2 Build ID: libreoffice-6.1.4.2-snap1 CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; Locale: en-US (en_US.UTF-8); Calc: group threaded

dougmn gravatar imagedougmn ( 2019-02-02 05:38:57 +0200 )edit

I did find a way to make it work. Somehow my system had store the original group accumulations as user-defined functions, and every time I tried to put something similar for the same field in another section of the report, it converted it into the non-functioning user-defined function. This was on any version I tried. To fix it, I gave the fields in questin different aliases in the query underlying the report, and was able to re-do the group and report accumulations correctly. I'm going to mark this solved, in that @Ratslinger's original answer above is the correct one for the question I originally asked.

dougmn gravatar imagedougmn ( 2019-02-05 16:16:15 +0200 )edit

@Ratslinger : What is a TDF version?

dougmn gravatar imagedougmn ( 2019-02-05 16:17:24 +0200 )edit

@dougmn The Document Foundation - Download page

Ratslinger gravatar imageRatslinger ( 2019-02-05 17:54:59 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-02-01 17:18:36 +0200

Seen: 49 times

Last updated: Feb 02