[Libreoffice-bugs] [Bug 135352] Report Builder requires double entry of query parameter for Calc document type output, whereas Writer document type only requires a single parameter entry

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=135352

Alex Thurgood <iplaw67 at tuta.io> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Report Builder does not     |Report Builder requires
                   |provide correct Text and/or |double entry of query
                   |Spreadsheet result-set      |parameter for Calc document
                   |                            |type output, whereas Writer
                   |                            |document type only requires
                   |                            |a single parameter entry

--- Comment #9 from Alex Thurgood <iplaw67 at tuta.io> ---
One thing I noticed which I don't understand is why the report, irrespective of
the report document type, produces two separate entries for the parameter
"2020", which do not appear in the query on which the report is based, when
using the same parameter.

If the parameter name is changed to DocNumber, or some string not corresponding
to a field name, this error disappears.

I suppose as a general rule, one should not be using parameter names that are
the same as the field name for which the parameter is being defined.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200915/94a4e4dd/attachment.htm>