Download List & Lab el 1 5

List &
Labe
l 15
%
100 ing
ort
p
e
R
er
w
o
P
Content
2
Reporting-Tool List & Label 15: 100% Reporting Power
3
Your Benefits at a Glance
4
The Program’s Heart from a User's Viewpoint
5
List & Label Functional Principle
6
Application
7
Programming Examples
8
The Designer in Detail
10
Designer Objects Table, Crosstab & Co.
12
Designer Object Chart
13
Designer Barcode Object
14
More Designer Objects
15
Object Model for Projects - DOM
16
Output
17
Programming Examples
18
Print Preview
19
Export
20
International Projects
22
Let Us Back You Up Or Do It Yourself and Save
24
Contact + selected customers
Component List & Label 15:
100% Reporting Power
What does a lime have to do with a
report component?
List & Label is refreshingly different,
easy to handle, universally applicable
and absolutely vital for your application. Or perhaps we just liked the
color? ;-)
I recommend that you take a look at
the movies first, then go ahead and
test the free trial yourself – it runs for
30 days and has complete functionality. Why not start with one of the
provided examples?
Quickly and easily embed List & Label in your programs. With just a
few lines of code you gain access to reporting of any kind and ensure
success for your application!
Reports,subreports,lists,drilldowns
Crosstabs
Diagrams,charts
Forms,labels
Print,preview,export
Webreporting
Kind regards and wishing you success,
Rati
ng:
"Exc
“List
ellen
&L
t”
abel
deve
is
l
and omentt themo
d
o
s
dina oesnot olmad timpor
ein
tant
ryp
onl
G
r
y
cont
o
inuo ductsu gleamw ermany
ppo
PC M
usp
i
t
hex
rt
rodu
aga
ctd butals traorzin
o
evel
opm with
ent.
”
Christiane Kördel
Managing Director
combit GmbH
Deluxe"
sentation
"Data Pre hasforyears
el
"List&Lab gthemost
n
o
m
a
n
ee
tinthe
b
componen g."
t
n
a
rt
o
in
imp
m
m
ra
g
fpro
domaino
ro
p
database
2
Your Benefits at a Glance
Designer also for end users
Awarded and reliable
Almost any programming language
Withoutseparatelicensefees!::endusers
cancreatereportsbythemselves::more
successforyourapplication,stress-free
...More on pages 4 and 8
Over17years::goodreputation::many
enthusiasticdevelopercustomers::severalmillionsofendusersworldwide
...More on pages 2 and 24
Switchinglanguagesisnoproblem
...More on page 6
Integrate quickly as component
German efficiency
Only5minuteswith.NET::1.dragcomponenttoform::2.setpropertiesusing
SmartTags::3.startprinting/design
...More on pages 5 and 7
Morethan20yearsofexperience::reliabilityforyourproject::quickhelp::directlinetoexpertsandmakers::lasting
effectbycontinuousinnovation
...More on page 22
Quicklyandeasilyadvaluetoyourapplication::comprehensiveexportformats,
e.g.PDF,HTML,RTF,Excel...
...More on page 16
Easy and flexible in use
Databindingplusdataprovideror
independentofdatabase::components
orDLL::combinecustomdatafieldsand
databasefieldsasyouwant
...More on page 5
ol
ng to
porti
e
r
t
in"
es
8
agaz
The b year, 200
etm
n
.
t
o
e
:"d ow
of th
hoice
r
ers’c timeina
d
a
e
R
h
t
4
he
Fort
Something to suit everyone
SavemoneywithStandard::obtain
subscription,support&CowithProfessional::enjoytheall-inclusivecarefree
packageofEnterprise
...More on page 22
2008
Print+preview+export = 1 code
Many barcode formats
Also2Dbarcodes::nobarcodefonts
required
...More on page 13
Simple to redistribute
Withoutdatabasedriver::slim::easyto
handle::savesonresources
...More on page 5
The be
st com
po
of the
year, 2 nent
008
Readers
’c
"dotnetp hoice:
ro"
Forthe
2ndtim
einar
ow
The best re
porting tool
of the year,
2007
Readers’cho
ice:"entwic
klermagazin
Forthe4th
"
timeinarow
AsofOct2009,nofurtherreaders‘choiceshavebeencarriedout.
3
The Program's Heart from a User's Viewpoint
List & Label Designer :: Drag & Drop :: Preview
TheList&LabelDesignerwithintegratedrealdatapreview.Everythingareportingheartdesires,universallydeployable.
With the List & Label Designer you
Des
4
enhanceyourapplicationquicklyand
easilytoincludepowerfulfunctions.You
providetheenduserswiththefreedom
andflexibilitytheyneedandensurea
competitiveedge.Thetimeandeffort
requirediskeptremarkablylow.
ur
oyour
Yo efit Addedvalueetedom&
r
n
f
,
be programheendusers
igne
t
ityfor
flexibil
rin
clud
edf
ore
nd
Inallthreeeditions–Standard,ProfessionalandEnterprise–youmaypasson
theDesignerwithmostdesktopapplicationswithoutpayingextralicensefees.
IntheEnterpriseEdition,runtimeisalso
includedformostserver/webserverapplications.
Find out more at
www.combit.net/en/Licensing

