Bug 347801

Recently we've increased quality for printing. I'll check if we do the same for PDFs. I agree by default it's better to have lower quality for PDFs.

To check if it's about fonts it will help if you send me 2 PDF files: old one generated with old Kexi and a new one. Or at least a new one. We can see what fonts are embedded. We have not changed anything explicitly regarding fonts in Kexi 2.

PS: Please specify in the box above what's your Kexi version.

Created attachment 92657 [details]
Raydeo_042315.pdf

2 pdfs attached....the file size actually increased about 20x.

the images are identical in both invoices.

please please please add support for the sum() or total() function in a
report  :p

On Sun, May 17, 2015 at 7:13 AM, Jarosław Staniek <staniek@kde.org> wrote:

> https://bugs.kde.org/show_bug.cgi?id=347801
>
> --- Comment #2 from Jarosław Staniek <staniek@kde.org> ---
> To check if it's about fonts it will help if you send me 2 PDF files: old
> one
> generated with old Kexi and a new one. Or at least a new one. We can see
> what
> fonts are embedded. We have not changed anything explicitly regarding
> fonts in
> Kexi 2.
>
> --
> You are receiving this mail because:
> You reported the bug.
>

Created attachment 92658 [details]
Raydeo_052314.pdf

BTW, reports have support for SUM, MIN, MAX, AVG and COUNT, but only when using scripting .... and its probably not a widely known feature! that should improve with better scripting docs in the next version.

its quite fiddly to get right, but if you send me a simple database with report setup, i'll send it back with a summed field to show you how.

Actually, its not that complicated, no need to write a full report script....

in the datasource for the field on the report, write:

=field.sum("fieldname")

also, available is min, max, avg and count

All pretty, please let's use forum or another wish entry for this topic, thanks.

Created attachment 92663 [details]
attachment-23225-0.html

this doesn't work for me Adam.
the data field name is icost.........when i use this
....=field.sum("icost")............it
returns 0

On Sun, May 17, 2015 at 11:02 AM, Adam Pigg <adam@piggz.co.uk> wrote:

> https://bugs.kde.org/show_bug.cgi?id=347801
>
> --- Comment #7 from Adam Pigg <adam@piggz.co.uk> ---
> Actually, its not that complicated, no need to write a full report
> script....
>
> in the datasource for the field on the report, write:
>
> =field.sum("fieldname")
>
> also, available is min, max, avg and count
>
> --
> You are receiving this mail because:
> You reported the bug.
>

BTW, The field.sum(...) works for queries since 2.9.11. This may be important for you if you use query as report's data source, not just a table. Discussed at https://forum.kde.org/viewtopic.php?f=221&t=130345.

But this is not the topic of this bug. It's quality, can we change it to a wish such as "Add quality option for report generation"?

The problem seems to be that the PDF output is an image: searching for text doesn't find anything.

Using Kexi version  3.2 on windows 10
Printed report using Foxit reader pdf printer gives a file size 6081 KB. And takes several minutes.

Using the same pdf printer to print a similar report from Microsoft Access 2000 gives a file of 175K in which search for text works so it is not just an image.

KEXI 3.2.0 on Linux: searching for text find text. 2-page PDF is a 6KB file. See 10.pdf attached.

Printing to file gives similar reason. See 11.pdf attached.

If this bug report is confirmed for specific KEXI vesion and OS, please state it in the bug properties. Also the Qt version.

Created attachment 120406 [details]
Exported to pdf (j.staniek)

Comment on attachment 120406 [details]
Exported to pdf (j.staniek)

10.pdf

Created attachment 120407 [details]
11.pdf: printed to pdf (j.staniek)

@Ray: Have you compared "Printed report using Foxit reader" vs "Report -> Export As -> PDF" ?

Issue in the former may be related to specifics of the Foxit driver or the way how KEXI interacts with it (albeit via Qt).

Created attachment 120409 [details]
Sreen shot with report open

The option "Report -> Export As -> PDF" does not seem to exist in kexi Version 3.2 (3.2.0, git e2eb6f4 3.2). At least I could not find it. Screen shot attached.

Thanks Ray, on the screen shot, can you spot the "Report" menu?

Created attachment 120412 [details]
Screenshot

Thanks. I didn't realise it was a menu, it looks just like a label.

However it always fails as in screen shot.

Ray, by chance, do you select new and not existing filename? 
I've seen problems with existing filenames. Also please try different folder.
Note, my todays testing for this bug is on Linux.

Created attachment 120414 [details]
the kexi file

I tried it again with a new filename in a different folder but it still fails.
Here is the actual kexi file.

Thanks Ray, we will need to test this on Windows more. The All items report worked on my Linux box, attaching result.

Created attachment 120415 [details]
Linux srp.pdf