<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - Report Builder requires double entry of query parameter for Calc document type output when based on a query with required parameter input" href="https://bugs.documentfoundation.org/show_bug.cgi?id=135352#c12">Comment # 12</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - Report Builder requires double entry of query parameter for Calc document type output when based on a query with required parameter input" href="https://bugs.documentfoundation.org/show_bug.cgi?id=135352">bug 135352</a> from <a class="email" href="mailto:debewerking@kpnplanet.nl" title="debewerking@kpnplanet.nl">debewerking@kpnplanet.nl</a> <pre>(In reply to Alex Thurgood from <a href="show_bug.cgi?id=135352#c9">comment #9</a>) > 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: .... HAVING ( MIN( "tblcondensed"."type" ) = UPPER ( :give_b_or_v ) where the content of the column "tblcondensed"."type" is either 'B' or 'V' Did I not fulfill the recommendation 'column name <> parameter name' ?</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>