use
rs
List & Label Functional Principle
Data transfer :: Data binding :: Database independence :: Components
Print, Preview, Export
Providers
SQL
OleDb
Oracle
XML
MySql
LINQ
Data
database,
userdata,
measurement
values
PostgreSQL ADO.NET
SQLite
DB2
Your Application
Data binding for .NET: Thereareprovidersforthe
mostdatabases.Yourjobconsistsofonly6linesof
simplecode.
Database-independent use in a typical desktop application:yourapplicationpassesonthedatatoList&Label.
Withdatabinding
Databaseindependent
.NET List&Label15accessesthemost
It'squickestwithdatabindingofcourse.Butdatabaseindependencehasconsiderableadvantagesandmassappealformanyyears.Withthiswayofuse,yourapplicationpassesthedatatoList&Label.Ifitisaserverorwebserverapplication,youonly
needtoplananinterfacetocreatethereports.
importantdatabasesdirectly.Includedare
providersforSQLServer,Oracle,MySQL,
PostgreSQL,OleDb,XML,LINQ,DB2,
SQLiteandforalldatabases,thatcanbe
accessedbyIDbCommandobjects,meaningallADO.NETdatasources,including
therelationsbetweenthem.Ontopof
thatwehavedisclosedanddocumented
theinterfacethatneedstoserveadata
providerobjectofthattype,soyoucan
easilyconnectotherdatasourcestoList
&Labelyourself.Anexcellenthelpfeature
providesadditionalassistanceforquick
implementation.
Designer
Desktop Application
ConceptualadvantagesofList&Label
Direct data transfer.Youare
completelyindependentofspecific
databaseformats.Youcontrolthedata
transferandcreatetheinterfaceyourself.Youmayadfieldsandvariablesin
thedatabindingmode,too.

Pure speed. Noneedtoloadthe
databasedrivertwice,andthedirectuse
ofbusinessobjectsiseasilydone.
Stability.Yourreportscontinue
tobefullyoperationalwhene.g.anend
useraddsafieldtothedatabase.

Several databases–onereport.
Thissavestimeandensuresthatyour
applicationcanbeuseduniversally.


CL WhetherADORecordsetorBDE
V
-eachderivativefromTDataSourcecan
beeasilylinked.Heretoo,themaster/detailrelationsareautomaticallyevaluated
andtransferred.
Lean redistribution.Redistribution
isasnap,andthepackageissohandy.
You'rereadytogowithapproximately
20MB!

5
Application
Up to Date
.NET :: C++ :: Delphi & Co
System software :: technologies
Programming languages
and development environments


























