LibreOffice-Forum

Hello,
I installed basereport extension and it works fine except to print the data of the record running in a form.
the button calling the report is in a form named Spanc1
Could you give me an example of syntax for use of:
###FORMFIELD(<MainForm><SubForm><GridName><ColumnName>)###
my Mainform’ name is “Formulaire”
my GridName is called “ControleTable1”
my ColumnName is called “Etat”
I’ve tried
FORMFIELD(“Formulaire”“ControleTable1””Etat”)
FORMFIELD(“Formulaire”.”ControleTable1”.”Etat”)
FORMFIELD(“Formulaire” ”ControleTable1” ”Etat”)
FORMFIELD(“Formulaire”/”ControleTable1”/”Etat”)
and I got every time ###SQLERROR###

Thank’s.

Hi Steph,

###FORMFIELD(<Formulaire><ControleTable1><Etat>)###

should work.

I wonder why you get a ###SQLERROR### as you should get a messagebox like:
"Error! The control " & sName & " could NOT be found in " & sPathToObject & "!"

A ###SQLERROR### should appear in case of a not-SQL-string only... I think

Using quotation marks inside " ... ###FORMFIELD(<Formulaire><ControleTable1><Etat>)### ... " will lead to unexpected results, as they cause misinterpretation of the string for sure. That's why I choosed the <...> notation. I think I never lined out, that the use of "(", ")", ">" and "<" will cause problems ...