Re: [libreoffice-users] Cannot get summed values in a Base report

Hi Girvin,
> However, when I try these parameters in the new report, when I select
> "Accumulation" in the Function field, it changes "Data Field" to
> "[AccumulationCostReport]" and the Function and Scope fields go blank.

Seems to be the right function. You could see the content of the
function when opening the report-navigator. The function must be
available there. Should look like
[Cost]+[AccumulationCostReport]
... but could be there is a field without content. If you add NULL (not
0) to the function the result will be NULL.

You could send me a database-example with some dummy-data. I would have
a look at it.

The best way to get the whole sum of all values is to create a view for
the content of the report. The sum will be a part of the view, not
created in the report.

Regards

Robert
-- 
Homepage: http://robert.familiegrosskopf.de
LibreOffice Community: http://robert.familiegrosskopf.de/map_3


-- 
To unsubscribe e-mail to: users+unsubscribe@global.libreoffice.org
Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette
List archive: https://listarchives.libreoffice.org/global/users/
Privacy Policy: https://www.documentfoundation.org/privacy