1
4
5
6
7
8
9
2
3
10
12
13
11
6
.NET1
Access2
AcuCobol7
AlaskaXbase++3
AsymetrixToolbook4
C#|special.NETcomponent1
C/C++|examplesforVC++5
C++Builder9
CenturaSQL4
Clarion4
Cobol7
Delphi6
DelphiPrism|special.NETcomponent11
Excel|VBpartiallyapplicable7
Java10
LotusScript4
PowerBuilder4
Progress7
VisualBasic8
VisualBasic.NET|special.NETcomp.1
VisualC++5
VisualDataFlex12
VisualdBASEPLUS12
VisualFoxPro13
VisualObjects13
WinWord|VBpartiallyapplicable7
.NETcomponent,14examplesrespectively
Declarationfile,2examples
Declarationfile,3examples
Declarationfile
Declarationfile,10examplesVC++
VCL,19examples
Canbeintegrated
Declarationfile,14examples
VCL,10examples
JNI-DLL,2examples
.NETcomponent,1example
Owncomponent,1example
Declarationfile,1example
64-Bit*
Your
benefit
Univ
ersallya
pplicab
le
Change
thelan
thepro
g
ject:it’ uagetosuit
snopro
blem!
VisualStudio2010
RADStudio2010
Windows7
List&LabelwithVisualStudio2010(Beta)...
...andwithRADStudio2010.
*ProfessionalandEnterpriseEdition.Forrestrictions,seeProgrammer‘sReference.
AsofOctober2009.List&LabelcanbeintegratedintoalllanguagesthatsupportDLLcalls.
Pleaseletusknowifyouthinksomethingismissing.T+497531906010
Programming Examples
Starting the Designer :: .NET :: Delphi :: C++ :: Visual Basic
.NET
C++
protected void button1_Click
(object sender, System.EventArgs e)
{
try
{
// Link to a DataSet object
LL.SetDataBinding(myDataSet,
"Orders");
// Define special fields,
// Set properties (optional)
LL.AutoDesignerFile = "subrep.lst";
LL.AutoProjectType = LlProject.List;
LL.AutoDialogTitle = "example";
LL.AutoShowSelectFile = true;
// Start the Designer
LL.Design();
}
// Catch exceptions:
catch (ListLabelException LlException)
{
MessageBox.Show("Information: " +
LlException.Message,"Information",
MessageBox.IconInformation
|MessageBox.OK);
}
// normal text field
LlDefineFieldExt(job, "Text", "Testtext", LL_TEXT, NULL);
// footer fields, e.g. numeric
LlDefineFieldExt(job, "subtotal", "12.34", LL_NUMERIC | LL_TABLE_FOOTERFIELD, NULL);
// Barcode fields
LlDefineFieldExt(job, "BC_EAN_128", "123456789abcd", LL_BARCODE_EAN128, NULL);
// variable graphics via file names
LLDefineFieldExt(job, "Normal image", "sunny.bmp",LL_DRAWING, NULL);
// File selection dialog with sketch
LLSelectFileDlgTitleEx(job, hWnd, "File selection", LL_PROJECT_LIST, szFile,sizeof(szFile),
NULL);
// Remove specific menu commands from Designer
LLDesignerProhibitAction(job, 211);
// Start the Designer with the above fields:
LLDefineLayout(job, hWnd, "Title", LL_PROJECT_LIST, szFile);
}
Delphi
Visual Basic
{Start Designer}
procedure
TForm1.DesignButtonClick(Sender: TObject);
begin
//Assign data source
LL.DataSource := dsCustomers;
Private Sub ButtonDesign_Click()
'starts the Designer with the title, "Invoice" and the file, "Invoice.lst":
ListLabel1.Design(0, hWnd,_"Invoice", LL_PROJECT_LIST,_"Invoice.lst", 1)
End Sub
The Event ListLabel1_CmndDefineFields is used for the data definition.
//The customer master data should be
//registered as fields
LL.AutoMasterMode := mmAsFields;
//Set standard project names
LL.AutoDesignerFile := 'subrep.lst';
//Set print mode to PreviewControl
LL.AutoDestination := adPreview;
end;
//Designer
LL.AutoDesign('Invoice List', ");
L?
ur
ts?DL
ulike.
Yo efitComponen ewhateveryonts,
e
s
n
n
o
re
po
ho
be
canc tethecom renjoypu
You
o
X
gra
eX/OC
L.
lyinte
Quick CLorActiv entingDL
m
V
le
,
T
p
E
im
.N
ityby
flexibil
7
7
The Designer in Detail
Intuitive Operation :: Comprehensive :: Universal
Flexiblereportstructure
Differentlayoutregions
FormatEditor
Variablelist
F ormulaassistant-evenapplicableasidefrom
List&LabelintheEnterpriseEdition
IncludedProjects
Even first time users becomequickly
Different layout regions and the
output control enableyoutomix:
Theenduserwon'tbeabletotellthem
apartfromtheList&Labelfunctions.
familiarwiththeintuitivehandlingvia
Drag&Drop.Awholepageisawhole
pageandnotaconglomerationofdifferentsections.Rulers,rulerguides,zoom,
groupingfunctionsandotherwellknown
helpersmakeiteasierforyouandthe
endusers.
Real data preview is directly integrated, aswellasprintandexport.
Shortwayssaveyoutime.
The ergonomic tool windows include
properties,variables,objects,layers,previewandthepowerfulreportcontainer.
page1onprinter1,page2inlandscape
formatonprinter2,thelastpagetoa
billingprinterandeverythingagainto
printer3withthesign"copy"onit.Also
possible:changingbycondition.
Use the formula assistant tosimplify
andincludeformulasincommercial
forms,linefiltersinlistsetc.Calculationsare
madetoanydesiredprecision.Moreover
Youcanevensupplyyourownexplanationtextsandeasilyfindfunctionsand
fieldsusingtheprovidedfilter.
Add custom functions and actions
usingthe.NET,VCLandOCXcomponents.
8
In the format editorsimplyselectper
sample.That'swhatOfficeendusersare
accustomedto.
Included Projects save timewhen
objectgroupsoccurunchangedinseveral
differentprojects,e.g.letterheads.
Your t
i
benef
Simply
catio enrichyourappli
nwithad
dedvalu
e
Everythin
g
designre youneedto
portspro
fessionall
y
Additional
Features of the Designer
DTP control with3designmodes:Layout,
layoutpreview,incl.yourownzoom.
Precise! Positionexactlyupto1/1000mm
or1/1000inch.
Alignseveralobjectsnexttoeachothervia
themenuorviashortcuts
AlabelprojectintheDesigner
Free positioning gridand"snaptogrid"
Labels and forms: a strong point.
When filling out existing formssave
Rotating textsandbarcodesin90°steps
Simplyfilloutoneoftheover2000
standardlabeltemplatesprovidedby
internationalmanufacturers(Avery,Badgepoint,Boeder,Devauzet,ERO,Herlitz,
Herma,Leitz,May+Spiess).Inaddition,
furthersizescanbedefinedasrequired.
Alongsidestandardfunctions,suchas
fonttypeandlinepitchforeachline,you
benefitfromrealhigh-endfunctions:
Suppressunwantedemptyrowsand
characters,leaveoutusedlabelsfrom
printinganddetermineprintingorders.
yourselfthetroubleofmeasuringeverythingbyusingthespecialformtemplate
objecttoblendascannedformintothe
background.Positiontheobjectsontop
–withprecisionof1/1000inch!
Intelligentcontext menus
ppearance conditionsforlayers,indiA
vidualobjectsandmultipleobjectsatthe
sametime,orcombined
um variables,optionallyasgroupsums,
S
pagesumsorprojectsums
User variablese.g.tobackupinterim
formulas,"formulacomponents"
ariable namesquicklylocalizedviatransV
lationtables.
Moreonpage20
Over 170 functions and 20 operators
forcalculations,conditionsandfiltersand
alsoyourownfunctionsifoneofthecomponentsisapplied
9
Designer Objects Table, Crosstab & Co.
Reports :: Subreports :: Multi tables :: Crosstabs
Reportstructure
Tableproperties
Well equippedforeventhemostdaring
leapsandboundswiththereportcontainer.Withoneofourexamplesorwith
theList&Labeldatabindingfor.NETor
VCLyoustartarbitrarysequencesusing
thesamecode:
- Tablesandsubtablesorreport
container/subreports
- Tables,chartsandcrosstabs
- Chartsintablecolumns
- Freetext,pictures,barcodesor
variablecontents
That'spureflexibility.Evenchartsintable
columnsareunderyourfullcontrol!
Youspecifywherethedatashouldcome
from,andList&Labelhandlestherest.
10
CreateDrilldown
With the drilldown feature youcreate
user-friendly,clearlylaidoutreports,for
example,aboutcustomers,ordersand
detailsoforders,inotherwordshierachicalorratherrelationalstructures.Passing
dataviadatabindingincombinationwith
.NETorVCLissosimple.1:nrelationsare
automaticallypassedandcanevenbe
brokendowninreverseinto1:1relations.
Inotherprogramminglanguagesspecial
commandsenableyoutopassdatabase
tablescompletelywithallrelationsand
sortingstoList&Label.Enduserscan
easilyhandlerelationaldatabasesin
theDesignerandjumpwithjoyinthe
preview.Theretheyclickalongthelinks
inthepreview,deeperanddeeper,until
theyreachthedesireddatalevel.
Andthatisexactlywhattheysendto
theprinterorintoaPDF,neatlyand
cleanly.Evenwithverylargeandcomplexdatabases,youcanbesurethat,as
adeveloper,everyonecanquicklyprocesstheinformationthey‘relookingfor.
Your t
i
benef
Read
conc yforalmostall
eivablet
asks
Spacefo
rcreative
reports
Multiple-columntables
Definitionofandresultsfromcrosstabs
The table object does almost
everything! It'sgotaseparateareafor
everything–header,datarow,groupheader,groupfooterandfooterandageneraltablelayout.Itcanallbeseparately
configured.Columnsarepulledtothe
widthyouwantoradjustedpreciselyin
thedialogwindow.Overlappingtitles
acrosstwocolumns,multiplepagesand
multiplecolumnsintables:it'sallabsolutelynoproblem!Distractingdatarows
aresimplyblendedoutduringdesign.
UsetheDesignertoeasilygroupyour
data.Multipledatalinesenableyourprogramtoswitchbetweendifferentlayouts.
The crosstab objectcombinesdata
inseveraldimensionsandanswers
questionssuchas"howareproductsales
distributedoveranumberofyears;how
areproductsalesdistributedamong
staff?"Youcanalsomapmorecomplex
structuresbyinsertingadditionallevels.
Awizardsupportsyouincreatingthem.
Tomakecalculationseasierincrosstabs,
anumberofspecialfunctionsareavailabletohelpyou.Andboy,willyou
impressotherswithyourdesignideas.
Pow
e
rful
table
obje
ct
11
Designer Object Chart
Diagrams :: Lines :: Pie charts :: Bars :: Cone diagrams :: Octahedron diagrams
lur t
evisua
Yo efi Impressfivfigures
n
no
be izatio
design
pealing
Ap
The chart function makes your
reports sparkle. Thedataforreportsand
chartsareusuallyonlypreparedonce.
Chartdefinition
Labelingdirectlyinthechart
Horizontalbarcharts
The charts canberotatedaroundboth
piechartsinanexplodedview,label
charts,printlongaxislabelsdiagonally,
defineseveraly-axesandscaletheaxes
logarithmically.Webetthereissomethinghereyou'llfindusefulforyour
graphicalevaluation!
axes–therearebarcharts(verticaland
horizontal)piecharts,conecharts,octahedrons,linesandvariantsin2D/3D,
multi-row,clustered,stackedorasa
simpleversion.Choosefixedcolors,see
12
Rowsinsidethechartobject
Designer Barcode Object
GS1 :: 2of5 :: Code39 :: EAN :: GTIN :: DataMatrix :: PDF417 :: QR ::
The barcode objectsupportsmore
than40barcodeformats.Thissurely
makesList&Labeloneoftheleading
reportgenerators.Nobarcodefontsare
required.Forbestresultsyousetboth
thebarwidthaswellasthebarratioif
thebarcodetypepermits.
Barcode scanned
successfully!
CathedralofConstance
ee
fromWikipedia,theFr
Encyclopedia
nce
TheCathedralofConsta
erman)is
(KonstanzerMünsterinG
heformer
theproto-cathedraloft
ssolvedin
tanz(di
diocesesofKons
90
thatin5
ndicate
1821).Recordsi
Barcode formats















of5:Interleaved|Industrial|
2
Matrix|Datalogic
3of9aliasAlpha39aliasCode39
::withCRC|withoutCRC
Codabar
Code11
Code93|Code93x0
Code128
EAN-13P2(ISSN)magazines
EAN-13P5(Bookland,ISBN)books
GermanParcel
GermanPostIdentcode
GermanPostLeitcode
GS1128|EAN-128
GS1DataBar:Einfach|Expanded|
Limited|Stacked|StackedOmni|
Truncated
GTIN-8|EAN-8|UCC-8|JAN-8
GTIN-13|EAN-13|UCC-13|
JAN-13










ISBN
JapanesePostcode
KIX,PostcodeoftheNetherlands
MSI|MSIPlain|MSI+10+10
MSI+10+CD|MSI+11+10
NVE|SSCE
PZNRoyalMail|UKPostcode
UPC-A/E
US-FIM
US-Postnet
Additional 2D barcodes in the
Professional and Enterprise Edition





Additional2DbarcodesintheProfessionaland
EnterpriseEdition
PDF417
Maxicode
DataMatrix
Aztec
QR
Your
benefit
A
ll
fo popularba
rc
rmatss
upport ode
ed
Nobar
codefo
ntsreq
uired
Andthebestthingaboutitisthatthe2DbarcodeQR
readbynewercellphones.
ts
d
ef
o
arc
a
orm
CuttingedgeGS1barcodes
yb
n
Ma
13
More Designer Objects
RTF :: OLE :: own :: HTML :: Text :: Graphics
RTFEditor
14
WorddocumentintheOLEcontainer
With the RTF Designer objectyou
The OLE objectisacontainerforOLE
generatenotonlyreportsbutalsoserial
lettersandsimilar.Sinceitispossibleto
linkseveralRTFobjectsandhavethem
overlapeachother,thenumberofpossiblelayoutoptionsistrulyamazing.This
includesmultiplecolumns,imageand
tablecirculations.
serverdocuments.ThisishowyouintegrateWord,ExcelandVisiofilesand
benefitfromtheirfunctionality.AdoubleclickintheDesigneractivatestherespectiveprogram;modificationsaredisplayed
immediately.Asamatterofprinciple:
onlysinglepagedocuments.
Use the RTF controltoofferendusers
Your own objects canbeintegrated
asmallwordprocessor,forexample.Start
theRTFEditorasanindependentcontrol
orintegratetheInplaceControlaspart
ofthe.NET,VCLandOCXcomponentsin
yourdialogs.Thiswayyoumaykeepthe
endusersawayfromtheDesigner,for
example,andallowtextinputonlyviaRTF
control.
withtheList&Label.NET,VCLandOCX
componentswithoutthisbeingapparent.
Inotherprogramminglanguages,thisis
realizedviacallbackandcallbackdialog
events.
Additional objects
- HTMLobjects
- Textobjects
- Lines, rectangles, circles,
ellipse objects
- Graphic objects,formats:WMF,
BMP,PCX,TIF,JPEG,GIF,EMF,PCD,
DIB,RLE,PNG
- Form controlobjects:Completedby
theuserintheprintpreview
- Form template object:Graphic,
e.g.scannedbitmap,asahelpfor
positioninginthebackground
Object Model for Projects - DOM*
Your
benefit
You
offerth
con
eusers
venienc
ewitha luxurious
beingm
djus
adealm
ostauto tments
maticall
y
Manage Designer properties via code
Experience boundless opportunities,withthedynamiccrea-
How about a project assistant thatadaptstheprojecttem-
tionofprojects,withyourownprojectwizardoraslimmed-down
Designer.With.NETandVCLitisexceptionallysmooth,anditworks
justaswellwithotherprogramminglanguages.Alternatively the
other way round!Properties,individualobjectsandevencompleteprojectscanbesimplygeneratedasDOMcodefor.NET.
platestotheenduser'srequirementsevenbeforetheDesigner
opens?Thatmeans,forexample,thatanenduseronlyselectscertainfieldsfromyourdatabaseforaninvoice,andbyopeningthe
Designer,theinvoiceprojectispracticallyreadywithaddressfield
anditemlistalreadyfilledout.
“Createanewprojectincludingareportcontainerand
table,calledProducts,andfields”,hereinC#:
Inthismanner,allsumvariablescanbeoutput,hereinDelphi:
Proj.Open(@"c:\Reports\product.lst", LlDomFileMode.Create,
LlDomAccessMode.ReadWrite, true);
domPrjList.Open('article.lst',
DomObjectReportContainer container=new
DomObjectReportContainer (Proj.Objects);
container.Position.Left = "0";
container.Position.Top = "0";
container.Position.Width = "150000";
container.Position.Height = "200000";
DomSubItemTable table = new DomSubItemTable
(container.SubItems);
table.TableID = "Products";
DomTableLineData dataLineNew = new
DomTableLineData(table.Lines.Data);
dataLineNew.Name = "Created dynamically" ;
DomTableFieldText textCol = new
DomTableFieldText (dataLineNew.Fields);
textCol.Contents = "Product.No" ;
DomTableFieldBarcode barcodeCol = new
DomTableFieldBarcode (dataLineNew.Fields);
barcodeCol.Contents = "Barcode(Product.No, 'PDF417')";
Proj.Save();
Proj.Close();
fmOpenOrCreate);
for i := 0 to domPrjList.SumVariableList.Count - 1 do
ShowMessage(domPrjList.SumVariableList[i].Name + '=' +
domPrjList.SumVariableList[i].Content);
domPrjList.Close;
Thisishoweachfirstparagraphofatextobjectisoutput:
domPrjList.Open('article.lst', fmOpenOrCreate);
for i := 0 to domPrjList.ObjectList.Count - 1 do
begin
if domPrjList.ObjectList[i] is TLlDOMObjectText then
ShowMessage((domPrjList.ObjectList[i] as
TLlDOMObjectText).Paragraphs[0].Contents);
end;
domPrjList.Close;
*intheProfessionalandEnterpriseEdition
15
15
Output
Print :: Print preview :: Export
Everythinginonedialog
Export&Sign
The output options withList&Label
Export & Sign. Toprovideyourcusto-
areclassicprinting,printpreviewand
export.
mersanduserswithdigitalsignatures
functionality,wegottogetherwiththe
peoplefromsecryptande•siqiatosupporttheirdigitalsignaturesdirectlyfrom
List&Label.Theprerequisiteis,ofcourse,
thatdigiSeal®officefromsecryptGmbH
orOPENLIMIT®SignCubessoftwareplus
licensekeyfrome•siqiaHoldingAGare
installedontheuser'scomputer.
The differencebetweenthesethreeis
onesingleparameter,therestisdone
automatically.Alotofaddedvaluefor
yourapplication,whichyoumakeeasily
availabletotheendusers!Moreonthis
topiconthefollowingdouble-page.
e
d
co
1
w+
Exp
+P
ie
rev
nt
Pri
16
=
ort
s
PDFfile
Signed
Inprinciple,yousignmulti-TIFFs,textfiles
andPDFs.Dependingonthesignature
type,theresultcomprisesoneormore
files.Youchangethesignatureformatby
API.Therecipientcanalwayschecktosee
ifanythingsincethesignaturehasbeen
created.Tothispurpose,secryptand
e•siqiahavemadesignaturevalidators
availablefreeofcharge.
Programming Examples
Printing :: .NET :: Delphi :: C++ :: Visual Basic
.NET
C++
Visual Basic
private void button2_Click(object sender,
System.EventArgs e)
{
try
{
// Link to a DataSet object
LL.SetDataBinding(myDataSet, "Orders");
//==============================
void CMainFrame::DoLabelPrint()
//==============================
{
// Normal text variable
LLDefineVariableExt(job, "Text","Testtext",
LL_TEXT, NULL);
Private Sub ButtonPrint_Click()
// Set properties (optional)
LL.AutoDesignerFile = "supreport.lst";
LL.AutoProjectType = LlProject.List;
LL.AutoDialogTitle = "example";
LL.AutoShowSelectFile = true;
// Numeric variable
LLDefineVariableExt(job, "Subtotal",
"12.34", LL_NUMERIC, NULL);
}
// Catch exceptions
catch (ListLabelException LlException)
{
MessageBox.Show("Information: " +
LlException.Message,"Information",
MessageBox.IconInformation |
MessageBox.OK);
}
Private Sub ListLabel1_CmndDefineFields(ByVal
nUserData As
Long, ByVal bDummy As Long,
nProgressInPerc As Long, pbLastRec
As Long)
// variable graphics via file names
LLDefineVariableExt(job, "Image",
"logo.bmp", LL_DRAWING, NULL);
'This event is triggered by the print
'and design command. It is called for each
'data record in order to transfer fields and
'their content to List & Label
'Repeat for all fields
'belonging to a data record:
For i = 0 To
Form1.Data1.Recordset.Fields.Count - 1
content$ = Data1.Recordset.Fields(i)
nRet = ListLabel1.LlDefineFieldExt _
(Data1.Recordset.Fields(i).Name,_
content$, LL_TEXT)
Next i
'Go to next data record
Form1.Data1.Recordset.MoveNext
'If there are no more data records
'printing is ended.
If Form1.Data1.Recordset.EOF = True Then
pbLastRec = 1
End If
// Start printing
LlPrintWithBoxStart(job,
LL_PROJECT_LABEL, szFile,
LL_PRINT_EXPORT,
LL_BOXTYPE_BRIDGEMETER, hWnd,
"Printing...");
}
//Print label
LlPrint(job);
Delphi
{Call up print}
procedure TForm1.PrintButtonClick(Sender:
TObject);
begin
//Assign data source
LL.DataSource := dsCustomers;
End Sub
// Barcode variable
LLDefineVariableExt(job, "BC_EAN_128",
"123456789abcd",
LL_BARCODE_EAN128, NULL);
// Start printing
LL.Print();
}
// End printing
LlPrintEnd(job,0);
//Set standard project names
LL.AutoDesignerFile := 'subrep.lst';
//Set print mode to PreviewControl
LL.AutoDestination := adPreview;
//Print
LL.AutoPrint('Invoice List', ");
end;
'Prints the project "test.lst" on
'printer
Data1.Recordset.MoveFirst
ListLabel1.Print(0, LL_PROJECT_LIST,
"test.lst",_True, LL_PRINT_NORMAL,_
LL_BOXTYPE_NORMALWAIT, hWnd,_
"Print, True, Environ$("temp"))
End Sub
Your
benefit
Aloto
fadded
for
valuea
th
ndflex
trouble eenduserwit
involve
hlittlet ibility
dforyo
imeand
u.
17
Print Preview
Check :: Print :: Send :: Export
Realdatapreviewwithindex
The previewcanbeused1.integrated
intotheDesigner,2.separatelyintegratedintoyourapplicationor3.asa
standaloneviewerapplication.Anyway,
hereyouzoomsmoothlyintothepageto
controlitandstartprintingorexportingrightaway.Evenforlargeprojects
yougetresultsinnexttonotimeasyou
checkoutthefirstpagewhiletheprint
jobisstillrunninginthebackground.
Preview features



18
Drilldownreporting




reate presentationsdirectlyfrom
C
yourreports,evenfull-screenincludingthetypicalslidetransitions
se the inplace preview control
U
that’spartofthecomponentforyour
owndialogs
Integrate the WPF viewerseamlesslyintoyourWindowsPresentation
Foundation/application
djust the internet viewer–a
A
specialOCX/ActiveXobjectthathasa
digitalsignature–variablytoyourneeds
Save the previewandsenditby
Drilldown reporting isbeingdefined
mailtosomeonewhoperhapshas
onlytheviewer
Create an index thewayyouare
usedtowithPDF
Create interactive formsbysimply
positioningaformcontrolinthe
Designerwheretheuserentersdata
inthedesigningmodebutcomesinto
fulloperationinthepreview.Herethe
endusersclicktheirwaytowardssuccess
withinrelationaldatabasesandsafelynavigatethroughevenrougherhierarchical
data.Theitemsdrilledoutlastarethen
senttotheprinterorintoanexportfile.
Learn more www.combit.net/en/drilldown
Additional output features bring
yourreportingforward:



Dispatch via e-mail ::Sendpreview
andexportfilesdirectlyviaMAPI,
XMAPIorbySMTP::Compresspreviewfilesasyourequire::Texte-mail
withattachmentorhomogenous
HTMLe-mail
Monitor print job::Aftertransfer
tospooler::eventsinthe.NET,VCL
andOCXcomponents::otherwisevia
callback
Endless labels and endless forms
::Insteadoflayout-orientedtext
exportsendtextdirectlytothematrix
printer,pasttheprintdriver::optimal
performancewhenusingendless
labelsandendlessforms
Export
PDF :: HTML :: Excel :: RTF & Co
Export Formats
PDF export::PDF/A-a1standard,foundationforarevision-securearchiving::fast
::handysizefiles::supportforCID-keyed
fonts::upto128bitencryption::optionallyalloworforbidindividualprinting,
processingandcopyingevents::inorder
tooptimizethefilesize,embedfonts,
oroptionallyonlytheusedcharacters::
hashingofidenticalimages
PDFExportresultinAdobeReader
HTMLexportresultinInternetExplorer
RTF export::Textpositionisalsopossible
viatextboxesforoptimalfurtherprocessinginWord
Excel export ::Optionally,simpledata
export:Tabledataimportedtoonespreadsheet;youprocessaregularExcelproject
::optionally,adoptfulllayout:render
thevisualappearanceastruetodetailas
possible::withoutanyOLEmechanisms,
thereforeindependentofanExcelinstallation::optionallyoneworksheetperpage,
withnamingthroughout
RTFexportresultinWord
XPSexportresultinInternetExplorer
HTML export::CascadingStyleSheet
(CSS)tagsfortableframesandtoensure
visuallyappealingresults,inparticularin
individualframeformatting
MHTML::IncomparisontoHTML,the
resultfilecontainsdataandimages
Co
mp
reh
en
Text export::Eitherpurelydata-oriented
:creationofalmostanyCSVfiles(data
conversion)::orlayout-orientede.g.for
matrixorcontinuousprinter
siv
ee
xpo
rtf
TIFF / Multi-TIFF::Differentcompression
typesandqualities
orm
ats
Additional formats::XML::JPEG::BMP
::EMF::TTY::ZIP::XPS
19
International Projects
Unicode/Multibyte :: Designer in different languages :: Localization of project files
Localizationofprojectfiles
List & Label makes it easytomaster
Certainly available in version 15
internationalmarketsandenjoycompetitiveadvantages.You'llfindwe'vethought
ofeverythingyouneed.
areEnglish,French,German,Italianand
Spanish.ExpectedtobeavailableareDanish,Dutch,Polish,Portuguese,Russian
andCzech.
The unicode-/multibyte capability
InformationasofNov2009.Pleasecontactusifthe
languageyourequireisnotlisted.
enablesyoutodesign,outputincl.partly
exportforexampleAsianorRussiancharacters,orbothinonereport.
esigner language kits complement
D
theDesignerwithmanylanguages.This
makesyourapplicationfitformulti-lingualteamsandinternationalmarkets.The
launchdatesofthesekitsdependonhow
versionsarereleasedaswellaspartlyon
cooperationwithourpartners.
20
SwitchDesignerlanguage
Allavailablelanguagekitsareincludedin
theEnterpriseEditionandcanoptionally
bepurchasedfortheStandardandProfessionalEditions.
transferredforeachlanguageviatheAPI,
oryouswitchonrealdictionariesortranslationtablesthatyouarealreadyusing.
Thissavesyoualotoftime.Forthesame
projectfile,theenduserintheU.S.sees
theword"ProductName"andinGermany,
"Produktname".Thisworksevenwhenthe
projectismodifiedinGermany,saved,and
subsequentlysenttotheU.S.-theprojectitselfonlymakesuseoflanguage-independentabbreviationsor,forexample,
theEnglishnames.
Localization of project files. Projects
Encrypting project files. Particularly
aredesignedinaspecificlanguageand
welcomeusersintheirownlanguage.
Torealizethisprocess,adictionaryis
whenyoudon'twanttheDesignertobe
availableforusers,youcanprotectyour
List&Labelfilesviaapassword.
el:
e
P
e
hth t
a
e
ils
ern
Und ingDeta
s
Licen
21
Let Us Back You Up Or
Do It Yourself and Save
Details about the List & Label license
You have the choice of three editions,
fromthesavingofanentry-leveleditionto
theconcentratedpowerinanall-inclusive
carefreepackage–thereissomethingto
suiteveryone.ThesubscriptionsProfessional andEnterprise includenewversions,
asupportflatrateandmanymorebenefits
(seetable).Qualitycoupledwithsecurity
–it'ssosimple!AndwiththeStandard Edition it’sknowledgebaseandnewsgroups
forfree,whereasthetheservicesprovided
byourSupportTeamaresettledonatime
andmaterialbasis.Andwhenit’stimefor
anewversion,youdecideinfavorofanew
upgradeornotoryoudon’t.
The subscriptions Professional Edition and Enterprise Edition include all
ServicePacks,allfeature-upgradesandall
upgradestomajorversions*duringthe
periodofvalidity.Wearealsoavailable
byphoneande-mailduringouroffice
hours**toansweryoursupportquestionsonaflatratebasis.
The time period of validity of your
subscriptionandtherelatedsupport
isoneyear.Ifyoudonotcancelthe
subscriptionatatimeperiodofnoticeof
3monthstotheendofthiscontractual
year,itisautomatically renewedby
anothercontractualyear.Youdon’thave
toseetoit.
theyhavenotbeencalculatedsoasto
enablelargeprojectswithmaybetens
ofthousandsofenduserstobecovered
byasinglelicense.Wecomplywiththe
numberofdevelopersinvolvedandoffer
attractivevolumediscounts.Aproject
groupmustdecidewhichoftheeditions
theyallwanttogofor.
List & Label is a license for one
developer. Individual,non-transferable,
Appliance on servers or web servers
foronedeveloperforinstallationonone
computeroralternatelyforuseonone
notebook(Professional+Enterprise).We
offerattractivediscountsfordeveloper
teams.Youalsoneedseverallicenses
ifyouwanttoencapsulateList&Label
functionse.g.fromyourownDLLs/components,whichisnotcoveredbyour
standardlicenseagreement.Thiscanbe
easilymodifiedwithanadditionalagreement.Don'thesitatetocontactourSales
&ServiceTeam.
Important. Youneedalicenseforevery
*CDpurchase–servicepacksandinterimupgrades
areavailableviadownload,allmajorversionsaresent
toyouonCD.Downloadpurchase–geteverything
bydownloadaswell.
**Oursupportteamcanbereacheddirectlyfrom
9amto12amand2pmto5pm(CET)byphoneor
e-mail.Outsidethesehours,whenreachingourSales
&ServiceTeam,youmayaskforacall-back.
22
Als
Subs o as a
and cription
Su
Pack pport
age
developerwhoisinvolvedintheoverall
projectand/ortheoverallproductin
whichList&Labelisintegrated.Inthis
respect,itisirrelevantwhetheradeveloperusesList&Labelfunctionsornot.
Ourbasicconditionsarefair,however
issubjecttoalicensefeeforthe StandardandProfessionalEditions.Foreach
applicationinstallationthatutilizesan
internetprotocolforexample,orisaweb
serverextension,orisintegratedinASP
orPHPpages,orisanindependentserver
application,yourequirethecorrespondingserver/webserverlicensesifyouuse
theStandardorProfessionalEdition.The
EnterpriseEditionincludesaserver/web
serverlicenseflatrate.
Please find the combit license
agreement atwww.combit.net/en/
licenseagreementandthemostfrequentlyaskedquestionsontheList&Label
licenseatwww.combit.net/en/Licensefaq.Werecommendthatyoureadboth
carefully.Ofcoursewearealsohappyto
answeryourquestionsconcerninglicensinginperson!T+497531906010
rer
i
ort d
Designer for end users of most desktop applications – see license agreement for restrictions
Use in most server / web server applications: add-on server/web server licenses
Print, preview and export in all supported formats
Programmer’s reference and Designer user manual, PDF file
Designer documentation as DOC/PDF file, Designer help as source file
Service Packs for one year, access to knowledge base, newsgroups and RSS feed for Service
•
•
•
•
•
•
•
•
•
•
Service Packs for all versions while subscription is valid, access to knowledge base, newsgroups and RSS feed
Subscription for one year incl. feature-upgrades. Automatic renewal, termination up to 3 months before end of year
Support flat rate for one year, available via e-mail and telephone directly from German manufacturer
Support on a times and materials basis, € 45/15 minutes plus VAT, via e-mail and telephone
Unicode module for international character sets
•
•
•
•
•
Designer in different languages: add-on language kits
15% discount on add-on language kits
DOM (object model)
Alternate usage on one developer notebook permitted
•
•
•
•
•
•
•
•
•
•
Formula assistant independent of List & Label
Preferred handling for support
15% Discount on training and customization
Exclusive preliminary information on new major versions
Participation in beta program of new major versions
Watermark on on each printout and export file
•
on
rp
ris
e
Ed
iti
di
•
•
•
•
•
•
•
•
2D barcodes PDF417, Maxicode, DataMatrix/EC200, Aztec and QR-Code
•
•
•
•
•
•
•
All available language kits, at least English, German, French, Italian, Spanish
64-Bit Version
En
•
•
•
te
es
of
•
•
•
Use in most server / web server applications: flat rate
Applicable with all supported programming languages, all examples available
na
lE
sio
rd
da
Pr
•
an
Designer for developers
St
List & Label 15 Editions
Fr
ee
Ed
i
tio
n
Ed
i
tio
n
tio
n
Supp
an m
rm
e Ge
m th
y fro
rectl
actu
anuf
•
•
•
•
•
•
•
•
•
•
•
First year
€0
€ 650 € 1200 € 1800
Renewal
Upgrade to new major version
€0
€ 390 incl.
€ 600
€ 900
incl.
all prices plus VAT.
23
Selected customers
Any questions?
Squeeze us for
information!
Aareon (GER) (FRA)
Austrian Post (AUT)
Boehringer Ingelheim (GER)
Bosch Rexroth (GER)
Bureau of Labor Statistics (USA)
Canadian Department of National Defense (CAN)
Ciba (SUI)
Deutsche Automobil Treuhand (GER)
Deutsche Post (GER)
Draeger Safety (GER)
German Red Cross (GER)
e.on (GER)
Fleurop-Interflora (SUI)
Hitachi (USA)
Lidl Foundation(GER)
Lear Corporation (GER)
Lufthansa Systems (GER)
Mettler-Toledo (SUI)
MTU Friedrichshafen (GER)
Quantum (USA)
Sage bäurer (GER)
Shell Oil Products (USA)
Siemens, (GER)
Triumph International (GER) (SUI)
Tupperware Germany (GER)
Volkswagen Sachsen (GER)
More at: www.combit.net/en/LL-Clients
© combit GmbH 2009,subjecttochangesandpossibleerrors!Thiscontentis
onlyadescriptionanddoesnotrepresentaguaranteeforthequalityoftheproducts.Pleasenotethatwiththethird-partyproductversionsthatarementioned,
differentreleasesmayoccurwithotherfunctions.Wethereforerecommendtrying
outourfree-of-chargetestversioninordertoavoidanypossibleproblemsin
advance.Allnamedproductsandproductdescriptionsaswellaslogosarebrands,
registeredtrademarksorthepropertyoftherespectivemanufacturer.
www.combit.net/en
combit GmbH
Untere Laube 30
78462 Konstanz
Germany
Sales & Service Team
T +49 (0) 7531 90 60 10
F +49 (0) 7531 90 60 18
[email protected]
Index
A
Access 6
ActiveX 18
AcuCobol 6
ADO Record set 5
Alaska Xbase++ 6
Asymetrix Toolbook 6
B
Barcode 3, 13
BDE 5
64-Bit 6, 23
C
C++ 5-7, 17
C/C++ | Examples VC++ 6
Centura SQL 6
Charts 2, 10, 12
C# | special .NET Component 6
Clarion 6
Cobol 6
D
Database driver 3
Database fields 3
Database independence 5
Data binding 3, 5
Data fields 3
DataReader 5
DataSet 7, 17
DataTable 5
DataView-Manager 5
Delphi 5-7, 15, 17
Designer 3-5, 7-15, 18, 20-23
Designer language kits 20
Designer Object 12
Desktop applications 3, 4, 22, 23
Diagrams 2, 12
Dialog design 4
DOM 15, 22, 23
Drag & Drop 4, 8
Drillddown 10, 18
DTP control 9
M
E
O
E-mail 18, 22, 23
Endless forms 18
Endless labels 18
Excel 6
Export 2, 3, 8, 16, 18-20, 23
Export formats 3, 19
F
Format editor 8
Forms 2, 8, 9, 18
Formula wizard 8, 23
I
Included projects 9
International projects 20
J
Java 6
L
Labels 2, 9, 12, 18
Layout regions 8
License agreement 22, 23
License fees 3, 4, 18
Licensing details 21
LINQ 5
List & Label 15 Editions 23
Lists 2, 5, 8
Lotus Script 6
Multi tables 2, 10
MySQL 5
N
.NET 3-8, 10, 14-18
OCX 7
OleDb 5
OLE object 14
Output control 8
P
PDF export 19
Positioning grid 9
PostgreSQL 5
PowerBuilder 6
Presentations 9
Preview 2, 3, 8, 9, 16, 18, 23
Print 2, 3, 5, 8, 9, 16, 18, 23
Programming examples 7, 15, 17
Programming languages 8
Progress 6
Project files 20
R
RAD Studio 2010 6
Real data preview 4, 8, 18
Report container 8, 10, 15
Reports 2, 5, 8, 10, 12, 14, 15
RTF control / RTF object 14
Runtime 3, 4, 5
S
Sign16
SQLite 5
SQL Server 5
Subreports 2, 10
Subscription 3, 22
Sum variables 9
Support 3, 16, 22, 23
T
Table object 11
TDataSource 5
U
Unicode-/multibyte capability 20
V
Variable names 9
VCL 5-8, 10, 14, 15, 18
Visual Basic 6, 7, 17
Visual Basic .NET 6
Visual C++ 6
Visual DataFlex 6
Visual dBASE PLUS 6
Visual FoxPro 6
Visual Objects 6
Visual Studio 2010 6
W
Web reporting 2, 5
Web server 3-5, 18, 22, 23
Windows 7 6
WinWord 6
WPF viewer 18
X
XML 5