[Libreoffice-bugs] [Bug 135352] Report Builder requires double entry of query parameter for Calc document type output when based on a query with required parameter input

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #12 from debewerking at kpnplanet.nl ---
(In reply to Alex Thurgood from comment #9)
> 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.

I experience the same behaviour (.odt - once / .ods - twice) using firebird ?
and LibO Version: 6.4.7.2 Build ID: 1:6.4.7-0ubuntu0.20.04.1, though the
parameter expression is slightly different:<br>.... HAVING ( MIN(
"tblcondensed"."type" ) = UPPER ( :give_b_or_v ) <br>where the content of the
column "tblcondensed"."type" is either 'B' or 'V'<br>Did I not fulfill the
recommendation 'column name <> parameter name' ?

-- 
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/20210629/d2ad20a0/attachment.htm>