Chapter 62. quickreportlib

Chapter 62. quickreportlib
	Part III. SIMPOL-Language Libraries

Chapter 62. quickreportlib

Table of Contents

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

Parameter	Default value	Type name
me	None	quickreport1
paperwidth	`210000`	integer
paperheight	`297000`	integer
marginleft	`20000`	integer
margintop	`12800`	integer
marginright	`20000`	integer
marginbottom	`12800`	integer
outputtarget	`1`	integer
showpagenumber	`.false`	boolean
showdate	`.false`	boolean
showtitle	`.false`	boolean
title	None	string
pagefont	None	wxfont
defbooleanformat	`T\|F`	string
defintegerformat	`.`	string
defnumberformat	`999999.00`	string
defdateformat	`yyyy.0m.0d`	string
deftimeformat	`hh:mm:ss`	string
defdatetimeformat	`yyyy-mm-dd hh:mm:ss.nnnnnn`	string
datelocale	None	SBLlocaledateinfo
numlocale	None	SBLNumSettings
psinfo	None	pagesetupinfo
loading	`.false`	boolean
query	None	type(sqlq1)
error	None	integer

Properties

Property	Type	Description
addaggregate	function
addcolumninfo	function
adddatasource	function
addgroup	function
addtable	function
bolditalicfont	wxfont
bolditalicunderlinefont	wxfont
boldunderlinefont	wxfont
centeroverdisplay	boolean
clipoutput	array
columninfo	dring
columns	array
csvexportconverter	dbCSVExport
currpage	wxprintpage
currpagenumber	integer
currrownumber	integer
currtemplate	wxprintpagetemplate
currtopofpage	integer
datasources	dring
defbooleanformat	string
defdateformat	string
defdatetimeformat	string
defintegerformat	string
defnumberformat	string
deftimeformat	string
dialogdata	string
dirty	boolean
dpix	integer
dpiy	integer
filename	string
finddatasource	function
findtable	function
fontheightratio	number
fontwidthratio	number
footerlinecount	integer
fpo	fsfileoutputstream
gauge	gaugedialog
gdi	GDI
getcolumninfobycolno	function
getprinttextextent	function
getwrapheight	function
getwrapheight2	function
headerfont	wxfont
headeroutput	boolean
italicfont	wxfont
italicunderlinefont	wxfont
lastreportedpagenumber	integer
loading	boolean
locale	localeinfo
marginbottom	integer
marginleft	integer
marginright	integer
margintop	integer
onaftergroup	event
onafterrow	event
onbeforegroup	event
onbeforerow	event
onoutputfooter	event
onoutputheader	event
onoutputreportfooter	event
onoutputreportheader	event
onpagechange	event
origfont	wxfont
outputextraline	function
outputfilename	string
outputrowodd	boolean
outputtarget	integer
pagefont	wxfont
paperheight	integer
paperwidth	integer
printout	wxprintout
psinfo	pagesetupinfo
qrimportconverter	dbQRImport
removedatasource	function
removetable	function
report	report1
reportheaderoutput	boolean
rowheight	integer
rowheightadjustment	number
run	function
sbmeexportconverter	dbSBMEExport
setfont	function
setrowheightadjustment	function
showdate	boolean
showpagenumber	boolean
showprinterdialog	boolean
showtitle	boolean
startat100percent	boolean
stylefilename	string
suppressoutputmessages	boolean
suppressrowoutput	boolean
tables	dring
targettablename	string
tbodyoutput	boolean
title	string
type	type
underlinefont	wxfont
usegauge	boolean
usewrapheight2	boolean
valid	boolean
winspool	WINSPOOL
wrapcharcountkludgevalue	number

Methods

addaggregate()

Description

Prototype

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

Parameters

Parameter	Default value	Type name
me	None	quickreport1
group	None	report1group
aggregatetype	None	integer
colno	None	integer
datatype	None	type
error	None	integer

addcolumninfo()

Description

Prototype

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

Parameters

Parameter	Default value	Type name
me	None	quickreport1
columnstart	None	integer
columnwidth	None	integer
alignment	`left,top`	string
wrap	`.false`	boolean
displayformat	None	string
error	None	integer

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

Parameter	Default value	Type name
me	None	quickreport1
sourcetype	None	type
source	None	string
datasource	None	type(*)
username	None	string
password	None	string
codepage	None	integer
retry	`1000000`	integer
timeout	`5000000`	integer
error	None	integer

addgroup()

Description

Prototype

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

Parameters

Parameter	Default value	Type name
me	None	quickreport1
name	None	string
colno	None	integer
datatype	None	type
error	None	integer

addtable()

Description

Prototype

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

Parameters

Parameter	Default value	Type name
me	None	quickreport1
table	None	type(db1table)
source	None	quickreport1datasource
error	None	integer

finddatasource()

Description

Prototype

quickreport1var.finddatasource ( quickreport1 me, string sourcename )

Parameters

Parameter	Default value	Type name	Description
me	None	quickreport1
sourcename	None	string

findtable()

Description

Prototype

quickreport1var.findtable ( quickreport1 me, string tablename )

Parameters

Parameter	Default value	Type name	Description
me	None	quickreport1
tablename	None	string

getcolumninfobycolno()

Description

Prototype

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

Parameters

Parameter	Default value	Type name
me	None	quickreport1
colno	None	integer
error	None	integer

getprinttextextent()

Description

Prototype

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

Parameters

Parameter	Default value	Type name
me	None	quickreport1
font	None	wxfont
s	None	string
width	None	integer
height	None	integer
descent	None	integer
extleading	None	integer
maxwidth	None	integer
charcount	None	integer

getwrapheight()

Description

Prototype

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

Parameters

Parameter	Default value	Type name
me	None	quickreport1
font	None	wxfont
s	None	string
width	None	integer
origheight	None	integer

getwrapheight2()

Description

Prototype

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

Parameters

Parameter	Default value	Type name
me	None	quickreport1
font	None	wxfont
s	None	string
width	None	integer
origheight	None	integer

outputextraline()

Description

Prototype

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

Parameters

Parameter	Default value	Type name
me	None	quickreport1
outputinfo	None	quickreportextraoutputinfo
fontcharacteristics	None	string
incrementtopofpage	`.true`	boolean
error	None	integer

removedatasource()

Description

Prototype

quickreport1var.removedatasource ( quickreport1 me, quickreport1datasource datasource )

Parameters

Parameter	Default value	Type name	Description
me	None	quickreport1
datasource	None	quickreport1datasource

removetable()

Description

Prototype

quickreport1var.removetable ( quickreport1 me, quickreport1table table )

Parameters

Parameter	Default value	Type name	Description
me	None	quickreport1
table	None	quickreport1table

run()

Description

Prototype

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

Parameters

Parameter	Default value	Type name
me	None	quickreport1
errmsg	None	string
erridx	None	integer
error	None	integer

setfont()

Description

Prototype

quickreport1var.setfont ( quickreport1 me, wxfont font )

Parameters

Parameter	Default value	Type name	Description
me	None	quickreport1
font	None	wxfont

setrowheightadjustment()

Description

Prototype

quickreport1var.setrowheightadjustment ( quickreport1 me, number value )

Parameters

Parameter	Default value	Type name	Description
me	None	quickreport1
value	None	number


updatewxdialogdata()		quickreport1datasource