SIMPOL Documentation

Chapter 62. quickreportlib

quickreport1

Description

Type Tags

report1

Object Value

Objects of type quickreport1 have no value, and it is an error to try to get or set this value.

quickreport1.new()

Description

Prototype

quickreport1.new ( quickreport1 me, integer paperwidth, integer paperheight, integer marginleft, integer margintop, integer marginright, integer marginbottom, integer outputtarget, boolean showpagenumber, boolean showdate, boolean showtitle, string title, wxfont pagefont, string defbooleanformat, string defintegerformat, string defnumberformat, string defdateformat, string deftimeformat, string defdatetimeformat, SBLlocaledateinfo datelocale, SBLNumSettings numlocale, pagesetupinfo psinfo, boolean loading, type(sqlq1) query, integer error )

Parameters

ParameterDefault valueType nameDescription
meNonequickreport1
paperwidth210000integer
paperheight297000integer
marginleft20000integer
margintop12800integer
marginright20000integer
marginbottom12800integer
outputtarget1integer
showpagenumber.falseboolean
showdate.falseboolean
showtitle.falseboolean
titleNonestring
pagefontNonewxfont
defbooleanformatT|Fstring
defintegerformat.string
defnumberformat999999.00string
defdateformatyyyy.0m.0dstring
deftimeformathh:mm:ssstring
defdatetimeformatyyyy-mm-dd hh:mm:ss.nnnnnnstring
datelocaleNoneSBLlocaledateinfo
numlocaleNoneSBLNumSettings
psinfoNonepagesetupinfo
loading.falseboolean
queryNonetype(sqlq1)
errorNoneinteger

Properties

PropertyTypeDescription
addaggregatefunction
addcolumninfofunction
adddatasourcefunction
addgroupfunction
addtablefunction
bolditalicfontwxfont
bolditalicunderlinefontwxfont
boldunderlinefontwxfont
centeroverdisplayboolean
clipoutputarray
columninfodring
columnsarray
csvexportconverterdbCSVExport
currpagewxprintpage
currpagenumberinteger
currrownumberinteger
currtemplatewxprintpagetemplate
currtopofpageinteger
datasourcesdring
defbooleanformatstring
defdateformatstring
defdatetimeformatstring
defintegerformatstring
defnumberformatstring
deftimeformatstring
dialogdatastring
dirtyboolean
dpixinteger
dpiyinteger
filenamestring
finddatasourcefunction
findtablefunction
fontheightrationumber
fontwidthrationumber
footerlinecountinteger
fpofsfileoutputstream
gaugegaugedialog
gdiGDI
getcolumninfobycolnofunction
getprinttextextentfunction
getwrapheightfunction
getwrapheight2function
headerfontwxfont
headeroutputboolean
italicfontwxfont
italicunderlinefontwxfont
lastreportedpagenumberinteger
loadingboolean
localelocaleinfo
marginbottominteger
marginleftinteger
marginrightinteger
margintopinteger
onaftergroupevent
onafterrowevent
onbeforegroupevent
onbeforerowevent
onoutputfooterevent
onoutputheaderevent
onoutputreportfooterevent
onoutputreportheaderevent
onpagechangeevent
origfontwxfont
outputextralinefunction
outputfilenamestring
outputrowoddboolean
outputtargetinteger
pagefontwxfont
paperheightinteger
paperwidthinteger
printoutwxprintout
psinfopagesetupinfo
qrimportconverterdbQRImport
removedatasourcefunction
removetablefunction
reportreport1
reportheaderoutputboolean
rowheightinteger
rowheightadjustmentnumber
runfunction
sbmeexportconverterdbSBMEExport
setfontfunction
setrowheightadjustmentfunction
showdateboolean
showpagenumberboolean
showprinterdialogboolean
showtitleboolean
startat100percentboolean
stylefilenamestring
suppressoutputmessagesboolean
suppressrowoutputboolean
tablesdring
targettablenamestring
tbodyoutputboolean
titlestring
typetype
underlinefontwxfont
usegaugeboolean
usewrapheight2boolean
validboolean
winspoolWINSPOOL
wrapcharcountkludgevaluenumber

