List & Lab el 1 5
Contents
1. Content 10 12 13 14 15 16 17 18 19 20 22 24 Reporting Tool List amp Label 15 100 Reporting Power Your Benefits at a Glance The Program s Heart from a User s Viewpoint List amp Label Functional Principle Application Programming Examples The Designer in Detail Designer Objects Table Crosstab amp Co Designer Object Chart Designer Barcode Object More Designer Objects Object Model for Projects DOM Output Programming Examples Print Preview Export International Projects Let Us Back You Up Or Do It Yourself and Save Contact selected customers What does a lime have to do with a report component List amp Label is refreshingly different easy to handle universally applicable and absolutely vital for your appli cation Or perhaps we just liked the color 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 function ality Why not start with one of the provided examples Kind regards and wishing you success Christiane K rdel Managing Director combit GmbH Component List amp Label 15 100 Reporting Power Quickly and easily embed List amp 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 Fo2. wr In this manner all sum variables can be output here in Delphi domPrjList Open article lst fmOpenOrCreate for i 0 to domPrjList SumVariableList Count 1 do ShowMessage domPrjList SumVariableList i Name domPrjList SumVariableList i Content domPrjList Close This is how each first paragraph of a text object is output domPrjList Open article lst fmOpenOrCreate for i 0 to domPrjList ObjectList Count 1 do begin if domPrjList ObjectList i is TL1DOMObjectText then ShowMessage domPrjList ObjectList i as TL1IDOMObjectText Paragraphs 0 Contents end domPrjList Close in the Professional and Enterprise Edition 15 Output Print Print preview Export i Signature task EEE aa wa F Status ol the cediicate t bocal siratine veslicston ee E Prien Options Select printing optom Export Meds Shenge gt baicresem XPS Decwenent Writer 1 Preview iz Drect to P i s A Preview GJ Fe iad HTML Format Optom aas TA Munire HTML Format F HnePege T Adobe POF Format 5 Barnes as Pogat vaca ENP s Ah PEG Picture Banget Fi mni THF Premure Gram page oe enge ay Format RTF pert rs T Rich Tet 134 Gh Pirena OTV mC Tent Format Prigi Fenner l fort Everything in one dialog Export amp Sign The output options with List amp Label Export amp Sign To provide your custo In principle you sign multi TIF
3. Format editor 8 Forms 239 9 io Formula wizard 8 23 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 amp Label 15 Editions 23 Lists 2 5 8 Lotus Script 6 M Multi tables 2 10 MySQL 5 N NEI sco TO TARS O 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 PAM 2 Sis oy Sy et 1s VAs 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 Sign 16 SQLite 5 SQL Server 5 Subreports 2 10 Subscription 3 22 Sum variables 9 suppor 3 e 22 25 T Table object 11 TDataSource 5 U Unicode multibyte capability 20 V Variable names 9 VCE 5 3 10 14 15 ls 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
4. GER Triumph International GER SUI Tupperware Germany GER Volkswagen Sachsen GER More at www combit net en LL Clients combit GmbH 2009 subject to changes and possible errors This content is only a description and does not represent a guarantee for the quality of the pro ducts Please note that with the third party product versions that are mentioned different releases may occur with other functions We therefore recommend trying out our free of charge test version in order to avoid any possible problems in advance All named products and product descriptions as well as logos are brands registered trademarks or the property of the respective manufacturer 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 He a7 17 COREA Ee N Gt Centura SQL 6 Charts Oe 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 Delohi 5 7 15 17 Designer 3 5 7 15 1820723 Designer language kits 20 Designer Object 12 Desktop applications 3 4 22 23 Diagrams 2 12 Dialog design 4 DOMED TS Drag amp Drop 4 8 Drillddown 10 18 DTP control 9 E E mail 18 22 23 Endless forms 18 Endless labels 18 Excel 6 Expor 2 a 9 e TTo 20 2 gt Export formats 3 19 F
5. All available language kits are included in the Enterprise Edition and can optionally be purchased for the Standard and Pro fessional Editions Localization of project files Projects are designed in a specific language and welcome users in their own language To realize this process a dictionary is ada ee tee Seg bate Or Switch Designer language transferred for each language via the API or you switch on real dictionaries or trans lation tables that you are already using This saves you a lot of time For the same project file the end user in the U S sees the word ProductName and in Germany Produktname This works even when the project is modified in Germany saved and subsequently sent to the U S the pro ject itself only makes use of language in dependent abbreviations or for example the English names Encrypting project files Particularly when you don t want the Designer to be available for users you can protect your List amp Label files via a password 22 Let Us Back You Up Or Do It Yourself and Save Details about the List amp Label license You have the choice of three editions from the saving of an entry level edition to the concentrated power in an all inclusive carefree package there is something to suit everyone The subscriptions Profes sional and Enterprise include new versions a support flat rate and many more benefits see table Quality coupled with security it s
6. Designer LLDesignerProhibitAction job 211 Start the Designer with the above fields LLDefineLayout job hWnd Title LL PROJECT LIST szFile Visual Basic Private Sub ButtonDesign Click starts the Designer with the title Invoice and the file Invoice 1lst ListLabell Design 0 hWnd Invoice LL PROJECT LIST Invoice lst 1 End Sub The Event ListLabell CmndDefineFields is used for the data definition The Designer in Detail Intuitive Operation Comprehensive Universal Report structure is 3 ex amp a Report Container fT Table Categories 1 ME Table Products CategoriesdProducts FE Crosstab Products Categories2Praducts ta Chart Employees a Table Shippers a T Table Orders Shippers20rders oc fal Table Order_Details Orders2Order Details Flexible report structure ay Variables yy Project variables a wD Field GOLUL E Categorie 3 Customers o E Employees ils ie ey Order_Details CrderD lt gt Orders OrderlD Ga Products Order Details Productii lt gt Products Product Variable list Even first time users become quickly familiar with the intuitive handling via Drag amp Drop A whole page Is a whole page and not a conglomeration of diffe rent sections Rulers ruler guides zoom grouping functions and other well known helpers make it easier for you and the end users Real data preview Is directly in tegrat
7. best thing about it is that the 2D barcode QR read by newer cell phones Additional 2D barcodes in the Professional and Enterprise Edition recs EE WANN te DYER APENDO eS NS ict MEM RUHL AM attat pore ny aa Cutting edge GS1 barcodes More Designer Objects RTF OLE own HTML Text Graphics RTF Editor With the RTF Designer object you generate not only reports but also serial letters and similar Since it is possible to link several RTF objects and have them overlap each other the number of possi ble layout options is truly amazing This includes multiple columns image and table circulations Use the RTF control to offer end users a small word processor for example Start the RTF Editor as an independent control or integrate the Inplace Control as part of the NET VCL and OCX components in your dialogs This way you may keep the end users away from the Designer for example and allow text input only via RTF control gt vour application Designer Desktop m application Word document in the OLE container The OLE object is a container for OLE server documents This is how you inte grate Word Excel and Visio files and benefit from their functionality A double click in the Designer activates the respec tive program modifications are displayed immediately As a matter of principle only single page documents Your own objects can be
8. catch ListLabelException LlException MessageBox Show Information LlException Message Information MessageBox IconInformation MessageBox OK Delphi Call up print procedure TForm1 PrintButtonClick Sender TObject begin Assign data source LL DataSource dsCustomers Set standard project names LL AutoDesignerFile subrep 1lst Set print mode to PreviewControl LL AutoDestination adPreview Print LL AutoPrint Invoice List end Normal text variable LLDefineVariableExt job Text Testtext LL TEXT NULL Numeric variable LLDefineVariableExt job Subtotal 12 34 LL NUMERIC NULL Barcode variable LLDefineVariableExt job BC EAN 128 123456789abcd LL BARCODE _EAN128 NULL variable graphics via file names LLDefineVariableExt job Image logo bmp LL DRAWING NULL Start printing LlPrintWithBoxStart job LL PROJECT_LABEL szFile LL_PRINT EXPORT LL_BOXTYPE_BRIDGEMETER hWnd printing Print label L1Print job End printing L1PrintEnd job 0 Visual Basic Private Sub ButtonPrint Click Prints the project test 1lst on printer Datal Recordset MoveFirst ListLabell Print 0 LL_PROJECT LIST test 1lst True LL PRINT NORMAL _ LL_BOXTYPE_NORMALWAIT hWnd _ Print True Environ S temp End Sub Private Sub ListLabell_ CmndDefineFields ByVal nUserData As Long ByVal bDum
9. example Declaration file 1 example Up to Date System software technologies Y 64 Bit Y Visual Studio 2010 Y RAD Studio 2010 a Windows 7 Compatible with ee bat r Label C8 Bengear Pe ennont Eergie Dere Dpp ag Sa Enapirung des Drapa it Cal ug The een shores fre giera of the See h EE Viisi OOo j aon Pees ee appa is ol Betacam Paeit at ashen wm 9 oe x the Tous ty QO ee fee te Seh ee i FD b B 90OeG ee p Nmb y 5 swe aks Senn w ta tsl 1 pee E Lt Seater batining Sore 3 meem bwn ve Dadar Cahemes iaat mad oust Desi mags s d at Dega i ence 5 POr be ane re fps amp mes Senge seven a rer u panpinen oeat asap dta dabai kand Ld E La content a todd ariera ma n t ft madras of its fo be Wee eens 7 aoma mrchespette ow welt serves z coan S naroot mapami ee MTOE NITS Pet eahiteal and with RAD Studio 2010 Professional and Enterprise Edition For restrictions see Programmer s Reference As of October 2009 List amp Label can be integrated into all languages that support DLL calls Please let us know if you think something Is missing T 49 7531 90 60 10 Programming Examples Starting the Designer NET Delphi C Visual Basic NET protected void buttonl Click object sender System EventArgs e try Link to a DataSet object LL SetDataBinding myDataSet Order
10. the database driver twice and the direct use of business objects is easily done Stability Your reports continue to be fully operational when e g an end user adds a field to the database Several databases one report This saves time and ensures that your application can be used universally Lean redistribution Redistribution is a snap and the package Is so handy You re ready to go with approximately 20 MB Application NET C Delphi amp Co Programming languages and development environments aib die Ee JEA due SEE Ee JEA Je ae e a a a a a A ye A a A G a HOH OF O O N n O O E W T WET Access AcuCobol Alaska Xbase Asymetrix Toolbook 4 C special NET component C C examples for VC C Builder Centura SQL Clarion 4 Cobol Delphi Delphi Prism special NET component Excel VB partially applicable Java Lotus Script PowerBuilder 4 Progress Visual Basic 8 Visual Basic NET special NET comp WSU CHi Visual DataFlex Visual dBASE PLUS 4 Visual FoxPro Visual Objects WinWord VB partially applicable NET component 14 examples respectively Declaration file 2 examples Declaration file 3 examples Declaration file Declaration file 10 examples VC VCL 19 examples Can be integrated Declaration file 14 examples VCL 10 examples JNI DLL 2 examples NET component 1 example Own component 1
11. Fs text files are classic printing print preview and mers and users with digital signatures and PDFs Depending on the signature export functionality we got together with the type the result comprises one or more people from secrypt and e siqia to sup files You change the signature format by The difference between these three is port their digital signatures directly from API The recipient can always check to see one single parameter the rest is done List amp Label The prerequisite is of course if anything since the signature has been automatically A lot of added value for that digiSeal office from secrypt GmbH created To this purpose secrypt and your application which you make easily or OPENLIMIT SignCubes software plus e siqia have made signature validators available to the end users More on this license key from eesigia Holding AG are available free of charge topic on the following double page installed on the user s computer oF t les CS Signed poi on A mS Programming Examples Printing NET Delphi C Visual Basic NET private void button2_Click object sender System EventArgs e try Link to a DataSet object LL SetDataBinding myDataSet Orders Set properties optional LL AutoDesignerFile supreport 1lst LL AutoProjectType LlProject List LL AutoDialogTitle example LL AutoShowSelectFile true Start printing LL Print Catch exceptions
12. German manufacturer e Support on a times and materials basis 45 15 minutes plus VAT via e mail and telephone e Unicode module for international character sets o Designer in different languages add on language kits 15 discount on add on language kits j All available language kits at least English German French Italian Spanish B 64 Bit Version s 2D barcodes PDF417 Maxicode DataMatrix EC200 Aztec and QR Code DOM object model e e Alternate usage on one developer notebook permitted Formula assistant independent of List amp Label o Preferred handling for support 15 Discount on training and customization o Exclusive preliminary information on new major versions o Participation in beta program of new major versions Watermark on on each printout and export file First year Renewal Upgrade to new major version all prices plus VAT 23 Selected customers 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
13. bat det ee Ss SERS es Ti Item list cont p baii Sanie g Multiple column tables able Object Designer Object Chart Diagrams Lines Pie charts Bars Cone diagrams Octahedron diagrams i d Simple Simple GD UNE Clustered GO Stacked GD 100 Stacke ee P ts in Bar Chart stomer over the years for example Choose ear as the source of ercu x Multi row Tashowthaarmaunt oe of the y axis and Sales 35 the source of the 2 axis the x axis Custorner as the source Primary Ayas Data Calculation Mode Value Maamum Value Automatic Chart definition Category Axis G Series Ais y i Value Axis 2 Diagram i Object Colors j bccn Use Diagram gt Secondary Avis to enable Sum of Values 0 ity Order Details UnitPrice x Order_Details Quantity Order None Linear 0 Yes Yes The chart function makes your reports sparkle The data for reports and charts are usually only prepared once Labeling directly in the chart The charts can be rotated around both axes there are bar charts vertical and horizontal pie charts cone charts octa hedrons lines and variants in 2D 3D multi row clustered stacked or as a simple version Choose fixed colors see Horizontal bar charts pie charts in an exploded view label charts pri
14. ccessed by IDbCommand objects mean ing all ADO NET data sources including the relations between them On top of that we have disclosed and documented the interface that needs to serve a data provider object of that type so you can easily connect other data sources to List amp Label yourself An excellent help feature provides additional assistance for quick implementation VCL Whether ADO Record set or BDE each derivative from TDataSource can be easily linked Here too the master de tail relations are automatically evaluated and transferred Data database user data measurement values Database independent use in a typical desktop appli cation your application passes on the data to List amp Label Database independent Print Preview Export A f gt Your Application b gt LiL Designer Desktop Application It s quickest with data binding of course But database independence has consider able advantages and mass appeal for many years With this way of use your applica tion passes the data to List amp Label If it is a server or web server application you only need to plan an interface to create the reports Conceptual advantages of List amp Label Direct data transfer You are completely independent of specific database formats You control the data transfer and create the interface your self You may ad fields and variables in the databinding mode too Pure speed No need to load
15. d StandardCost A sy i Weight i A WeightUniMeasuret Filter a ProductCategory GApprarance OF ModifiedDate E Default Frame A Name E Others 2780 82 A The List amp Label Designer with integrated real data preview Everything a reporting heart desires universally deployable With the List amp Label Designer you In all three editions Standard Profes enhance your application quickly and sional and Enterprise you may pass on easily to include powerful functions You the Designer with most desktop applica provide the end users with the freedom tions without paying extra license fees and flexibility they need and ensure a In the Enterprise Edition runtime is also competitive edge The time and effort included for most server web server appli required is kept remarkably low cations Find out more at www combit net en Licensing List amp Label Functional Principle Data transfer Data binding Database independence Components Providers SQL EID o Oracle XML MySql LINQ PostgreSQL ADO NET SQLite DB2 Data binding for NET There are providers for the most databases Your job consists of only 6 lines of simple code With databinding NET List amp Label 15 accesses the most important databases directly Included are providers for SQL Server Oracle MySQL PostgreSQL OleDb XML LINQ DB2 SQLite and for all databases that can be a
16. d OCX components Ns format purer setres Murrise C vm Tare xa nemi Date end Tere Mb Mae Mey Dercertingt Si pee Dute Tena Cittonente HOES aie n wy 99 20 3008 iene swan ie poe WA ey MD m Brasenye pare x ema eel O eee a memon ta Lm am pene bunt iow Ta Creel Appewence Landeee Mina ie sana E anghy ot We gue at tn d pst ail be wot Included Projects The end user won t be able to tell them apart from the List amp Label functions In the format editor simply select per sample That s what Office end users are accustomed to Included Projects save time when object groups occur unchanged in several different projects e g letter heads i0 b a Lig 7 iad wt ella Fa Fal a p i l m ni 0 A y itat a T E Be i brini li ol i i 7 a pinea peA TEET ay ates E _Item no EXP E Southern Africa Explorer 20 day tour from Cape Town to Victoria Falls excluding flight 15 hee 20 i het eae et i ells ea bal 30 yan pulse sestetale tat ees ra emr tate Additional F Features of the Designer 4 rT mi x 22 W ee Bi aiue 2i Gates Harms i gi A label project in the Designer Labels and forms a strong point Simply fill out one of the over 2000 standard label templates provided by international manufacturers Avery Bad gepoint Boeder Devauzet ERO Herlitz Herma Leitz May Spiess In addition further sizes can be defined a
17. e information they re looking for Order amount per y 2006 2007 Q 3 Q 4 Q 1 Q 2 a ANATR 89 ae ao SODOR e AROUT 480 Total 2102 972 4781 Definition of and results from crosstabs The table object does almost everything It s got a separate area for everything header data row group hea der group footer and footer and a gene ral table layout It can all be separately configured Columns are pulled to the width you want or adjusted precisely in the dialog window Overlapping titles across two columns multiple pages and multiple columns in tables it s all abso lutely no problem Distracting data rows are simply blended out during design Use the Designer to easily group your data Multiple data lines enable your pro gram to switch between different layouts ear and customer 2008 as G I o 2 Iie a i ptt AD ee Dal 20 4 Total oe a ra E Cal The crosstab object combines data in several dimensions and answers questions such as how are product sales distributed over a number of years how are product sales distributed among staff You can also map more complex structures by inserting additional levels A wizard supports you in creating them To make calculations easier in crosstabs a number of special functions are avail able to help you And boy will you impress others with your design ideas p ane 200 100 150 R f i E e A E PU IIH Mat
18. e mail with attachment or homogenous HTML e mail Monitor print job After transfer to spooler events in the NET VCL and OCX components otherwise via callback Endless labels and endless forms Instead of layout oriented text export send text directly to the matrix printer past the print driver optimal performance when using endless labels and endless forms Export PDF HTML Excel RTF amp Co Piet daient a ewa n Ad 6 ote ee a Aree Sesana _ aaa SUNSHINE ncy aa ee CPP prea poate tee ts eee S n uas eee ties Reger a tor bem Cae pruo paip es a aaa ame HTML export result in Internet Explorer SUNSHINE ncy mee Be hes S RTF export result in Word PDF Export result in Adobe Reader E Ana bje ene i oymigaaa SUNSHINE agency ate to CPE atone whee Ge bater s Caen pre Cane eee tarnar pag te o e erpin agtt oon vont pane Arat araa con eens nare tn arete troe i ieten O parma erty te yee tns wor m gt a o wear eee bee penmet aet pore XPS export result in Internet Explorer s heg ar w jee Export Formats PDF export PDF A a1 standard founda tion for a revision secure archiving fast handy size files support for ClID keyed fonts up to 128 bit encryption opti onally allow or forbid individual printing processing and copying events in order to optimize the file size embed fonts or optionally
19. ed as well as print and export Short ways save you time The ergonomic tool windows include properties variables objects layers pre view and the powerful report container 7 Brp Expert Meie E EX Ham St een orem al Bier r z Praet Feliee iioa e Sere ae Ba reru ere m i m Ae mea EI rere H Pemer rc em pace T vas ae eases miken fan Lipara Wane elt Suet Cops ran paced aa 1 tee anag Owed rr vpra ond femmes tert EI ah tee lt j nasman ou O ened aae ow D baire Doms O regies h hedges O be anma A Opsie ar yepe eeri A iorasneg ter eek td e 2 Coa that aariak A Dewt ct oeg iiD a ten er pesh ete preada 1 aa rten a enag Oreste Frere i nano ena nata oe gt tan peer torda imaa Sa apaa ia A aa at A Re en Formula assistant even applicable aside from List amp Label in the Enterprise Edition Different layout regions and the output control enable you to mix page 1 on printer 1 page 2 in landscape format on printer 2 the last page to a billing printer and everything again to printer 3 with the sign copy on it Also possible changing by condition Use the formula assistant to simplify and include formulas in commercial forms line filters in lists etc Calculations are made to any desired precision Moreover You can even supply your own explana tion texts and easily find functions and fields using the provided filter Add custom functions and actions using the NET VCL an
20. er attractive discounts for developer teams You also need several licenses if you want to encapsulate List amp Label functions e g from your own DLLs com ponents which is not covered by our standard license agreement This can be easily modified with an additional agree ment Don t hesitate to contact our Sales amp Service Team Important You need a license for every developer who is involved in the overall project and or the overall product in which List amp Label is integrated In this respect it is irrelevant whether a devel oper uses List amp Label functions or not Our basic conditions are fair however they have not been calculated so as to enable large projects with maybe tens of thousands of end users to be covered by a single license We comply with the number of developers involved and offer attractive volume discounts A project group must decide which of the editions they all want to go for Appliance on servers or web servers is subject to a license fee for the Stan dard and Professional Editions For each application installation that utilizes an internet protocol for example or is a web server extension or is integrated in ASP or PHP pages or Is an independent server application you require the correspon ding server web server licenses if you use the Standard or Professional Edition The Enterprise Edition includes a server web server license flat rate Please find the combit license agreeme
21. i i Ho ture baa ans Verdana 10 0 pt a g F rnat None i Rotation Text Format Normal Text B Action Link URL B Layout m Alignment Left Appearance Condition Show Blank Optimization No With the drilldown feature you create user friendly clearly laid out reports for example about customers orders and details of orders in other words hierachi cal or rather relational structures Passing data via data binding in combination with NET or VCL is so simple 1 n relations are automatically passed and can even be broken down in reverse into 1 1 relations In other programming languages special commands enable you to pass database tables completely with all relations and sortings to List amp Label End users can easily handle relational databases In the Designer and jump with joy in the preview There they click along the links in the preview deeper and deeper until they reach the desired data level Report structure i Ti mal ek a a a O Report Container M Table Categories M Table Products Categories2Products crontab Products Categories2Products W Chart Employees m Table Shippers j a T Table Orders Shippers20rders r Details Report structure Create Drilldown And that s exactly what they send to the printer or into a PDF neatly and cleanly Even with very large and com plex databases you can be sure that as a developer everyone can quickly pro cess th
22. integrated with the List amp Label NET VCL and OCX components without this being apparent In other programming languages this is realized via callback and callback dialog events Additional objects HTML objects Text objects Lines rectangles circles ellipse objects Graphic objects formats WMF SIM IRC ie ete Gillie leis eC Dy DIB REE TENG Form control objects Completed by the user in the print preview Form template object Graphic e g scanned bitmap as a help for positioning in the background Object Model for Projects DOM Manage Designer properties via code Experience boundless opportunities with the dynamic crea tion of projects with your own project wizard or a slimmed down Designer With NET and VCL it is exceptionally smooth and it works just as well with other programming languages Alternatively the other way round Properties individual objects and even com plete projects can be simply generated as DOM code for NET acre 5 na proj th jeote s LlobjText gt Filing a Frat Genem todt dona Ol Paper Extent Gee hi Size Pt og gaHihCodi inkTo 10000 papeEntend Gidth 65000 270004 tiL LisbIT asn ached L1ODITE A hae ap he E H Bawdiiraly Pomen dus OBK nmt meme propert eee eet ePees Part apis i Create a new project including a report container and table called Products and fields here in C Proj Open c Repo
23. my As Long nProgressInPerc As Long pbLastRec As Long 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 amp Label Repeat for all fields belonging to a data record For i 0 To Forml Datal Recordset Fields Count 1 content Datal Recordset Fields i nRet ListLabell LlDefineFieldExt _ Datal Recordset Fields i Name _ content LL TEXT Next i Go to next data record Forml Datal Recordset MoveNext If there are no more data records printing is ended If Forml Datal Recordset EOF True Then pbLastRec 1 End If End Sub 7 Print Preview Check Print Send Export Order 1057 fone 70 87 2087 Order 1047 fern T1180 CUF a 2 am 4 6 the Hom 2 ox Order Sit fran 24 82 2001 DISSA fron 05 07 2087 Order BET deomn LLIN Order W445 eon 14 82 2007 Real data preview with index The preview can be used 1 integrated into the Designer 2 separately inte grated into your application or 3 as a standalone viewer application Anyway ore mer here you zoom smoothly into the page to control it and start printing or export ing right away Even for large projects you get results in next to no time as you check out the first page while the print job is still running in the background Preview features Save the preview and send it by mail to someone who perhaps has onl
24. n page 22 Almost any programming language Switching languages is no problem More on page 6 Ce Print preview export 1 code Quickly and easily ad value to your appli cation comprehensive export formats e g PDE MIME RIF Excel More on page 16 ececeeecece cece reece ee ec eee eee eee eee eee eee eee ee eee eee eee ee eee Many barcode formats Also 2D barcodes no barcode fonts required More on page 13 Simple to redistribute Without database driver slim easy to handle saves on resources More on page 5 As of Oct 2009 no further readers choices have been carried out The Program s Heart from a User s Viewpoint List amp Label Designer Drag amp Drop Preview m AN PTET oo e mnie Repor i Produtt oe N r a ue o LLE x TTT E ji e SS Report structure aalexs Bt a Report Container ja Chart a T Products MI Product Details E Crosstab Listofveriables u Product 7 all Relations E Table E PMOMaterials E Product 1 Da ProductModel Prodi Gy ProductSubcategory Gy UnitMeasure Produc A Glass C Color E DayiToManufacture o DiscontinuedDate A FinishedGoodsFlag E ListPrice pA MakeFlag T ModifiedDate AI Name E ProductlD A Productline E ProductModellD A ProductNumber ig ProductSubcategoryl E ReorderPoint A rowgyid m SafetyStockLevel OF SellendDate T SaliStartDate A Sax TA cirelnithienure Co
25. nt at www combit net en licenseagreement and the most frequent ly asked questions on the List amp Label license at www combit net en License faq We recommend that you read both carefully Of course we are also happy to answer your questions concerning licen sing in person T 49 7531 90 60 10 mane man e Get y WS ec ort A supe lt O SS A O gt x SO LK S S VS gt O c Sf LEl Sf K P KA RN i ae D O List amp Label 15 Editions S Ys e amp oy Designer for developers Designer for end users of most desktop applications see license agreement for restrictions o e Use in most server web server applications add on server web server licenses s Use in most server web server applications flat rate E Applicable with all supported programming languages all examples available e Print preview and export in all supported formats e o e o 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 e Service Packs for all versions while subscription is valid access to knowledge base newsgroups and RSS feed e Subscription for one year incl feature upgrades Automatic renewal termination up to 3 months before end of year e Support flat rate for one year available via e mail and telephone directly from
26. nt long axis labels diagonally define several y axes and scale the axes logarithmically We bet there is some thing here you ll find useful for your graphical evaluation Rows inside the chart object Designer Barcode Object GS1 2of5 Code39 EAN GTIN DataMatrix PDF417 QR The barcode object supports more than 40 barcode formats This surely makes List amp Label one of the leading report generators No barcode fonts are Barcode formats gt SANS de JES dE SES SES Ee Se AEA ae i 2of5 Interleaved Industrial Matrix Datalogic 30f9 alias Aloha 39 alias Code 39 with CRC without CRC Codabar Code 11 Code 93 Code 93x 0 Code 128 EAN 13 P2 ISSN magazines EAN 13 P5 Bookland ISBN books German Parcel German Post Identcode German Post Leitcode GS1 128 EAN 128 GS1 DataBar Einfach Expanded Limited Stacked Stacked Omni Truncated GTIN 8 EAN 8 UCC 8 JAN 8 GTIN 13 EAN 13 UCC 13 JAN 13 required For best results you set both the bar width as well as the bar ratio if the barcode type permits nAn due JES JED Ee Ee due A a i ISBN Japanese Postcode KIX Postcode of the Netherlands MSI MSI Plain MSI 10 10 Mo EO 1D MIS e EO NVE SSGE PZN Royal Mail UK Postcode UPC AVE US FIM US Postnet Additional 2D barcodes in the Professional and Enterprise Edition Sae A gt A A A EDA Maxicode DataMatrix Aztec QR And the
27. only the used characters hashing of identical images RTF export Text position is also possible via text boxes for optimal further proces sing in Word Excel export Optionally simple data export Table data imported to one spread sheet you process a regular Excel project optionally adopt full layout render the visual appearance as true to detail as possible without any OLE mechanisms therefore independent of an Excel installa tion optionally one worksheet per page with naming throughout HTML export Cascading Style Sheet CSS tags for table frames and to ensure visually appealing results in particular in individual frame formatting MHTML In comparison to HTML the result file contains data and images Text export Either purely data oriented creation of almost any CSV files data conversion or layout oriented e g for matrix or continuous printer Ce o TIFF Multi TIFF Different compression types and qualities Additional formats XML JPEG BMP EVIE a T a ZAP eS 20 International Projects Unicode Multibyte Designer in different languages Localization of project files m ss eres i p Tabellennamen loksalisieren p es Localize table names LL Dictionary Tables LL Dictionary Tables dd men lok lisieren if D Reletionsnamen lLoka lisi n 7S Locealite relation name F AE a 0i 4 LL Dictionary Relations Add p Feldnamen lekalisieren iy
28. rms labels Print preview export Web reporting 1 esentation Deluxe bel has for seen been amon the ee mere important compon Been domain of program database PFO ree pro Data Pr Your Benefits at a Glance Designer also for end users Without separate license fees end users can create reports by themselves more success for your application stress free More on pages 4 and 8 Ce o Integrate quickly as component Only 5 minutes with NET 1 drag com ponent to form 2 set properties using Smart Tags 3 start printing design More on pages 5 and 7 Easy and flexible in use Data binding plus data provider or independent of database components or DLL combine custom data fields and database fields as you want More on page 5 Awarded and reliable Over 17 years good reputation many enthusiastic developer customers sever al millions of end users worldwide More on pages 2 and 24 Ce o German efficiency More than 20 years of experience reli ability for your project quick help di rect line to experts and makers lasting effect by continuous innovation More on page 22 eoeereece eee eee cee eee ee eee eee eee ee eee eee eee eee eee eee eee Something to suit everyone Save money with Standard obtain subscription support amp Co with Profes sional enjoy the all inclusive carefree package of Enterprise More o
29. rts product 1st L1lDomFileMode Create L1DomAccessMode ReadWrite true DomObjectReportContainer container new DomObjectReportContainer Pro j Objects container Position Left 0 container Position Top 0 container Position Width 150000 container Position Height 200000 DomSubIitemTable 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 How about a project assistant that adapts the project tem plates to the end user s requirements even before the Designer opens That means for example that an end user only selects cer tain fields from your database for an invoice and by opening the Designer the invoice project is practically ready with address field and item list already filled out FN m Files combit oo ess FS List amp Label DOM Viewer CAProgre Ss a 33 E Program Files combit LL14 T ools lidomviewiktems 1pi i Layers E Layout i a Objects A heading A heading cont Al article from A printing into M article list E astiale tA
30. s Set properties optional LL AutoDesignerFile subrep lst LL AutoProjectType L1lProject List LL AutoDialogTitle example LL AutoShowSelectFile true Start the Designer LL Design Catch exceptions catch ListLabelException L1Exception MessageBox Show Information L1IException Message Information MessageBox IconInformation MessageBox OK Delphi Start Designer procedure TForml1 DesignButtonClick Sender TObject begin Assign data source LL DataSource dsCustomers The customer master data should be registered as fields LL AutoMasterMode mmAsFields Set standard project names LL AutoDesignerFile subrep 1lst Set print mode to PreviewControl LL AutoDestination adPreview Designer LL AutoDesign Invoice List end C Define special fields normal text field L1lDefineFieldExt job Text Testtext LL TEXT NULL footer fields e g numeric L1DefineFieldExt job subtotal 12 34 LL NUMERIC LL TABLE FOOTERFIELD NULL Barcode fields L1DefineFieldExt 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
31. s required Alongside standard functions such as font type and line pitch for each line you benefit from real high end functions Suppress unwanted empty rows and characters leave out used labels from printing and determine printing orders When filling out existing forms save yourself the trouble of measuring every thing by using the special form template object to blend a scanned form into the background Position the objects on top with precision of 1 1000 inch Designer Objects Table Crosstab amp Co Reports Subreports Multi tables Crosstabs ir Header bine Data Line Footer Line Group Header Group Footer g g x u a date Al Item No EN tem No EAN128 A Item Description2 Ikem UnitPrice Table properties Well equipped for even the most daring leaps and bounds with the report con tainer With one of our examples or with the List amp Label data binding for NET or VCL you start arbitrary sequences using the same code Tables and subtables or report container subreports Tables charts and crosstabs Charts in table columns Free text pictures barcodes or variable contents That s pure flexibility Even charts in table columns are under your full control You specify where the data should come from and List amp Label handles the rest 4 0 2l Namie BDats Contents Ttem No i ptions B Appearance A Transparent p
32. so simple And with the Standard Edi tion It s knowledge base and newsgroups for free whereas the the services provided by our Support Team are settled on a time and material basis And when it s time for a new version you decide in favor of a new upgrade or not or you don t The subscriptions Professional Edi tion and Enterprise Edition include all Service Packs all feature upgrades and all upgrades to major versions during the period of validity We are also available by phone and e mail during our office hours to answer your support ques tions on a flat rate basis CD purchase service packs and interim upgrades are available via download all major versions are sent to you on CD Download purchase get everything by download as well Our support team can be reached directly from Yam to 12am and 2pm to 5pm CET by phone or e mail Outside these hours when reaching our Sales amp Service Team you may ask for a call back The time period of validity of your subscription and the related support is one year If you do not cancel the subscription at a time period of notice of 3 months to the end of this contractual year it is automatically renewed by another contractual year You don t have to see to it List amp Label is a license for one developer Individual non transferable for one developer for installation on one computer or alternately for use on one notebook Professional Enterprise We off
33. us Localize field names iL Dictionary Fields add Producchsim LL Dievionary Fields Add Quantity LL Dictionary Fields ada UnicPr ce Tr LL Dictionary Fields add OrderPare r LL Dictionary Fiel 5 rt LL pictionary Fields add Shipcsey Localization of project files List amp Label makes it easy to master international markets and enjoy competi tive advantages You ll find we ve thought of everything you need The unicode multibyte capability enables you to design output incl partly export for example Asian or Russian cha racters or both in one report Designer language kits complement the Designer with many languages This makes your application fit for multi lingu al teams and international markets The launch dates of these kits depend on how versions are released as well as partly on cooperation with our partners torder Details orders20rderbetails ds adda Shipaddress it try nje a pestellungen E cAdA OrderS Restellposten wpestellungen Bestellposten n produktname anzahl s nEinzelpreis nBpestelldatum rEempfanger Adresse tEmpfangerstadt rEmprangerLand Certainly available in version 15 are English French German Italian and Spanish Expected to be available are Da nish Dutch Polish Portuguese Russian and Czech Information as of Nov 2009 Please contact us if the language you require is not listed
34. y the viewer Create an index the way you are used to with PDF Create interactive forms by simply positioning a form control in the Designer where the user enters data Article amt Jerseys Lights Drilldown Drilldown Statistics Drilldown reporting Create presentations directly from your reports even full screen inclu ding the typical slide transitions Use the inplace preview control that s part of the component for your own dialogs Integrate the WPF viewer seam lessly into your Windows Presentation Foundation application Adjust the internet viewer a special OCX Activex object that has a digital signature variably to your needs Drilldown reporting is being defined in the designing mode but comes into full operation in the preview Here the end users click their way towards success within relational databases and safely navi gate through even rougher hierarchical data The items drilled out last are then sent to the printer or into an export file Learn more www combit net en drilldown Mountaln 100 Siver 38 BK MErS 42 Mountain 100 Silver 42 execs 44 Mourteln 100 Siver 4l aa gt Open here t Open in new tab Open in window Additional output features bring your reporting forward Dispatch via e mail Send preview and export files directly via MAPI XMAPI or by SMTP Compress pre view files as you require Text
Download Pdf Manuals
Related Search