Methods

addaggregate()

Description

Prototype

quickreport1var.addaggregate ( quickreport1 me, report1group group, integer aggregatetype, integer colno, type datatype, integer error )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
groupNonereport1group
aggregatetypeNoneinteger
colnoNoneinteger
datatypeNonetype
errorNoneinteger

addcolumninfo()

Description

Prototype

quickreport1var.addcolumninfo ( quickreport1 me, integer columnstart, integer columnwidth, string alignment, boolean wrap, string displayformat, integer error )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
columnstartNoneinteger
columnwidthNoneinteger
alignmentleft,topstring
wrap.falseboolean
displayformatNonestring
errorNoneinteger

adddatasource()

Description

Prototype

quickreport1var.adddatasource ( quickreport1 me, type sourcetype, string source, type(*) datasource, string username, string password, integer codepage, integer retry, integer timeout, integer error )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
sourcetypeNonetype
sourceNonestring
datasourceNonetype(*)
usernameNonestring
passwordNonestring
codepageNoneinteger
retry1000000integer
timeout5000000integer
errorNoneinteger

addgroup()

Description

Prototype

quickreport1var.addgroup ( quickreport1 me, string name, integer colno, type datatype, integer error )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
nameNonestring
colnoNoneinteger
datatypeNonetype
errorNoneinteger

addtable()

Description

Prototype

quickreport1var.addtable ( quickreport1 me, type(db1table) table, quickreport1datasource source, integer error )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
tableNonetype(db1table)
sourceNonequickreport1datasource
errorNoneinteger

finddatasource()

Description

Prototype

quickreport1var.finddatasource ( quickreport1 me, string sourcename )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
sourcenameNonestring

findtable()

Description

Prototype

quickreport1var.findtable ( quickreport1 me, string tablename )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
tablenameNonestring

getcolumninfobycolno()

Description

Prototype

quickreport1var.getcolumninfobycolno ( quickreport1 me, integer colno, integer error )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
colnoNoneinteger
errorNoneinteger

getprinttextextent()

Description

Prototype

quickreport1var.getprinttextextent ( quickreport1 me, wxfont font, string s, integer width, integer height, integer descent, integer extleading, integer maxwidth, integer charcount )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
fontNonewxfont
sNonestring
widthNoneinteger
heightNoneinteger
descentNoneinteger
extleadingNoneinteger
maxwidthNoneinteger
charcountNoneinteger

getwrapheight()

Description

Prototype

quickreport1var.getwrapheight ( quickreport1 me, wxfont font, string s, integer width, integer origheight )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
fontNonewxfont
sNonestring
widthNoneinteger
origheightNoneinteger

getwrapheight2()

Description

Prototype

quickreport1var.getwrapheight2 ( quickreport1 me, wxfont font, string s, integer width, integer origheight )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
fontNonewxfont
sNonestring
widthNoneinteger
origheightNoneinteger

outputextraline()

Description

Prototype

quickreport1var.outputextraline ( quickreport1 me, quickreportextraoutputinfo outputinfo, string fontcharacteristics, boolean incrementtopofpage, integer error )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
outputinfoNonequickreportextraoutputinfo
fontcharacteristicsNonestring
incrementtopofpage.trueboolean
errorNoneinteger

removedatasource()

Description

Prototype

quickreport1var.removedatasource ( quickreport1 me, quickreport1datasource datasource )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
datasourceNonequickreport1datasource

removetable()

Description

Prototype

quickreport1var.removetable ( quickreport1 me, quickreport1table table )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
tableNonequickreport1table

run()

Description

Prototype

quickreport1var.run ( quickreport1 me, string errmsg, integer erridx, integer error )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
errmsgNonestring
erridxNoneinteger
errorNoneinteger

setfont()

Description

Prototype

quickreport1var.setfont ( quickreport1 me, wxfont font )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
fontNonewxfont

setrowheightadjustment()

Description

Prototype

quickreport1var.setrowheightadjustment ( quickreport1 me, number value )

Parameters
ParameterDefault valueType nameDescription
meNonequickreport1
valueNonenumber