Users GuideInfoMaker®11.5
ContentsxInfoMakerDefining a validation rule in the Form painter... 292How to maintain extended attributes...
Using the Database painter 78 InfoMakerFor all other DBMSs, creating and deleting a database is an administrative task that you cannot do within Inf
CHAPTER 3 Managing the DatabaseUsers Guide 79Dragging and droppingYou can select certain database objects from the Objects view and drag them to th
Using the Database painter 80 InfoMakerTable 3-3: Common tasks in the Database painterTo Do thisModify a database profile Highlight a database profi
CHAPTER 3 Managing the DatabaseUsers Guide 81Modifying database preferencesTo modify database preferences, select Design>Options from the menu b
Using the Database painter 82 InfoMakerLogging your workAs you work with your database, you generate SQL statements. As you define a new table, for
CHAPTER 3 Managing the DatabaseUsers Guide 83Creating and deleting a SQL Anywhere databaseIn InfoMaker you work within an existing database. With o
Working with tables 84 InfoMaker❖ To delete a local SQL Anywhere database:1 Open the Database painter.2 From the Objects view, launch the Delete ASA
CHAPTER 3 Managing the DatabaseUsers Guide 852 Enter the required information for this column.For what to enter in each field, see “Specifying colu
Working with tables 86 InfoMakerCreating a new table from an existing tableYou can create a new table that is similar to an existing table very quic
CHAPTER 3 Managing the DatabaseUsers Guide 87Specifying table and column propertiesAfter you create and save a table, you can specify the propertie
ContentsUsers Guide xiX1, X2... 342Y...
Working with tables 88 InfoMaker3 Right-click on the Object Details view and select Save Changes from the pop-up menu. Any changes you made in the O
CHAPTER 3 Managing the DatabaseUsers Guide 893 Right-click on the Column property sheet and select Save Changes from the pop-up menu. Any changes y
Working with tables 90 InfoMakerSpecifying additional properties for character columnsYou can also set two additional properties for character colum
CHAPTER 3 Managing the DatabaseUsers Guide 91• Prohibit null values for an appended column• Alter an existing indexSome DBMSs let you do the follow
Working with tables 92 InfoMaker2 Make the changes you want in the Columns view or in the Object Details view.3 Select Save Table or Save Changes.In
CHAPTER 3 Managing the DatabaseUsers Guide 93Dropping a tableDropping removes the table from the database.❖ To drop a table:1 Select Drop Table fro
Working with tables 94 InfoMakerCopying, saving, and printing pending SQL changesWhen you are viewing pending SQL changes, you can:• Copy pending ch
CHAPTER 3 Managing the DatabaseUsers Guide 95Exporting table syntaxYou can export the syntax for a table to the log. This feature is useful when yo
Working with tables 96 InfoMakerIn the Employee table, for example, one column name is Emp_lname. A label and a heading for the column are defined f
CHAPTER 3 Managing the DatabaseUsers Guide 97For SNC, use # for a local temporary table or ## for a global temporary table. Temporary tables must s
ContentsxiiInfoMakerExporting to XML... 382Setting data export properties...
Working with keys 98 InfoMaker• Open the table containing the primary key used by a particular foreign key• Create, alter, and drop keysFor the most
CHAPTER 3 Managing the DatabaseUsers Guide 99Defining primary keysIf your DBMS supports primary keys, you can define them in InfoMaker.❖ To create
Working with keys 100 InfoMakerCompleting the primary keySome DBMSs automatically create a unique index when you define a primary key so that you ca
CHAPTER 3 Managing the DatabaseUsers Guide 1016 Right-click on the Object Details view and select Save Changes from the pop-up menu. Any changes yo
Working with indexes 102 InfoMakerCreating an indexIn SQL Anywhere databasesIn SQL Anywhere databases, you should not define an index on a column th
CHAPTER 3 Managing the DatabaseUsers Guide 1032 In the Object Details view, select or deselect columns as needed.3 Right-click on the Object Detail
Working with database views 104 InfoMakerYou define, open, and manipulate database views in the View painter, which is similar to the SQL Select pai
CHAPTER 3 Managing the DatabaseUsers Guide 105Representations of the selected tables and views display in the View painter workspace:3 Select the c
Working with database views 106 InfoMakerDisplaying a database view’s SQL statementYou can display the SQL statement that defines a database view. H
CHAPTER 3 Managing the DatabaseUsers Guide 107❖ To join tables:1 Click the Join button.2 Click the columns on which you want to join the tables.In
ContentsUsers Guide xiiiCHAPTER 15 Working with TreeViews... 455TreeView presentation style
Manipulating data 108 InfoMakerFor more about outer joins, see “Using ANSI outer joins” on page 171.Dropping a database viewDropping a database view
CHAPTER 3 Managing the DatabaseUsers Guide 109Retrieving data❖ To retrieve data:1 In the Database painter, select the table or database view whose
Manipulating data 110 InfoMakerIf looking at data from a viewSome views are logically updatable and others are not. Some DBMSs do not allow any upda
CHAPTER 3 Managing the DatabaseUsers Guide 1112 Drag the columns you want to sort on from the Source Data box to the Columns box:A check box with a
Manipulating data 112 InfoMakerFiltering rowsYou can limit which rows are displayed by defining a filter.The filters you define are for testing only
CHAPTER 3 Managing the DatabaseUsers Guide 113Viewing row informationYou can display information about the data you have retrieved.❖ To display row
Manipulating data 114 InfoMakerPrinting dataYou can print the data displayed by selecting File>Print from the menu bar. Before printing, you can
CHAPTER 3 Managing the DatabaseUsers Guide 1153 For TEXT, CSV, SQL, HTML, and DIF formats, select an encoding for the file.You can select ANSI/DBCS
Creating and executing SQL statements 116 InfoMakerControlling commentsBy default, InfoMaker strips off comments when it sends SQL to the DBMS. You
CHAPTER 3 Managing the DatabaseUsers Guide 117•For an INSERT statement, type the values to insert into each column. You can insert as many rows as
ContentsxivInfoMakerMaster/Detail One-To-Many forms... 511Master/Detail Many-To-One forms...
Creating and executing SQL statements 118 InfoMakerImporting SQL from a text fileYou can import SQL that has been saved in a text file into the Data
CHAPTER 3 Managing the DatabaseUsers Guide 119Customizing the editorThe Interactive SQL view provides the same editing capabilities as the file edi
Controlling access to the current database 120 InfoMaker
Users Guide 121CHAPTER 4Working with Data Pipelines About this chapterThis chapter describes how to use the Data Pipeline painter to create data pipel
About data pipelines 122 InfoMaker• Upload local data that changes daily to a corporate database• Create a new table when a change (such as allowing
CHAPTER 4 Working with Data PipelinesUsers Guide 123The Data Pipeline painter supports the piping of columns of any datatype, including columns wit
Creating a data pipeline 124 InfoMakerPiping the extended attribute system tablesSelecting the Extended Attributes check box never results in the pi
CHAPTER 4 Working with Data PipelinesUsers Guide 125If you do not see the connections you needTo create a pipeline, the databases you want to use f
Creating a data pipeline 126 InfoMakerThe pipeline definition is InfoMaker’s best guess based on the source data you specified.6 Modify the pipeline
CHAPTER 4 Working with Data PipelinesUsers Guide 127The role of the Query governorOptions you set in the Query Governor affect the Data Pipeline pa
ContentsUsers Guide xvEqualizing the size of controls in the Form painter... 551Undoing changes in the Form painter...
Modifying the data pipeline definition 128 InfoMakerTable 4-1 lists properties you can modify that apply to the destination table. These properties
CHAPTER 4 Working with Data PipelinesUsers Guide 129Table 4-2 lists properties that you can modify that apply to the destination table’s columns an
Modifying the data pipeline definition 130 InfoMakerChoosing a pipeline operationWhen InfoMaker pipes data, what happens in the destination database
CHAPTER 4 Working with Data PipelinesUsers Guide 131• Specify or clear a key name and/or key columns.Specify key columns by selecting one or more c
Modifying the data pipeline definition 132 InfoMakerWhen using UpdateFor the Update - Update/Insert Rows option, the destination table must already
CHAPTER 4 Working with Data PipelinesUsers Guide 133When you stop executionWhen you click Cancel or a Query Governor limit is reached, if the Commi
Modifying the data pipeline definition 134 InfoMakerAbout transactionsA transaction is a logical unit of work done by a DBMS, within which either al
CHAPTER 4 Working with Data PipelinesUsers Guide 135Adding blob columns to a pipeline definitionWhen you select data to pipe, you cannot select a b
Modifying the data pipeline definition 136 InfoMakerExecuting a pipeline with blob columnsAfter you have completed the pipeline definition by adding
CHAPTER 4 Working with Data PipelinesUsers Guide 137Correcting pipeline errors If the pipeline cannot pipe certain rows to the destination table fo
ContentsxviInfoMakerCHAPTER 22 Deploying Your Application... 595About deploying applications ...
Saving a pipeline 138 InfoMaker❖ To correct pipeline errors:1 Change data values for the appropriate columns in the error rows.2 Click the Update DB
CHAPTER 4 Working with Data PipelinesUsers Guide 139Using an existing pipeline If you save a pipeline, you can modify and execute it any time. You
Pipeline examples 140 InfoMakerReproducing a table definition with no dataYou can force a pipeline to create a table definition and not pipe data. T
PART 3 ReportsThis part introduces you to the many styles of reports available in InfoMaker and describes how to create and work with reports.
Users Guide 143CHAPTER 5Defining Reports About this chapter The reports you create are centered around your organization’s data. This chapter describe
Choosing a presentation style 144 InfoMakerAbout the term DataWindowThe terms DataWindow and report are often used interchangeably. Many of the exam
CHAPTER 5 Defining ReportsUsers Guide 145Using the Tabular styleThe Tabular presentation style presents data with the data columns going across the
Choosing a presentation style 146 InfoMakerUsing the Freeform styleThe Freeform presentation style presents data with the data columns going down th
CHAPTER 5 Defining ReportsUsers Guide 147Grid report with modified column widthsThis grid report was created from the original one by decreasing th
ContentsUsers Guide xviiAsc ... 642AscA...
Choosing a presentation style 148 InfoMakerBusiness cardsName tagsSpecifying label propertiesIf you choose the Label style, you are asked to specify
CHAPTER 5 Defining ReportsUsers Guide 149Table exampleFor a table of daily stock prices, you can define the report as five across, so each row in t
Choosing a presentation style 150 InfoMakerAnother way to get multiple-column reportsIn an n-up report, the data is displayed across and then down.
CHAPTER 5 Defining ReportsUsers Guide 151This composite report consists of three nested tabular reports. One of the tabular reports includes a grap
Choosing a presentation style 152 InfoMakerThere is a graph report in the composite report in “Using the Composite style” on page 150. This crosstab
CHAPTER 5 Defining ReportsUsers Guide 153Using the TreeView styleThe TreeView presentation style provides an easy way to create reports that displa
Selecting a data source 154 InfoMakerColumn limitThere is a limit of 1000 on the number of columns in a report.For information about changing your d
CHAPTER 5 Defining ReportsUsers Guide 155InfoMaker data sourcesInfoMaker has five data sources. All five can be used for reports, but only a subset
Using Quick Select 156 InfoMakerUsing Quick SelectThe easiest way to define a data source is using Quick Select. ❖ To define the data using Quick Se
CHAPTER 5 Defining ReportsUsers Guide 157Selecting a tableWhen you choose Quick Select, the Quick Select dialog box displays. The Tables box lists
ContentsxviiiInfoMakerIsExpanded ... 688IsNull ...
Using Quick Select 158 InfoMakerMeaning of the up and down arrowsAn arrow displays next to a table to indicate its relationship to the selected tabl
CHAPTER 5 Defining ReportsUsers Guide 159As you select columns, they display in the grid at the bottom of the dialog box in the order in which you
Using Quick Select 160 InfoMaker❖ To specify selection criteria:1 Click the Criteria row below the first column for which you want to select the dat
CHAPTER 5 Defining ReportsUsers Guide 161Comparison operatorsYou can use the LIKE, NOT LIKE, IN, and NOT IN operators to compare expressions.Use LI
Using Quick Select 162 InfoMakerSQL expression examplesThe first six examples in this section all refer to a grid that contains three columns from t
CHAPTER 5 Defining ReportsUsers Guide 163The SELECT statement that InfoMaker creates is:SELECT employee.emp_id, employee.dept_id, employee.salaryFR
Using Quick Select 164 InfoMakerExample 6This example shows the use of the word AND in the Or criteria row. In the Criteria row, >=500 is in the
CHAPTER 5 Defining ReportsUsers Guide 165Using SQL SelectIn specifying data for a report, you have more options for specifying complex SQL statemen
Using SQL Select 166 InfoMaker6 Limit the retrieved rows with WHERE, ORDER BY, GROUP BY, and HAVING criteria, if appropriate.For more information, s
CHAPTER 5 Defining ReportsUsers Guide 167Below the Table Layout view, several tabbed views also display by default. You use the views (for example,
ContentsUsers Guide xixReal... 728RelativeDate...
Using SQL Select 168 InfoMakerSelecting columnsYou can click each column you want to include from the table representations in the Table Layout view
CHAPTER 5 Defining ReportsUsers Guide 1693 Press the Tab key to get to the next row to define another computed column, or click another tab to make
Using SQL Select 170 InfoMaker❖ To edit the SELECT statement:1 Select Design>Convert to Syntax from the menu bar.InfoMaker displays the SELECT st
CHAPTER 5 Defining ReportsUsers Guide 171The Join dialog box displays:4 Select the join operator you want and click OK.If your DBMS supports outer
Using SQL Select 172 InfoMakerOrder of evaluation and nestingIn ANSI SQL-92, when nesting joins, the result of the first outer join (determined by o
CHAPTER 5 Defining ReportsUsers Guide 173If you select the condition with rows from department that have no employee, you create a right outer join
Using SQL Select 174 InfoMaker3 Enter a name and datatype for each argument.The first character must be alphabetic (a–z); subsequent characters can
CHAPTER 5 Defining ReportsUsers Guide 175For the case of the array defined as deptarray, the expression in the Where view will look like the follow
Using SQL Select 176 InfoMakerDynamically selecting, sorting, and grouping dataSelection, sorting, and grouping criteria that you define in the SQL
CHAPTER 5 Defining ReportsUsers Guide 1775 Under Value, specify the right-hand side of the expression. You can:• Type a value.• Paste a column, fun
DOCUMENT ID: DC37789-01-1150-01LAST REVISED: September 2008Copyright © 2008 by Sybase, Inc. All rights reserved.This publication pertains to Sybase so
ContentsxxInfoMakerAPPENDIX B The Extended Attribute System Tables... 767About the extended attribute system tables.
Using SQL Select 178 InfoMaker3 Continue to specify additional columns for sorting in ascending or descending order as needed. You can change the so
CHAPTER 5 Defining ReportsUsers Guide 179❖ To define GROUP BY criteria:1 Click the Group tab to make the Group view available (or select View>Gr
Using Query 180 InfoMaker❖ To define HAVING criteria:• Click the Having tab to make the Having view available (or select View>Having if the Havin
CHAPTER 5 Defining ReportsUsers Guide 181Using ODBC drivers instead of ExternalIf you have an ODBC dBASE driver and an ODBC text driver on your com
Using Stored Procedure 182 InfoMakerAlternatively, you can select the name from the file list. Use the Drives drop-down list and the Directories box
CHAPTER 5 Defining ReportsUsers Guide 183• To define the result set description manually, select the Manual Result Set check box and click Next.In
Choosing report-wide options 184 InfoMakerThe group suffix is an optional integer used in some DBMSs to group procedures of the same name so that th
CHAPTER 5 Defining ReportsUsers Guide 1855 Click OK.About color selectionsIf you select Window Background, Application Workspace, Button Face, or W
Generating and saving a report 186 InfoMakerExtended attribute information applies to forms, tooInfoMaker uses extended attribute information when g
CHAPTER 5 Defining ReportsUsers Guide 187For more information about the extended attribute system tables, see Chapter 3, “Managing the Database,” a
Users Guide xxiAbout This BookAudienceThis book is for anyone who is using InfoMaker® to work with data. Although the book does not assume you have kn
Defining queries 188 InfoMaker3 Select the object you want.InfoMaker opens the Report painter and displays the report. You can also open a report by
CHAPTER 5 Defining ReportsUsers Guide 189InfoMaker retrieves the rows satisfying the currently defined query in a grid-style report.2 Manipulate th
What's next 190 InfoMakerModifying a query❖ To modify a query:1 Select File>Open from the menu bar.2 Select the Queries object type and then
Users Guide 191CHAPTER 6Enhancing Reports About this chapterAfter InfoMaker generates a basic report, you can further enhance its appearance and conte
Working in the Report painter 192 InfoMakerWorking in the Report painter The Report painter provides views related to the report you are working on.
CHAPTER 6 Enhancing ReportsUsers Guide 193Preview viewThe Preview view in the middle on the left shows the report with data as it will appear at ru
Working in the Report painter 194 InfoMakerUnderstanding the Report painter Design viewFor most presentation styles, the Report painter Design view
CHAPTER 6 Enhancing ReportsUsers Guide 195You can specify additional heading information (such as a date) in the header band and you can include pi
Working in the Report painter 196 InfoMakerThe summary and footer bandsYou use the summary and footer bands of the report the same way you use summa
CHAPTER 6 Enhancing ReportsUsers Guide 197Using the Properties view in the Report painterEach part of the report (such as text, columns, computed f
xxii InfoMakerOther sources of informationUse the Sybase Getting Started CD, the SyBooks CD, and the Sybase Product Manuals Web site to learn more a
Working in the Report painter 198 InfoMaker❖ To select neighboring multiple controls in a report in the Design view (lasso selection):1 Press and ho
CHAPTER 6 Enhancing ReportsUsers Guide 199Displaying information about the selected controlThe name, x and y coordinates, width, and height of the
Using the Preview view of a report 200 InfoMakerUsing the Preview view of a report You use the Preview view of a report to view it as it will appear
CHAPTER 6 Enhancing ReportsUsers Guide 201Previewing without retrieving dataIf you do not want InfoMaker to retrieve data from the database automat
Using the Preview view of a report 202 InfoMakerSupplying argument values or criteriaIf the report has retrieval arguments or is set up to prompt fo
CHAPTER 6 Enhancing ReportsUsers Guide 203❖ To modify existing data:• Tab to the field and enter a new value. The Preview view uses validation rule
Using the Preview view of a report 204 InfoMaker❖ To import data into a report:1 Select Rows>Import from the menu bar.2 Specify the file from whi
CHAPTER 6 Enhancing ReportsUsers Guide 205Controlling the display of rulersYou can choose whether to display rulers around page borders.❖ To contro
Using the Preview view of a report 206 InfoMakerPrinting dataYou can print a report while the Preview view is displayed. You can print all pages, a
CHAPTER 6 Enhancing ReportsUsers Guide 207The extension PRN indicates that the file is prepared for the printer. Change the drive, the directory, o
PART 1 The InfoMaker EnvironmentThis part introduces you to InfoMaker and describes how to work in and manage its environment. It also describes how
Saving data in an external file 208 InfoMaker• To select non-neighboring columns, press and hold Ctrl, then click the headers.• To select cells, pre
CHAPTER 6 Enhancing ReportsUsers Guide 209The rest of this section provides more information about saving data in PDF, HTML, and PSR formats.For mo
Saving data in an external file 210 InfoMakerSaving as PDF using the distill methodIf you want to save to PDF using the distill method, you do not n
CHAPTER 6 Enhancing ReportsUsers Guide 211Saving as PDF fails at runtime on Windows 2003 Server. This is caused by a Group Policy that by default d
Saving data in an external file 212 InfoMaker4 Save the report, then select File>Save Rows As, select PDF as the Save As Type, specify a file nam
CHAPTER 6 Enhancing ReportsUsers Guide 213<font metrics-file="C:\Program%20Files\Sybase\Shared\PowerBuilder\fop-0.20.4\conf\cyberbit.xml&qu
Saving data in an external file 214 InfoMakerWorking with PSR filesA PSR file is a special file with the extension PSR created by PowerBuilder, Info
CHAPTER 6 Enhancing ReportsUsers Guide 215❖ To open a PSR file in InfoMaker using Explorer or File Manager or from a mail message:• Double-click th
Modifying general report properties 216 InfoMakerInfoMaker mails the PSR file. The recipient can open the report by double-clicking it if InfoMaker
CHAPTER 6 Enhancing ReportsUsers Guide 2173 Specify the number of milliseconds you want between internal timer events in the report.This value dete
Modifying general report properties 218 InfoMakerSetting gradients and background pictures in a reportYou can use the background effects to give the
CHAPTER 6 Enhancing ReportsUsers Guide 2194 From the Tile Mode drop-down list, select the style you want to use.Selections from the drop-down list
Modifying general report properties 220 InfoMaker❖ To specify basic grid report properties:1 Position the mouse pointer on the background in a grid
CHAPTER 6 Enhancing ReportsUsers Guide 221Defining print specifications for a reportWhen you are satisfied with the look of the report, you can def
Modifying general report properties 222 InfoMakerTable 6-4: Setting print specifications for reportsSetting DescriptionDocument Name Specify a name
CHAPTER 6 Enhancing ReportsUsers Guide 223Printing with newspaper-style columnsWhen you define a report, you can specify that it print in multiple
Modifying general report properties 224 InfoMaker1 Create a tabular report, selecting the last name, first name, and phone number columns, and add a
CHAPTER 6 Enhancing ReportsUsers Guide 225The finished report has one set of page heading information and two columns of column header and detail i
Modifying general report properties 226 InfoMaker• Change the text properties in the StyleBar. • Select the Font page in the control’s Properties vi
CHAPTER 6 Enhancing ReportsUsers Guide 227❖ To add a border to a control in a report:1 Select one or more controls.2 Select the border you want fro
Users Guide 3CHAPTER 1Working with InfoMakerAbout this chapterThis chapter describes the basics of working with InfoMaker and its painters.ContentsBef
Modifying general report properties 228 InfoMakerIn the Preview view, the band resizes based on the contents of the columns you defined as having th
CHAPTER 6 Enhancing ReportsUsers Guide 2292 Modify the SELECT statement graphically using the same techniques as when creating it. For more informa
Storing data in a report using the Data view 230 InfoMakerModifying the result setIf the data source is External or Stored Procedure, you can modify
CHAPTER 6 Enhancing ReportsUsers Guide 231❖ To store data in a report:1 If the Data view is not already displayed, select View>Data from the men
Retrieving data 232 InfoMakerRetrieving dataIn a report, you can prompt for retrieval criteria, retrieve rows as needed, and save retrieved rows to
CHAPTER 6 Enhancing ReportsUsers Guide 233Using edit stylesIf a column uses a code table or the RadioButton, CheckBox, or DropDownListBox edit styl
Retrieving data 234 InfoMakerRetrieve Rows As Needed is overridden if you have specified sorting or have used aggregate functions, such as Avg and S
Users Guide 235CHAPTER 7Working with Controls in Reports About this chapterOne of the ways you can enhance a report is to add controls, such as column
Adding controls to a report 236 InfoMaker❖ To add a column from the data source to a report:1 Select Insert>Control>Column from the menu bar.2
CHAPTER 7 Working with Controls in ReportsUsers Guide 237Displaying an ampersand characterIf you want to display an ampersand character, type a dou
About InfoMaker 4 InfoMakerAbout InfoMakerInfoMaker is a reporting toolInfoMaker is a powerful and easy-to-use reporting tool that lets you query da
Adding controls to a report 238 InfoMakerAdding a group box to a reportTo visually enhance the layout of a report, you can add a group box. A group
CHAPTER 7 Working with Controls in ReportsUsers Guide 239The picture must be a bitmap (BMP), runlength-encoded (RLE), Windows metafile (WMF), Graph
Adding controls to a report 240 InfoMakerComputed columns versus computed fieldsWhen creating a report, you can define computed columns and computed
CHAPTER 7 Working with Controls in ReportsUsers Guide 241InfoMaker expressionsYou are entering an InfoMaker expression, not a SQL expression proces
Adding controls to a report 242 InfoMaker❖ To summarize values:1 Select one or more columns in the DataWindow object’s detail band.2 Select one of t
CHAPTER 7 Working with Controls in ReportsUsers Guide 2435 Select a function and click OK.You return to the Toolbar Item Command dialog box.6 Speci
Adding controls to a report 244 InfoMakerControlling the display of buttons in print preview and in printed outputYou can choose whether to display
CHAPTER 7 Working with Controls in ReportsUsers Guide 245Adding graphs to a reportGraphs are one of the best ways to present information. For examp
Reorganizing controls in a report 246 InfoMakerAdding reports to a reportYou can nest reports (nonupdatable DataWindow objects) in a report.For info
CHAPTER 7 Working with Controls in ReportsUsers Guide 2472 Select the Show Edges check box.InfoMaker displays the boundaries of each control in the
CHAPTER 1 Working with InfoMakerUsers Guide 5If you do not see all the available paintersIf you installed InfoMaker from the PowerBuilder Enterpris
Reorganizing controls in a report 248 InfoMakerMoving controls in a reportIn all presentation styles except GridIn all presentation styles except Gr
CHAPTER 7 Working with Controls in ReportsUsers Guide 249Resizing controls in a reportYou can resize a control using the mouse or the keyboard. You
Reorganizing controls in a report 250 InfoMaker4 From the cascading menu, select the dimension along which you want to align the controls.For exampl
CHAPTER 7 Working with Controls in ReportsUsers Guide 251You can also use the Layout drop-down toolbar on PainterBar2 to size controls.Sliding cont
Positioning controls in a report 252 InfoMakerIn the following label, emp_lname, the comma, state, and zip_code are specified as slide left. Edges a
CHAPTER 7 Working with Controls in ReportsUsers Guide 253Default positioningInfoMaker uses the defaults shown in Table 7-4 when you place a new con
Rotating controls in a report 254 InfoMakerFor example, in a grid report, make the band deeper and move the control down into the center of the band
CHAPTER 7 Working with Controls in ReportsUsers Guide 2557 Drag and drop the control in the Design view until it is where you want it.8 In the Desi
Rotating controls in a report 256 InfoMaker
Users Guide 257CHAPTER 8Displaying and Validating Data About this chapterThis chapter describes how to customize your report or form by modifying the
What you can do using InfoMaker 6 InfoMakerHere are a few sample reports:Freeform reportLabel report
About displaying and validating data 258 InfoMakerDatabase painter is requiredYou must have the Database painter installed to define display formats
CHAPTER 8 Displaying and Validating DataUsers Guide 259If you want data to display differently depending on whether the focus is on or off the colu
Working with display formats 260 InfoMakerDisplay formats not used for data entryWhen you tab to a column containing a display format, InfoMaker rem
CHAPTER 8 Displaying and Validating DataUsers Guide 261If the definition of the display format later changes in the extended attribute system table
Working with display formats 262 InfoMaker❖ To associate a display format with a column in the Database painter:1 In the Database painter Objects vi
CHAPTER 8 Displaying and Validating DataUsers Guide 2632 Do one of the following:• Delete the display format.• Select a format in the extended attr
Defining display formats 264 InfoMakerCombining formatsYou can include different types of display format masks in a single format. Use a space to se
CHAPTER 8 Displaying and Validating DataUsers Guide 265Table 8-1 lists the blue, green, and red values you can use in the formula to create other c
Defining display formats 266 InfoMakerUse at least one 0In general, a number display format should include at least one 0. If you enter 0 in a field
CHAPTER 8 Displaying and Validating DataUsers Guide 267String display formatsString display formats can have two sections. The first is required an
CHAPTER 1 Working with InfoMakerUsers Guide 7Group report
Defining display formats 268 InfoMakerSpecial charactersTable 8-4 shows characters that have special meaning in date display formats.Table 8-4: Char
CHAPTER 8 Displaying and Validating DataUsers Guide 269Table 8-5: Date display format examplesTime display formatsTime display formats can have two
About edit styles 270 InfoMakerTime keywordYou can use the following keyword as a time display format to specify the format specified in the Windows
CHAPTER 8 Displaying and Validating DataUsers Guide 271An EditMask edit style is assigned automatically to some numeric and currency columns. To us
Working with edit styles 272 InfoMakerWorking with edit stylesYou work with edit styles in the Database painter, Form painter, and Report painter.Wh
CHAPTER 8 Displaying and Validating DataUsers Guide 273❖ To create a new edit style:1 In the Database painter, select Object>Insert>Edit Styl
Defining edit styles 274 InfoMakerWorking with edit styles in the Form or Report painterAn edit style you assign to a column in the Database painter
CHAPTER 8 Displaying and Validating DataUsers Guide 275• To have entered values display as asterisks for sensitive data, check the Password box. •
Defining edit styles 276 InfoMakerIn the preceding example, when you see the value Business Services, the corresponding data value could be 200.❖ To
CHAPTER 8 Displaying and Validating DataUsers Guide 277Centering check boxes without textYou may find it useful to center check boxes used for colu
ContentsUsers Guide iiiAbout This Book...
What you can do using InfoMaker 8 InfoMakerTreeView reportQueriesReports and forms both use data from your database. In InfoMaker, you use the Query
Defining edit styles 278 InfoMakerThe EditMask edit styleSometimes you need to enter data that has a fixed format. For example, in North America pho
CHAPTER 8 Displaying and Validating DataUsers Guide 279Keyboard behaviorNote the following about how certain keystrokes behave in edit masks:• Both
Defining edit styles 280 InfoMakerThe preferred method of creating a currency editmask is to use the predefined [currency(7)] - International mask.
CHAPTER 8 Displaying and Validating DataUsers Guide 281The DropDownDataWindow edit styleSometimes another data source determines which data is vali
Defining edit styles 282 InfoMakerIn the example, you would specify the DropDownDataWindow edit style for the dept_id column that you want to displa
CHAPTER 8 Displaying and Validating DataUsers Guide 283Limit on size of data valueThe data value for a column that uses the DropDownDataWindow edit
Defining a code table 284 InfoMakerThe InkEdit edit style is fully functional on Tablet PCs. On other computers, it behaves like the Edit edit style
CHAPTER 8 Displaying and Validating DataUsers Guide 285Allowing null valuesAn internal InfoMaker code, NULL!, indicates null values are allowed. To
Defining a code table 286 InfoMakerHow code tables are processedWhen data is retrieved into a report or form column with a code table, processing be
CHAPTER 8 Displaying and Validating DataUsers Guide 287• For the DropDownListBox and DropDownDataWindow edit styles, clear the Allow Editing check
CHAPTER 1 Working with InfoMakerUsers Guide 9FormsIn InfoMaker, you use the Form painter to create and run interactive forms to view and change dat
Working with validation rules 288 InfoMakerUnderstanding validation rulesValidation rules are criteria that a form uses to validate data entered int
CHAPTER 8 Displaying and Validating DataUsers Guide 289Defining validation rulesTypically, you define validation rules in the Database painter, bec
Defining validation rules 290 InfoMaker❖ To modify a validation rule:1 In the Database painter, open the Extended Attributes view.2 In the Extended
CHAPTER 8 Displaying and Validating DataUsers Guide 291Use the notation @placeholder (where placeholder is any group of characters) to indicate the
Defining validation rules 292 InfoMaker'Item ~'' + @Col + '~' does not pass validation test.'You can edit the string e
CHAPTER 8 Displaying and Validating DataUsers Guide 2933 (Optional) Enter a string or string expression to customize the validation error message.F
How to maintain extended attributes 294 InfoMakerTo pass the validation rule, the data must be all digits (must match the text pattern ^[0-9]+$) and
CHAPTER 8 Displaying and Validating DataUsers Guide 2953 Do one of the following:• To create a new entity, display the pop-up menu for the type you
How to maintain extended attributes 296 InfoMaker
Users Guide 297CHAPTER 9Filtering, Sorting, and Grouping Rows About this chapter This chapter describes how you can customize your report by doing the
What you can do using InfoMaker 10 InfoMakerMaster/detail many-to-one formData pipelinesIn InfoMaker, you use the Data Pipeline painter to create an
Filtering rows 298 InfoMakerUsing filtersIn the Report painter, you can define filters to limit the rows that display at runtime. Filters can use mo
CHAPTER 9 Filtering, Sorting, and Grouping RowsUsers Guide 2994 Click OK.Only rows meeting the filter criteria are displayed in the Preview view.Fi
Sorting rows 300 InfoMaker❖ To sort the rows:1 Select Rows>Sort from the menu bar.2 Drag to the Columns box the columns on which you want to sort
CHAPTER 9 Filtering, Sorting, and Grouping RowsUsers Guide 301Suppressing repeating valuesWhen you sort on a column, there might be several rows wi
Grouping rows 302 InfoMakerIf you change your mindYou can remove a column from the suppression list simply by dragging it and releasing it outside t
CHAPTER 9 Filtering, Sorting, and Grouping RowsUsers Guide 303The following screenshot shows the report.How to do itYou can create a grouped report
Grouping rows 304 InfoMakerUsing the Group presentation styleOne of the report presentation styles, Group, is a shortcut to creating a grouped repor
CHAPTER 9 Filtering, Sorting, and Grouping RowsUsers Guide 3055 Click Next.InfoMaker suggests a header based on your data source. For example, if y
Grouping rows 306 InfoMaker• Places the page header and the date (as a computed field) in the header band• Places the page number and page count (as
CHAPTER 9 Filtering, Sorting, and Grouping RowsUsers Guide 307What you can doYou can use any of the techniques available in a tabular report to mod
CHAPTER 1 Working with InfoMakerUsers Guide 11ApplicationsYou can use your reports, forms, and data pipelines within the InfoMaker environment; you
Grouping rows 308 InfoMaker❖ To define subgroups:1 Select Rows>Create Group from the menu bar and specify the column/expression for the subgroup.
CHAPTER 9 Filtering, Sorting, and Grouping RowsUsers Guide 309Rearranging the reportWhen you create a group, InfoMaker creates two new bands for ea
Grouping rows 310 InfoMakerAt runtime, you see this:Suppressing group headersIf you do not want a group header to display at the top of each page wh
CHAPTER 9 Filtering, Sorting, and Grouping RowsUsers Guide 311The Modify Expression dialog box displays.3 Specify the expression that defines the c
Grouping rows 312 InfoMakerThe group trailer band in this example shows the average and total salary for the group.At runtime, the average and total
CHAPTER 9 Filtering, Sorting, and Grouping RowsUsers Guide 313The General property page for the group displays in the Properties view.3 Click the e
Grouping rows 314 InfoMaker7 Specify the expression to sort on. For example, to sort the department group (the first group level) on average salary,
Users Guide 315CHAPTER 10Highlighting Information in Reports and FormsAbout this chapterThis chapter describes how you modify the way information disp
Highlighting information 316 InfoMakerIn most cases, the appearance and behavior of controls is fixed; you do not want them to change at runtime. Wh
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 317In the following report, the Salary Plus Benefits column has a Shadow box bo
The InfoMaker environment 12 InfoMakerThe InfoMaker environmentWhen you start InfoMaker the first timeIn InfoMaker, you always work within the conte
Highlighting information 318 InfoMakerA closer look at the expressionThe expression you enter almost always begins with If. Then you specify three t
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 319Modifying properties conditionally at runtime“Modifying properties at runtim
Modifying properties conditionally at runtime 320 InfoMakerSet Font.Weight property to 700 for boldFont properties such as Italic, Strikethrough, an
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 3213 Select Send to Back from the rectangle’s pop-up menu.4 To hide the border
Modifying properties conditionally at runtime 322 InfoMakerThe Properties view changes to show the properties that are common to all selected contro
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 323To make these controls display in bold with two asterisks if the employee is
Modifying properties conditionally at runtime 324 InfoMakerTipYou can use underlines, italics, strikethrough, borders, and colors to highlight infor
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 325To change properties of the rectangle and the line for rows with the state c
Supplying property values 326 InfoMakerValid values of properties are shown in parentheses in the Properties view wherever possible.For example, the
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 327Background.Color DescriptionSetting for the background color of a control.In
CHAPTER 1 Working with InfoMakerUsers Guide 13About the PowerBarWhat it isThe PowerBar is the main control point for working in InfoMaker. From the
Supplying property values 328 InfoMakerValueA number that specifies the type of border. Values are:0—None1—Shadow box2—Box3—Resize4—Underline5—3D Lo
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 329Brush.ColorDescriptionSetting for the fill color of a graphic control.In the
Supplying property values 330 InfoMakerThe following statement is for the Brush.Color property of the rectangle. If the month of the start date matc
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 331Font.Escapement (for rotating controls)DescriptionThe angle of rotation from
Supplying property values 332 InfoMakerHow to position controls that are rotatedMake the controls movable. To do so, display each control and select
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 333Font.ItalicDescriptionA number that specifies whether the text should be ita
Supplying property values 334 InfoMakerFont.StrikethroughDescriptionA number that specifies whether the text should be crossed out.In the painterStr
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 335Font.UnderlineDescriptionA number that specifies whether the text should be
Supplying property values 336 InfoMakerFormatDescriptionThe display format for a column.In the painterFormat on the Format page in the Properties vi
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 337Pen.ColorDescriptionThe color of the line or the outline of a graphic contro
Working with libraries 14 InfoMakerAbout wizardsInfoMaker provides you with wizards for easy creation of libraries and reports.❖ To access wizards:1
Supplying property values 338 InfoMakerThe following statement is for the Pen.Color property of the line around the edge of the rectangle. If the mo
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 339Pen.WidthDescriptionThe width of the line or the outline of a graphic contro
Supplying property values 340 InfoMakerExampleThe following condition, entered for the Pointer property of every control in a row of expense data, c
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 341The status column must be retrievedThe status column must be included in the
Supplying property values 342 InfoMakerExampleThe following statement causes a rectangle to be located 6.250 inches from the left if the state colum
CHAPTER 10 Highlighting Information in Reports and FormsUsers Guide 343Y1, Y2DescriptionThe distance of each end of the specified line from the top
Specifying colors 344 InfoMakerSample numeric calculationTo create cyan, you use blue and green, but no red. If you wanted to create the most satura
Users Guide 345CHAPTER 11Using Nested Reports About this chapterThis chapter provides information about creating reports that have other reports neste
About nested reports 346 InfoMakerComposite reportFor example, the following composite report consists of three tabular reports. One of the tabular
CHAPTER 11 Using Nested ReportsUsers Guide 347About placing a nested report within another reportYou can place one or more reports within another r
CHAPTER 1 Working with InfoMakerUsers Guide 15❖ To set the current library:1 Click the Select Library button in the PowerBar.2 On the Browse or Rec
About nested reports 348 InfoMakerWhat you see in the Design viewIn the Design view, you see everything in the base report plus a box that represent
CHAPTER 11 Using Nested ReportsUsers Guide 349Limitations on nesting reportsFor the most part you can nest the various types of report styles. Howe
Creating a report using the Composite presentation style 350 InfoMaker5 Select File>Save from the menu bar and assign a name to the composite rep
CHAPTER 11 Using Nested ReportsUsers Guide 351Placing a nested report in another report When you place a nested report in another report, the two r
Placing a nested report in another report 352 InfoMakerThe WHERE clause in this example tells the DBMS to retrieve rows where the value in the colum
CHAPTER 11 Using Nested ReportsUsers Guide 3538 With the report still selected, select the General page of the Properties view. The Arguments box l
Working with nested reports 354 InfoMakerPlacing an unrelated nested report in another reportWhen you place an unrelated nested report in a base rep
CHAPTER 11 Using Nested ReportsUsers Guide 355• “Supplying retrieval arguments to relate a nested report to its base report” on page 357• “Specifyi
Working with nested reports 356 InfoMakerChanging a nested report from one report to anotherYou can change the nested report that is used. For examp
CHAPTER 11 Using Nested ReportsUsers Guide 357Adding another nested report to a composite reportAfter you have created a composite report, you migh
Working with objects 16 InfoMakerWorking with objectsIn InfoMaker, you can:• Create new objects• Open existing objects• Run or preview objectsAfter
Working with nested reports 358 InfoMaker• You must enable caching in the database profile. Set the SQLCache database parameter to the number of lev
CHAPTER 11 Using Nested ReportsUsers Guide 359The Modify Expression dialog box displays. In this dialog box, you can easily select one of the colum
Working with nested reports 360 InfoMakerNotice that the id column is preceded by a colon (:), which is required:When you run the report now, InfoMa
CHAPTER 11 Using Nested ReportsUsers Guide 361Using the Slide optionsInfoMaker determines the appropriate Slide options when positioning the nested
Working with nested reports 362 InfoMaker
Users Guide 363CHAPTER 12Exporting and Importing XML DataAbout this chapterThe row data in a report can be exported and imported in the Extensible Mar
About XML 364 InfoMakerAn XML document is made up of declarations, elements, comments, character references, and processing instructions, indicated
CHAPTER 12 Exporting and Importing XML DataUsers Guide 365XML Schema provides an alternative mechanism for describing and validating XML data. It p
About XML 366 InfoMaker<td>Mouse</td></tr></table>Representing empty elementsEmpty elements cannot be represented in XML in
CHAPTER 12 Exporting and Importing XML DataUsers Guide 367Xerces parserInfoMaker includes software developed by the Apache Software Foundation (htt
CHAPTER 1 Working with InfoMakerUsers Guide 17If you chose the Object tab page and you are creating a report, at this point you use a wizard. If yo
The Export/Import Template view for XML 368 InfoMakerThe Export/Import Template view for XMLYou define and edit templates for export and import in t
CHAPTER 12 Exporting and Importing XML DataUsers Guide 369Creating, opening, and saving templatesFrom the pop-up menu for the Export/Import Templat
The Export/Import Template view for XML 370 InfoMakerCreating templatesTo create a template, select the New menu item or the New Default menu item f
CHAPTER 12 Exporting and Importing XML DataUsers Guide 371The SQL syntax is:SELECT "employee"."dept_id","employee".&q
The Export/Import Template view for XML 372 InfoMakerThe Detail section contains the row data, and is generated iteratively for each row in the repo
CHAPTER 12 Exporting and Importing XML DataUsers Guide 373Header sectionThe Header section can contain the items listed in Table 12-2. Only the roo
Editing XML templates 374 InfoMakerEditing XML templatesUsing templates for data importIf you use a template created for data export, InfoMaker expr
CHAPTER 12 Exporting and Importing XML DataUsers Guide 375The examples in this section show the delimiters used in the XML document. When you edit
Editing XML templates 376 InfoMakerDocument type declarationThe document type declaration contains or points to markup declarations that provide a g
CHAPTER 12 Exporting and Importing XML DataUsers Guide 377<!ELEMENT Date (#PCDATA)><!ELEMENT CustID (#PCDATA)><!ELEMENT OrderID (#PC
ContentsivInfoMakerWorking with tools... 26Using property pages...
Working in painters 18 InfoMakerAccessing recently opened objectsYou can quickly open recently opened objects by selecting File>Recent Objects fr
Editing XML templates 378 InfoMakerDrag-and-drop cannot replaceYou cannot drag-and-drop an item on top of another item to replace it. For example, i
CHAPTER 12 Exporting and Importing XML DataUsers Guide 379For each attribute specified, you can select a control reference from the drop-down list
Editing XML templates 380 InfoMakerComposite reportsFor composite reports that use the Composite presentation style, the default template has elemen
CHAPTER 12 Exporting and Importing XML DataUsers Guide 381CDATA sectionsYou can export the name of a column in a CDATA section using the syntax <
Exporting to XML 382 InfoMakerProcessing instructionsProcessing instructions (PIs) enable you to provide information to the application that uses th
CHAPTER 12 Exporting and Importing XML DataUsers Guide 383Setting data export propertiesThe Data Export page in the Properties view lets you set pr
Exporting to XML 384 InfoMaker❖ To save to XML using the current template:1 Right-click in the Export/Import template view and select Save or Save A
CHAPTER 12 Exporting and Importing XML DataUsers Guide 385<Orders><Order id="2001"><OrderDate>2002-03-14</OrderDate&
Exporting to XML 386 InfoMakerFor reports with more than one group, when you generate a new default template, each group after the first is identifi
CHAPTER 12 Exporting and Importing XML DataUsers Guide 387</order_item><order_item><sales_order_items_line_id>2</sales_order_i
CHAPTER 1 Working with InfoMakerUsers Guide 19Opening paintersPainters that edit objectsThere are several ways to open painters that edit objects:O
Exporting to XML 388 InfoMakerTo specify how metadata should be saved, select a value from the Meta Data Type drop-down list. The possible values ar
CHAPTER 12 Exporting and Importing XML DataUsers Guide 389<dtdinternal><dtdinternal_row><id>1</id><last_name>Hildebra
Exporting to XML 390 InfoMaker<!ELEMENT fax (#PCDATA)>Associating a namespace with an exported schemaIf you export metadata in the form of a s
CHAPTER 12 Exporting and Importing XML DataUsers Guide 391<xs:element name="state" type="xs:string"/></xs:schema>&l
Importing XML 392 InfoMakerFor complex, nested XML with row data in an iterative structure, you may need to design a structure that uses several lin
CHAPTER 12 Exporting and Importing XML DataUsers Guide 393Importing data with group headersFor XML import using a template, element and attribute c
Importing XML 394 InfoMakerExampleThis example uses a report that includes the columns emp_id, emp_fname, emp_lname, and dept_id. The template used
CHAPTER 12 Exporting and Importing XML DataUsers Guide 395</name></employee><employee dept_id="100"><emp_id>105&l
Importing XML 396 InfoMakerEmpty elementsEmpty elements (elements that have no content between the start and end tags) are imported as empty values
CHAPTER 12 Exporting and Importing XML DataUsers Guide 397<element_2>Julie</element_2><element_3>Jordan</element_3><elem
Working in painters 20 InfoMakerViews are displayed in panes in the painter window. Some views are stacked in a single pane. At the bottom of the pa
Importing XML 398 InfoMakerResultAll three XML documents produce this result:Example with empty elementsExample 4This example uses the same report,
CHAPTER 12 Exporting and Importing XML DataUsers Guide 399Tracing importWhen you import data from XML with or without a template, you can create a
Importing XML 400 InfoMakerExample: template importThe following trace log shows a template import of the department table. The template used is nam
Users Guide 401CHAPTER 13Working with Graphs About this chapter This chapter describes how to build and use graphs in InfoMaker.ContentsAbout graphs O
About graphs 402 InfoMakerParts of a graphHere is a column graph created in InfoMaker that contains most major parts of a graph. It shows quarterly
CHAPTER 13 Working with GraphsUsers Guide 403Organization of a graphTable 13-2 lists the parts of a typical graph.Table 13-2: Organization of a gra
About graphs 404 InfoMakerTypes of graphsInfoMaker provides many types of graphs for you to choose from. You choose the type on the Define Graph Sty
CHAPTER 13 Working with GraphsUsers Guide 405Pie graphsPie graphs typically show one series of data points with each data point shown as a percenta
About graphs 406 InfoMakerHere is the data in a scatter graph:You can have multiple series of data in a scatter graph. You might want to plot mileag
CHAPTER 13 Working with GraphsUsers Guide 407DirectX 3D graphsDirectX 3D rendering allows you to display the 3D graphs (Pie3D, Bar3D, Column3D, Lin
CHAPTER 1 Working with InfoMakerUsers Guide 21Moving and resizing panes and viewsYou can move a pane or a view to any location in the painter windo
Using graphs in reports 408 InfoMakerStacked graphsIn bar and column graphs, you can choose to stack the bars and columns. In stacked graphs, each c
CHAPTER 13 Working with GraphsUsers Guide 409Placing a graph in a report❖ To place a graph in a report:1 Open or create the report that will contai
Using graphs in reports 410 InfoMakerUsing the graph's Properties viewA graph has a Properties view in which you can specify the data as well a
CHAPTER 13 Working with GraphsUsers Guide 411The initial graph is also moveable and resizable, so you have complete flexibility as to the size and
Using graphs in reports 412 InfoMakerAssociating data with a graphWhen using a graph in a report, you associate axes of the graph with columns in th
CHAPTER 13 Working with GraphsUsers Guide 413Specifying the categoriesSpecify the column or expression whose values determine the categories. In th
Using graphs in reports 414 InfoMakerTo graph 110 percent of the sum of units sold, you can specify:sum(units*1.1 for graph)Specifying the seriesGra
CHAPTER 13 Working with GraphsUsers Guide 415ExamplesThis section shows how to specify the data for several different graphs of the data in the Pri
Using graphs in reports 416 InfoMakerThe Quarter column serves as the category. Because the Quarter column has four values (Q1, Q2, Q3, and Q4), the
CHAPTER 13 Working with GraphsUsers Guide 417Graphing unit sales of each printerTo graph total quarterly sales of each printer, retrieve all the co
Working in painters 22 InfoMaker3 Release the mouse button to drop the outline in the new location:❖ To move a view in a stacked pane:• Place the po
Using graphs in reports 418 InfoMakerHere is the resulting graph:Graphing unit sales by representative and total salesTo graph quarterly sales made
CHAPTER 13 Working with GraphsUsers Guide 419Here is the resulting graph:Notice that InfoMaker uses the literal “Total” supplied in the Category bo
Using the Graph presentation style 420 InfoMakerHere is the resulting graph. InfoMaker uses the literals you typed for the series as the series labe
CHAPTER 13 Working with GraphsUsers Guide 4217 On the Ready to Create Graph DataWindow page, review your specifications and click Finish.A model of
Defining a graph's properties 422 InfoMakerDefining a graph's titleThe title displays at the top of the graph.❖ To specify a graph's
CHAPTER 13 Working with GraphsUsers Guide 423Sorting data for series and categoriesYou can specify how to sort the data for series and categories.
Defining a graph's properties 424 InfoMaker2 Select a text element from the list in the Text Object drop-down list.3 Specify the font and its c
CHAPTER 13 Working with GraphsUsers Guide 425Using display formats❖ To use a display format for a text element in a graph:1 On the Text properties
Defining a graph's properties 426 InfoMakerTo accomplish this, the display expressions were modified for the title and pie graph labels:Specify
CHAPTER 13 Working with GraphsUsers Guide 427Specifying axis propertiesGraphs have two or three axes. You specify the axes’ properties in the Axis
CHAPTER 1 Working with InfoMakerUsers Guide 23❖ To float a view in a stacked pane:• Select Float from the tab’s pop-up menu.❖ To dock a floating vi
Defining a graph's properties 428 InfoMakerTable 13-11: Properties for scaling on numeric axesUsing major and minor divisionsYou can divide axe
CHAPTER 13 Working with GraphsUsers Guide 429Representing divisions with grid and drop linesYou can specify lines to represent the divisions as des
Defining a graph's properties 430 InfoMaker
Users Guide 431CHAPTER 14Working with Crosstabs About this chapterThis chapter describes how to build crosstabs.ContentsAbout crosstabs Cross tabulati
About crosstabs 432 InfoMakerTable 14-1: The Printer table in the EAS Demo DBThis information can be summarized in a crosstab. Here is a crosstab th
CHAPTER 14 Working with CrosstabsUsers Guide 433The first-quarter sales of Cosmic printers displays in the first data cell. (As you can see from th
Creating crosstabs 434 InfoMakerDynamic crosstabsWith dynamic crosstabs, InfoMaker builds all the columns and rows in the crosstab dynamically when
CHAPTER 14 Working with CrosstabsUsers Guide 435The New dialog box displays.2 Select the Object tab.3 Select the Crosstab presentation style, then
Associating data with a crosstab 436 InfoMakerAssociating data with a crosstab You associate crosstab columns, rows, and cell values with columns in
CHAPTER 14 Working with CrosstabsUsers Guide 437Dynamic crosstab exampleThe process is illustrated using the following dynamic crosstab. The column
Working in painters 24 InfoMakerSaving a layoutWhen you have rearranged panes in the painter window, InfoMaker saves the layout in the registry. The
Associating data with a crosstab 438 InfoMakerColumns that use code tablesIf you specify columns in the database that use code tables, where data is
CHAPTER 14 Working with CrosstabsUsers Guide 439❖ To specify an expression for columns, rows, or values:1 In the Crosstab Definition dialog box (or
Associating data with a crosstab 440 InfoMakerIn the Design view, the crosstab looks like this:Notice that in the Design view, InfoMaker shows the q
CHAPTER 14 Working with CrosstabsUsers Guide 441Specifying more than one row or columnTypically you specify one database column as the Columns defi
Previewing crosstabs 442 InfoMakerPreviewing crosstabs When you have defined the crosstab, you can see it with data in the Preview view.❖ To preview
CHAPTER 14 Working with CrosstabsUsers Guide 443The rest of this section covers topics either unique to crosstabs or especially important when work
Enhancing crosstabs 444 InfoMakerModifying the data associated with the crosstabWhen you initially define the crosstab, you associate the crosstab r
CHAPTER 14 Working with CrosstabsUsers Guide 445When the crosstab runs, you see this:Defining summary statisticsWhen you generate a crosstab, the c
Enhancing crosstabs 446 InfoMakerFor example, this is a crosstab that has been enhanced to show averages and maximum values for each column. This is
CHAPTER 14 Working with CrosstabsUsers Guide 447Using crosstab functionsThere are nine special functions you can use only in crosstabs: CrosstabAvg
CHAPTER 1 Working with InfoMakerUsers Guide 25ExampleFor example, the following screen shows the pop-up menu for a column in a report:❖ To display
Enhancing crosstabs 448 InfoMakerHere CrosstabSum(1) returns the total of sum(units for crosstab) for the corresponding row. CrosstabSum(2) returns
CHAPTER 14 Working with CrosstabsUsers Guide 449The first step is to determine the expression that, given a salary, returns the next smaller salary
Enhancing crosstabs 450 InfoMakerThis is the result in the Design view:This is the crosstab at runtime:You can see, for example, that 2 people in de
CHAPTER 14 Working with CrosstabsUsers Guide 451❖ To display blank values in a crosstab as zero:1 Select the column you want to modify and click th
Enhancing crosstabs 452 InfoMakerFor example, in the following screenshot, the four values for Quarter (Q1, Q2, Q3, and Q4) are displayed in the Des
CHAPTER 14 Working with CrosstabsUsers Guide 453ExampleIn the following crosstab, an expression has been specified for Units:The expression is for
Enhancing crosstabs 454 InfoMaker
Users Guide 455CHAPTER 15Working with TreeViewsAbout this chapterThis chapter describes how to build and use reports in InfoMaker using the TreeView p
Creating a new TreeView report 456 InfoMakerExampleThis sample TreeView report uses the department and employee tables in the EAS Demo DB database a
CHAPTER 15 Working with TreeViewsUsers Guide 457TreeView creation processA TreeView report has multiple levels, each of which is a node in the Tree
Working with tools 26 InfoMaker2 Define your custom colors:Working with toolsInfoMaker provides you with tools to help you with your work.Opening a
Creating a new TreeView report 458 InfoMaker4 Define the tables and columns you want to use.You are prompted to specify the TreeView grouping column
CHAPTER 15 Working with TreeViewsUsers Guide 4597 Click Next.8 Modify the default color and border settings if needed, and then click Next.9 Review
Creating a new TreeView report 460 InfoMakerIf you selected the Grid Style check box, vertical and horizontal grid lines display:Here is the sample
CHAPTER 15 Working with TreeViewsUsers Guide 461What you can doAll of the techniques available in a tabular report, such as moving controls and spe
Selecting a tree node and navigating the tree 462 InfoMaker4 Click OK.The new TreeView level and a Trailer band for that level are created in the Tr
CHAPTER 15 Working with TreeViewsUsers Guide 463Sorting rows in a TreeView report❖ To sort the rows within levels in a TreeView report:1 Select Row
TreeView report Design view 464 InfoMakerTreeView report Design viewThe Design view for the TreeView report differs from the traditional Design view
CHAPTER 15 Working with TreeViewsUsers Guide 465• When there is no tree node icon specified, a shaded square icon in the detail band and in each Tr
Setting properties for the TreeView report 466 InfoMakerSetting general TreeView propertiesYou set most TreeView report properties on the General pa
CHAPTER 15 Working with TreeViewsUsers Guide 467Setting TreeView level propertiesIn the Properties view for a band, you can specify expanded and co
CHAPTER 1 Working with InfoMakerUsers Guide 27Using property pagesA property page is a page in a tabbed dialog box you use to set properties associ
Setting properties for the TreeView report 468 InfoMaker2 Use the report TreeView Level properties view that displays to edit the properties for the
CHAPTER 15 Working with TreeViewsUsers Guide 469Setting detail band propertiesYou can specify an icon for the rows in the detail band by clicking t
Setting properties for the TreeView report 470 InfoMaker
Users Guide 471CHAPTER 16Working with Rich Text About this chapterThis chapter explains how to create reports using the RichText presentation style.Co
Using the RichText presentation style 472 InfoMakerYou can use toolbars, editing keys, and a pop-up menu to specify formatting. A print preview lets
CHAPTER 16 Working with Rich TextUsers Guide 473If an input field is not a computed field and its name does not match a column, there is no way to
Using the RichText presentation style 474 InfoMakerAvailable settingsTable 16-1 describes the types of settings you can make for the RichText report
CHAPTER 16 Working with Rich TextUsers Guide 475This sample shows how you might rearrange the input fields in a sales letter:Editing textYou can ad
Using the RichText presentation style 476 InfoMakerHeaders and footersYou decide whether your RichText report has a header and footer by checking He
CHAPTER 16 Working with Rich TextUsers Guide 477The whole RichText reportSettings for the whole RichText report include the values you specified in
ContentsUsers Guide vOpening and previewing objects... 63Copying, moving, and deleting objects...
Using property pages 28 InfoMakerHow property pages work in the Properties viewThe Properties view is dynamically updated when you select another ob
Using the RichText presentation style 478 InfoMakerParagraphsThere are also settings for selected paragraphs. You can display the Paragraph dialog b
CHAPTER 16 Working with Rich TextUsers Guide 479Computed field input fields When you display the dialog box for a computed field, the settings are
Using the RichText presentation style 480 InfoMakerIf there are multiple copies of a computed field input field, the expression and format settings
CHAPTER 16 Working with Rich TextUsers Guide 481Previewing and printingTo see what the RichText report looks like with data, you can preview it in
Formatting keys and toolbars 482 InfoMakerSetting marginsTo specify permanent margin settings for the RichText report, use the Print Specifications
CHAPTER 16 Working with Rich TextUsers Guide 483Navigating and selecting textTable 16-3: Keyboard shortcuts for navigating and selecting textAligni
Formatting keys and toolbars 484 InfoMaker
Users Guide 485CHAPTER 17Using OLE in a Report About this chapterThis chapter describes how to use OLE in reports.ContentsAbout using OLE in reports A
About using OLE in reports 486 InfoMaker• OLE presentation style The OLE presentation style is similar to an OLE object in a report. The difference
CHAPTER 17 Using OLE in a ReportUsers Guide 487OLE objects and the OLE presentation style Whether you insert an OLE object into a report or create
CHAPTER 1 Working with InfoMakerUsers Guide 29Using toolbarsToolbars provide buttons for the most common tasks in InfoMaker. You can move (dock) to
OLE objects and the OLE presentation style 488 InfoMakerIn this sectionThis section includes procedures for:• Adding an OLE object to a report• Usin
CHAPTER 17 Using OLE in a ReportUsers Guide 489Using the OLE presentation styleUse the OLE presentation style to create a report that consists of a
OLE objects and the OLE presentation style 490 InfoMakerDefining the OLE objectYou define the OLE object in the Insert Object dialog box. It has thr
CHAPTER 17 Using OLE in a ReportUsers Guide 491Create From FileUse the following procedure if you want to link or embed the contents of an existing
OLE objects and the OLE presentation style 492 InfoMakerIf you click Register New, you are prompted for the file that contains the registration info
CHAPTER 17 Using OLE in a ReportUsers Guide 493The way the OLE object uses the data depends on the server. For example, data transferred to Microso
OLE objects and the OLE presentation style 494 InfoMaker3 If necessary, change the order of columns by dragging them up or down within the Target Da
CHAPTER 17 Using OLE in a ReportUsers Guide 495Table 17-1: Associating an OLE object with rows in the reportRange of rows and activating the object
OLE objects and the OLE presentation style 496 InfoMakerPreviewing the reportPreviewing the report lets you see how the OLE object displays the data
CHAPTER 17 Using OLE in a ReportUsers Guide 497In previewInfoMaker displays the initial presentation of the OLE object while it is retrieving rows
Using toolbars 30 InfoMakerDefault button replacedThe button you select from a drop-down toolbar replaces the default button on the main toolbar. Fo
Using OLE columns in a report 498 InfoMakerUsing OLE columns in a report You can create OLE columns in a report. An OLE column allows you to retriev
CHAPTER 17 Using OLE in a ReportUsers Guide 4992 Specify the table containing the blob as the data source for the report. Be sure to include the ke
Using OLE columns in a report 500 InfoMaker3 In the Table box, select the database table that contains the blob database column you want to place in
CHAPTER 17 Using OLE in a ReportUsers Guide 5017 Enter text or an expression that evaluates to a string in the Client Name Expression box.The serve
Using OLE columns in a report 502 InfoMaker
PART 4 FormsThis part describes how to use forms to display and change information in your databaseAccess to the Form painterTo have access to the Fo
Users Guide 505CHAPTER 18Defining FormsAbout this chapterYou use forms to add data to your database easily and efficiently. This chapter introduces In
About forms 506 InfoMakerThe following illustration shows the Employee table in the EAS Demo DB, which has 20 columns of data for 75 employees. When
CHAPTER 18 Defining FormsUsers Guide 507Forms in InfoMaker and in an InfoMaker applicationAfter you design a form, you can use it within InfoMaker.
CHAPTER 1 Working with InfoMakerUsers Guide 31Moving toolbars using the mouseYou can use the mouse to move a toolbar.❖ To move a toolbar with the m
About forms 508 InfoMakerData sourcesThe data source you use determines how InfoMaker retrieves data for your form. You can select one of three data
CHAPTER 18 Defining FormsUsers Guide 509For example, you can place a button in a form and then attach the Print action to it. After you run the for
About forms 510 InfoMakerAfter a few enhancements have been made to the basic form, here is the freeform form with data:Grid formsYou use grid forms
CHAPTER 18 Defining FormsUsers Guide 511Working in a grid formWhen you design and run a grid form, you can resize and reorder columns. ❖ To resize
About forms 512 InfoMakerYou may want to display this type of relationship in a form. Such a form is called a master/detail one-to-many form.For exa
CHAPTER 18 Defining FormsUsers Guide 513Note that there is a primary/foreign key relationship between the tables: the Dept_id column in the Employe
Creating and saving forms 514 InfoMakerFor example, the following form lists all customers at the top (the master area) and the details for the sele
CHAPTER 18 Defining FormsUsers Guide 515❖ To create a basic form:1 Click the New button in the PowerBar.2 Select the Object tab, the Form icon, and
Creating and saving forms 516 InfoMakerInfoMaker generates the basic form and displays it in the Form painter Layout view. The following illustratio
CHAPTER 18 Defining FormsUsers Guide 517You must use Quick SelectYou must use Quick Select and you can select only one master table and one detail
Using toolbars 32 InfoMakerThe Customize dialog box displays.3 Click the palette of buttons you want to use in the Select palette group.4 Choose a b
Creating and saving forms 518 InfoMakerIf you are told the data is not updatableAfter selecting the columns, you might see a message box telling you
CHAPTER 18 Defining FormsUsers Guide 519When the master table and the detail table are the same table, the complete Select Master/Detail Relationsh
Creating and saving forms 520 InfoMakerWhen you run the form, the form displays with data:At this point, you can enhance the form. To do so, you fir
CHAPTER 18 Defining FormsUsers Guide 521About the master/detail form stylesThe master/detail one-to-many and master/detail many-to-one form styles
Creating and saving forms 522 InfoMakerThese 12 columns were selected because in the database these columns were defined as requiring values. By sel
CHAPTER 18 Defining FormsUsers Guide 523❖ To save the form:1 Do one of the following:• Click the Save button.• Select File>Save from the menu ba
Working with forms 524 InfoMakerWhat happensYou are now running the form. Command buttons and picture buttons you have placed in the form are now ac
CHAPTER 18 Defining FormsUsers Guide 525InfoMaker clears all the data.2 Specify the criteria.In master/detail forms, you specify the criteria in th
Working with forms 526 InfoMaker2 Navigate to the folder you want and select the file from which you want to import the data. The types of files tha
CHAPTER 18 Defining FormsUsers Guide 5274 Click Save.InfoMaker saves all rows in the file; all columns in the rows are saved.Printing formsAlthough
CHAPTER 1 Working with InfoMakerUsers Guide 33❖ To delete a button from a toolbar:1 Position the pointer on the toolbar, display the pop-up menu, a
Working with forms 528 InfoMakerTable 18-1: Cross reference of actions to buttons in a formAction Menu item What the action doesForm styles availabl
CHAPTER 18 Defining FormsUsers Guide 529Next_Row Rows>Next Scrolls to the next row Freeform, Master/Detail One-To-ManyPrint File>Print Prints
Working with forms 530 InfoMakerAccessing and deleting forms❖ To access a form:1 Click the Open button in the PowerBar.The Open dialog box displays:
Users Guide 531CHAPTER 19Controlling Updates in FormsAbout this chapterWhen InfoMaker generates the basic form, it defines whether the data is updatab
About controlling updates 532 InfoMakerWhat you can doYou can:• Allow updates in a form associated with multiple tables or a view; you can define on
CHAPTER 19 Controlling Updates in FormsUsers Guide 533Specifying the table to updateEach form can update one table, which you select from the Table
Specifying an identity column 534 InfoMakerSpecifying an identity columnMany DBMSs allow you to specify that the value for a column in a new row is
CHAPTER 19 Controlling Updates in FormsUsers Guide 535Specifying the WHERE clause for update/deleteSometimes multiple users are accessing the same
Specifying the WHERE clause for update/delete 536 InfoMakerTable 19-1: Specifying the WHERE clause for UPDATE and DELETE ExampleConsider this situat
CHAPTER 19 Controlling Updates in FormsUsers Guide 537This statement will succeed regardless of whether other users have modified the row since you
Using toolbars 34 InfoMaker❖ To add a custom button:1 Position the pointer on the toolbar, display the pop-up menu, and select Customize.2 Select Cu
Specifying update when key is modified 538 InfoMakerHow to choose a settingConsider the following when choosing the Key Modification setting:• If mu
Users Guide 539CHAPTER 20Enhancing FormsAbout this chapterBefore using a form, you might want to enhance it to make it easier to use and interpret dat
Working in the Form painter Layout view 540 InfoMakerWorking in the Form painter Layout viewHere is the Form painter Layout view for a Freeform form
CHAPTER 20 Enhancing FormsUsers Guide 541About the PainterBarsThe Form painter PainterBars have buttons for operations such as Save, Close, and Run
Working in the Form painter Layout view 542 InfoMakerUsing the pop-up menus in the Form painterEach element of the form (such as text, columns, comp
CHAPTER 20 Enhancing FormsUsers Guide 543Here is the Properties view for the column employee_street. It has several tabbed property pages of inform
Working in the Form painter Layout view 544 InfoMaker❖ To select neighboring multiple controls in a form:1 Press and hold the left mouse button at o
CHAPTER 20 Enhancing FormsUsers Guide 545❖ To specify default colors and borders for a Freeform or Grid style form:1 Select Design>Options from
Reorganizing controls in the form 546 InfoMakerPrinting the form definitionAt any point when you are working on a form, you can print a document tha
CHAPTER 20 Enhancing FormsUsers Guide 547The options are:Deleting controls in the Form painter❖ To delete controls in the Form painter:1 Select the
CHAPTER 1 Working with InfoMakerUsers Guide 355 In the Item Text box, specify the text associated with the button in two parts separated by a comma
Reorganizing controls in the form 548 InfoMakerInfoMaker selects the column and displays a line representing the column border:3 Drag the column lef
CHAPTER 20 Enhancing FormsUsers Guide 549Resizing controls in the Form painterYou can resize a control using the mouse or the keyboard.Using the mo
Reorganizing controls in the form 550 InfoMakerAvoid lasso selection for aligning controlsAvoid selecting controls by dragging the mouse to put a bo
CHAPTER 20 Enhancing FormsUsers Guide 551Equalizing the size of controls in the Form painterSay you have several controls in a form and want their
Reorganizing controls in the form 552 InfoMaker❖ To use sliding columns or controls:1 Select Properties from the pop-up menu of the controls and the
CHAPTER 20 Enhancing FormsUsers Guide 553Modifying general form propertiesThis section describes the general form properties you can modify.Specify
Modifying general form properties 554 InfoMaker❖ To set colors for a form:• Do one of the following: Defining your own colorsYou can define your own
CHAPTER 20 Enhancing FormsUsers Guide 555Specifying the display of scrollbars for a formYou can specify whether your form has scrollbars when you r
Modifying general form properties 556 InfoMaker❖ To modify text in a form:1 Select the text.The first box in the StyleBar is now active:2 Type the n
CHAPTER 20 Enhancing FormsUsers Guide 557The value 0 removes the control from the tab order so that you cannot tab to the control. It does not matt
Using toolbars 36 InfoMakerModifying a custom button❖ To modify a custom button:1 Position the pointer on the toolbar, display the pop-up menu, and
Modifying general form properties 558 InfoMakerPrompting for retrieval criteria in a formYou can define your form so that it always prompts you for
CHAPTER 20 Enhancing FormsUsers Guide 559Using edit stylesIf a column uses a code table or the RadioButton, CheckBox, or DropDownListBox edit style
Modifying general form properties 560 InfoMakerModifying the data source of a formWhen modifying a form, you might realize that you have not include
CHAPTER 20 Enhancing FormsUsers Guide 561Adding controls to the formThe topics in this section describe how to enhance a form by adding controls:Ad
Adding controls to the form 562 InfoMakerAdding computed fields to a formYou can use computed fields to perform calculations in the form. Typical us
CHAPTER 20 Enhancing FormsUsers Guide 563If you want computed values to change dynamically, define computed fields in the Form painter, as describe
Adding controls to the form 564 InfoMakerAbout the Modify Expression dialog boxThe Modify Expression dialog box provides you with lists and buttons
CHAPTER 20 Enhancing FormsUsers Guide 565For more information about the functions you can use in computed fields in the Form painter, see Chapter 2
Adding controls to the form 566 InfoMakerAdding command buttons to a formYou can add command buttons to a form. Command buttons are used to carry ou
CHAPTER 20 Enhancing FormsUsers Guide 567❖ To associate an action with a button:1 Move the pointer to the button you added to the form, display the
CHAPTER 1 Working with InfoMakerUsers Guide 37Using report wizardsAccessing report wizardsReport wizards help you create a report with a specific p
Adding controls to the form 568 InfoMakerAdding picture buttons to a formPicture buttons are identical to command buttons in their functionality. Th
CHAPTER 20 Enhancing FormsUsers Guide 5693 In the Properties view, supply the name of the report to show in the control. You can use the browse but
Highlighting information in a form 570 InfoMaker❖ To group controls with a round rectangle and text in the Form painter:1 Select Insert>RoundRect
CHAPTER 20 Enhancing FormsUsers Guide 571You modify properties based on conditions you specify by entering an expression in the Properties view for
Displaying and validating data in a form 572 InfoMaker
PART 5 ApplicationsThis part describes how to create and deploy InfoMaker applications.
Users Guide 575CHAPTER 21Working with ApplicationsAbout this chapterYou can bundle reports, forms, and data pipelines into a package to create a repor
Creating an application 576 InfoMakerIdentifying an applicationMost applications can be identified by selecting Help>About to display information
CHAPTER 21 Working with ApplicationsUsers Guide 577❖ To create an application:1 Connect to the database that the executable will use.2 Open the Lib
ContentsviInfoMakerViewing row information... 113Importing data ...
Using the To-Do List 38 InfoMakerUsing the To-Do ListOpening the To-Do ListThe To-Do List displays a list of tasks you want to do in the current lib
Creating an application 578 InfoMakerThe values you specify become part of the Version resource associated with the executable file. The names you e
CHAPTER 21 Working with ApplicationsUsers Guide 5798 Click the Browse button next to the Executable Icon box to assign an icon to the executable fi
Creating an application 580 InfoMaker12 Select the reports, forms, and pipelines you want to package in the application.13 Click Next.The Executable
CHAPTER 21 Working with ApplicationsUsers Guide 581To quickly prototype an applicationThe remaining steps describe how to define text, MicroHelp, a
Reusing an application 582 InfoMaker16 If you want to omit a report from the list of reports in the generated application so that users cannot run i
CHAPTER 21 Working with ApplicationsUsers Guide 583❖ To reuse the most recent application associated with a library:1 Connect to the database, open
Running an application 584 InfoMaker❖ To modify the Start In property of the application shortcut:1 Position the pointer on the icon, display the po
CHAPTER 21 Working with ApplicationsUsers Guide 585Identifying your applicationMost applications can be identified by selecting Help>About to di
Running an application 586 InfoMakerRunning a report, form, or pipelineTo run a report, form, or pipeline, you can do any of the following:• Click i
CHAPTER 21 Working with ApplicationsUsers Guide 587Managing the toolbarYou can move the toolbar and suppress the display of text in the toolbar by
CHAPTER 1 Working with InfoMakerUsers Guide 39Using online HelpInfoMaker has online Help that provides both reference and task-oriented information
Using a pipeline in an application 588 InfoMakerYou can print the log or save the log to any report format. Users may need to send the log to you to
CHAPTER 21 Working with ApplicationsUsers Guide 5893 In the Start boxes, specify the execution date and time.The day, month, numerical day, and yea
Using a pipeline in an application 590 InfoMakerFor information about adding a [Pipe] section to the initialization file, see “Modifying the pipelin
CHAPTER 21 Working with ApplicationsUsers Guide 591❖ To enable users to modify the pipeline’s definition:1 Open the application’s initialization fi
Using a pipeline in an application 592 InfoMaker❖ To modify the pipeline type:1 Select Actions>Pipeline Type from the menu bar.A menu of pipeline
CHAPTER 21 Working with ApplicationsUsers Guide 5932 Select the Max Errors value:❖ To specify whether or not to pipe extended attributes:• Select o
Starting an application from the command line 594 InfoMakerOpening an object or creating a new objectYou can also add one or more of the following o
Users Guide 595CHAPTER 22Deploying Your ApplicationAbout this chapterThis chapter provides information required for deploying applications to users’ c
About deploying applications 596 InfoMakerFigure 22-1: Deploying an InfoMaker applicationTo set up a user’s machine to run your application, you nee
CHAPTER 22 Deploying Your ApplicationUsers Guide 5975 Install the database runtime files on the user’s computer.6 Configure your ODBC drivers, syst
Using online Help 40 InfoMakerAbout links from Help to book contentSome Help topics provide links to book content to extend online Help. The book co
Installing InfoMaker runtime files 598 InfoMakerMicrosoft filesWhen you deploy the core InfoMaker runtime files, you must also deploy the msvcr71.dl
CHAPTER 22 Deploying Your ApplicationUsers Guide 599Making the data source availableYour users need access to the DBMS and to the database your app
Making the data source available 600 InfoMakerInstalling ODBC and system filesIf your application uses ODBC drivers, each user’s computer needs thre
CHAPTER 22 Deploying Your ApplicationUsers Guide 601[HKEY_CURRENT_USER\SOFTWARE\ODBC\ODBC.INI\MyApp DB]"Driver"="C:\Program Files\SQ
Making the data source available 602 InfoMakerCurrentVersion\App Paths\myapp.exe]"Default"="C:\Program Files\myapps\MYAPP.EXE"&q
CHAPTER 22 Deploying Your ApplicationUsers Guide 603If your application uses a standalone database, you can deploy the SQL Anywhere Desktop Runtime
Making the data source available 604 InfoMakerOLE DB database providersIf your application uses OLE DB to access data, you must install Microsoft’s
CHAPTER 22 Deploying Your ApplicationUsers Guide 605Table 22-5: PowerBuilder JDB interface filesJava supportYou must deploy the pbjvm115.dll file w
Making the data source available 606 InfoMakerIf none of these directory structures is found, InfoMaker uses the first jvm.dll whose location is def
CHAPTER 22 Deploying Your ApplicationUsers Guide 607You can override either the configuration or properties entries or both. If you make incorrect
CHAPTER 1 Working with InfoMakerUsers Guide 41Windows Help files on VistaWindows Vista does not distribute the WinHlp32.exe file required to open W
Saving as PDF and XSL-FO 608 InfoMaker❖ To install Ghostscript:1 Into a temporary directory on your computer, download the self-extracting executabl
CHAPTER 22 Deploying Your ApplicationUsers Guide 609You must also deploy the related files that are installed in Sybase\Shared\PowerBuilder\drivers
Installing the executable application and supporting files 610 InfoMakerInstalling the executable application and supporting filesWhen you install y
CHAPTER 22 Deploying Your ApplicationUsers Guide 611Starting the deployed applicationYour users can run your application the same way they run othe
Starting the deployed application 612 InfoMaker
PART 6 ReferenceThis part describes using operators and expressions and InfoMaker expression functions.
Users Guide 615CHAPTER 23Operators and ExpressionsAbout this chapterYou use an expression to request that InfoMaker perform a computational operation.
Where you use expressions 616 InfoMakerIn painters, you use expressions in these ways:Table 23-1: Using expressions in InfoMaker paintersOther types
CHAPTER 23 Operators and ExpressionsUsers Guide 617In filtersFilter expressions are boolean expressions that must evaluate to true or false:Table 2
Customizing keyboard shortcuts 42 InfoMaker"AllowProgrammaticMacros"=dword:00000001"AllowIntranetAccess"=dword:00000001On 64-bit
Operators used in InfoMaker expressions 618 InfoMakerOther columns in the ruleYou can refer to values in other columns for the current row by specif
CHAPTER 23 Operators and ExpressionsUsers Guide 619Arithmetic operators in InfoMaker expressionsWhen you write an expression, you can use the follo
Operators used in InfoMaker expressions 620 InfoMakerWhen you write an expression, you can use the following relational operators (more information
CHAPTER 23 Operators and ExpressionsUsers Guide 621For example, the following expression for the Background.Color property of the Salary column dis
Operators used in InfoMaker expressions 622 InfoMakerIN and NOT IN operatorsUse IN to check if a value is in a set of values. Use NOT IN to check if
CHAPTER 23 Operators and ExpressionsUsers Guide 623To compare strings when trailing blanks are significant, use an expression such as the following
Operators used in InfoMaker expressions 624 InfoMakerIf you use a logical operator with a boolean function that returns null, the term with the null
CHAPTER 23 Operators and ExpressionsUsers Guide 625Operator precedence in InfoMaker expressions To ensure predictable results, operators in InfoMak
Matching text patterns 626 InfoMakerMatching text patternsA text pattern is an expression that you can use to evaluate whether a string contains a p
CHAPTER 23 Operators and ExpressionsUsers Guide 627ABB*C Any string containing the pattern ABC or ABBC or ABBBC, and so on (1 B plus 0 or more Bs).
CHAPTER 1 Working with InfoMakerUsers Guide 43❖ To associate a keyboard shortcut with a menu item:1 Select Tools>Keyboard Shortcuts from the men
Matching text patterns 628 InfoMaker
Users Guide 629CHAPTER 24DataWindow Expression and InfoMaker FunctionsAbout this chapterThis chapter provides syntax, descriptions, and examples of th
Four examples 630 InfoMakerWithin an expression, a function can return other datatypes (such as boolean, date, or integer), but the final value of a
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 631What you want to doSuppose you are working with the Fin_code table in the En
Four examples 632 InfoMakerWhat you getHere is the design for the report.Here is the report showing eight descriptions, three of which are null and
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 633About crosstab functionsAlthough the crosstab functions (CrosstabAvg, Crosst
Four examples 634 InfoMakerHere is the last page of the report, with the total number of males and females in the company displayed.If you want more
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 635Here is what the design of the grouped report looks like.Here is the last pa
Four examples 636 InfoMakerExample 3: creating a row indicatorThis example demonstrates the use of several functions: Bitmap, Case, CurrentRow, GetR
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 637• An expression for the Background.Color property of the salary column:Case(
Using the file editor 44 InfoMaker❖ To remove a keyboard shortcut associated with a menu item:1 Select Tools>Keyboard Shortcuts from the menu bar
Four examples 638 InfoMakerExample 4: displaying all data when a column allows nullsWhen you create an arithmetic expression that has a null value,
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 639When you preview the report, notice that the first computed field displays n
Alphabetical list of DataWindow expression and InfoMaker functions 640 InfoMakerAlphabetical list of DataWindow expression and InfoMaker functionsTh
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 641AbsDescription Calculates the absolute value of a number. Syntax Abs ( n )Ret
Asc 642 InfoMakerAscDescription Converts the first character of a string to its Unicode code point. A Unicode code point is the numerical integer va
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 643Examples This expression for a computed field returns the string in code_id i
ATan 644 InfoMakerATanDescription Calculates the arc tangent of an angle.Syntax ATan ( n )Return value Double. Returns the arc tangent of n if it su
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 645Return value The numeric datatype of the column. Returns the average of the v
Avg 646 InfoMakerNot in validation rules or filter expressionsYou cannot use this or other aggregate functions in validation rules or filter express
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 647BitmapDescription Displays the specified bitmap.For computed fields onlyYou c
CHAPTER 1 Working with InfoMakerUsers Guide 45❖ To specify File Editor properties:1 Select Design>Options to display the property page.2 Choose
Case 648 InfoMakerCaseDescription Tests the values of a column or expression and returns values based on the results of the test.Syntax Case ( colum
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 649This expression for the Background.Color property of an employee Id column re
Char 650 InfoMakerTo pass this validation rule, the value in discount_amt must be less than or equal to the smallest whole number that is greater th
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 651CosDescription Calculates the cosine of an angle.Syntax Cos ( n )Return value
Count 652 InfoMakerUsage If you specify range, Count determines the number of rows in column in range. If you specify DISTINCT, Count returns the nu
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 653Not in validation rules or filter expressionsYou cannot use this or other agg
CrosstabAvg 654 InfoMakerSyntax CrosstabAvg ( n {, column, groupvalue } )Return value Double. Returns the average of the crosstab values returned by
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 655When you define the crosstab described above, the painter automatically creat
CrosstabAvg 656 InfoMakerWhat the function arguments meanWhen the crosstab definition has more than one column, you can specify column qualifiers fo
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 657Consider a crosstab that has two columns (region and city) and the values exp
Changing fonts 46 InfoMakerChanging fontsTable 1-9 summarizes the various ways you can change the fonts used in InfoMaker.Table 1-9: Changing fontsU
CrosstabCount 658 InfoMakerReturn valueDecimal. Returns the average of the crosstab values returned by expression n for all the column values or, op
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 659For more information about restricting the calculation to groups of values wh
CrosstabMax 660 InfoMakerCrosstabMaxDescription Calculates the maximum value returned by an expression in the values list of the crosstab. When the
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 661Examples These examples all use the crosstab-values expressions shown below:C
CrosstabMin 662 InfoMakerSyntax CrosstabMaxDec ( n {, column, groupvalue } )Return value Decimal. Returns the maximum value returned by expression n
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 663Return value Double. Returns the minimum value returned by expression n for a
CrosstabMinDec 664 InfoMakerThis expression for a computed field returns the minimum of all the average sales in the row:CrosstabMin(1)For an exampl
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 665Usage Use this function instead of CrosstabMin when you want to return a deci
CrosstabSum 666 InfoMakerFor more information about restricting the calculation to groups of values when the crosstab definition has more than one c
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 667CrosstabSumDecDescription Calculates the sum of the values returned by an exp
CHAPTER 1 Working with InfoMakerUsers Guide 47❖ To identify a query library as a source of queries:1 Click the Library List button in the PowerBar
CumulativePercent 668 InfoMakerCumulativePercentDescription Calculates the total value of the rows up to and including the current row in the specif
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 669Settings for Rows include the following: • For the Graph presentation style,
CumulativeSum 670 InfoMakerCumulativeSumDescription Calculates the total value of the rows up to and including the current row in the specified colu
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 671In calculating the sum, null values are ignored.Examples This expression retu
Date 672 InfoMakerAlternatively, this expression for the Visible property of an arrow picture control makes the arrow bitmap visible for the row wit
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 673An expression has a more limited set of datatypes than the functions that can
Day 674 InfoMakerUsing this expression for a computed field displays 11/11/01 11:11:00:DateTime(11/11/01, 11:11)See alsoDateTimeDayDescription Obtai
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 675Usage DayName returns a name in the language of the deployment files availabl
DaysAfter 676 InfoMakerSee alsoDateDayDayNameIsDateDaysAfterDescription Gets the number of days one date occurs after another.Syntax DaysAfter ( dat
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 677DecDescription Converts the value of a string to a decimal.Syntax Dec ( strin
ContentsUsers Guide viiSelecting a data source... 154Using Quick Select...
Using the Query Governor 48 InfoMaker❖ To identify a library as a source of form styles:1 Click the Library List button in the PowerBar.2 On the Sty
Describe 678 InfoMakerDescribeDescription Reports the values of properties of a report or form object and the controls within the object. Each colum
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 679FactDescription Gets the factorial of a number.Syntax Fact ( n )Return valueD
FillA 680 InfoMakerThis expression returns the string -+-+-+-:Fill("-+", 7)This expression returns 10 tildes (~):Fill("~", 10)Se
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 681FirstDescription Reports the value in the first row in the specified column.S
First 682 InfoMakerFor graphs and OLE objects, you do not select the range when you call the function. The range has already been determined by the
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 683GetRowDescription Reports the number of a row associated with a band in a rep
GetText 684 InfoMakerGetTextDescription Obtains the text that a user has entered in a column.Syntax GetText ( )Return valueString. Returns the text
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 685IfDescription Evaluates a condition and returns a value based on that conditi
Int 686 InfoMakerIntDescription Gets the largest whole number less than or equal to a number.Syntax Int ( n )Return value The datatype of n. Returns
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 687This expression for a computed field returns “Not a valid age” if age does no
CHAPTER 1 Working with InfoMakerUsers Guide 49Data retrieval optionsThe data retrieval settings shown in Table 1-11 specify rows retrieved and maxi
IsExpanded 688 InfoMakerIsExpandedDescription Tests whether a node in a TreeView report with the specified TreeView level and that includes the spec
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 689See also “Example 1: counting null values in a column” on page 630“Example 4:
IsRowNew 690 InfoMakerExamplesThis expression in a computed field in the detail area displays true or false to indicate whether each row has been mo
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 691Usage When you use IsSelected in bands other than the detail band, it reports
Large 692 InfoMakerLargeDescription Finds a large value at a specified ranking in a column (for example, third- largest, fifth-largest) and returns
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 693Return value The datatype of returnexp. Returns the ntop-largest value if it
Last 694 InfoMakerLastDescription Gets the value in the last row in the specified column.Syntax Last ( column { FOR range { DISTINCT { expres1 {, ex
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 695For graphs and OLE objects, you do not select the range when you call the fun
Left 696 InfoMakerReturn valueLong. Returns a long whose value is the starting position of the last occurrence of string2 in string1 within the char
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 697Examples This expression returns BABE:Left("BABE RUTH", 4)This expr
Using the Query Governor 50 InfoMakerUsing the Query GovernorWhen you select and retrieve data, the default Query Governor options limit you in the
LeftTrim 698 InfoMakerLeftTrimDescription Removes spaces from the beginning of a string.Syntax LeftTrim ( string )Return valueString. Returns a copy
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 699LenADescription Reports the length of a string in bytes.Syntax LenA ( string
LogTen 700 InfoMakerSee alsoExpLogTenLogTenDescription Gets the base 10 logarithm of a number.Syntax LogTen ( n )Return valueDouble. Returns the bas
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 701Return value Long. Returns the contents of string as a long if it succeeds an
Lower 702 InfoMakerLowerDescription Converts all the characters in a string to lowercase.Syntax Lower ( string )Return valueString. Returns string w
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 703The following tables explain the meaning and use of these metacharacters:The
Max 704 InfoMakerSample patternsThe following table shows various text patterns and sample text that matches each pattern:Examples This validation r
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 705Return value The datatype of the column. Returns the maximum value in the row
Median 706 InfoMaker• For Graph controls, Rows can be All, Page, or Group.• For OLE controls, Rows can be All, Current Row, Page, or Group. The avai
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 707Return value The numeric datatype of the column. Returns the median of the va
CHAPTER 1 Working with InfoMakerUsers Guide 51How your InfoMaker environment is managedYour InfoMaker configuration information is stored in both t
Median 708 InfoMakerSettings for Rows include the following:• For the Graph presentation style, Rows is always All.• For Graph controls, Rows can be
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 709Assuming a report displays the order number, amount, and line items for each
MidA 710 InfoMakerTo pass this validation rule, the fourth character in the column password must be 6:Mid(password, 4, 1) = "6"MidADescrip
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 711Return value The datatype of the column. Returns the minimum value in the row
Min 712 InfoMakerFor graphs and OLE objects, you do not select the range when you call the function. The range has already been determined by the Ro
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 713MinuteDescription Obtains the number of minutes in the minutes portion of a t
Mode 714 InfoMakerModeDescription Calculates the mode of the values of the column. The mode is the most frequently occurring value.Syntax Mode ( col
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 715For graphs and OLE objects, you do not select the range when you call the fun
Month 716 InfoMakerAssuming a report displays the order number, amount, and line items for each order, this computed field returns the mode of the o
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 717Return value Time. Returns the current time based on the system time of the c
How your InfoMaker environment is managed 52 InfoMakerFormat of INI filesThe InfoMaker initialization file uses the Windows INI file format. It has
Page 718 InfoMakerPageDescription Gets the number of the current page.Syntax Page ( )Return valueLong. Returns the number of the current page.Calcul
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 719This example obtains the absolute page number for the first row on the page i
PageCountAcross 720 InfoMakerUsagePageCount applies to Print Preview.Calculating the page countThe vertical size of the paper less the top and botto
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 721PercentDescription Gets the percentage that the current value represents of t
Percent 722 InfoMakerUsageUsually you use Percent in a column to display the percentage for each row. You can also use Percent in a header or traile
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 723This expression returns the value of each row in the column named cost as a p
Pos 724 InfoMakerPosDescription Finds one string within another string.Syntax Pos ( string1, string2 {, start } )Return value Long. Returns a long w
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 725PosADescription Finds one string within another string.Syntax PosA ( string1,
ProfileInt 726 InfoMakerReturn valueInteger. Returns default if filename is not found, section is not found in filename, key is not found in section
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 727ProfileStringDescription Obtains the string value of a setting in the specifi
CHAPTER 1 Working with InfoMakerUsers Guide 53Starting InfoMaker from the command lineYou can start InfoMaker from a command line (or the Windows R
Rand 728 InfoMakerRandDescription Obtains a random whole number between 1 and a specified upper limit.Syntax Rand ( n )Return value A numeric dataty
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 729RelativeDateDescription Obtains the date that occurs a specified number of da
Replace 730 InfoMakerReplaceDescription Replaces a portion of one string with another.Syntax Replace ( string1, start, n, string2 )Return valueStrin
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 731ReplaceADescription Replaces a portion of one string with another.Syntax Repl
RGB 732 InfoMakerUsageThe formula for combining the colors is:Red + (256 * Green) + (65536 * Blue)Use RGB to obtain the long value required to set t
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 733RightDescription Obtains a specified number of characters from the end of a s
RightTrim 734 InfoMakerUsageRightA replaces the functionality that Right had in DBCS environments in InfoMaker 9. In SBCS environments, Right and Ri
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 735Examples This expression returns 9.62:Round(9.624, 2)This expression returns
Second 736 InfoMakerUsageWhen you call RowHeight in a band other than the detail band, it reports on a row in the detail band. See GetRow for a tabl
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 737SecondsAfterDescription Gets the number of seconds one time occurs after anot
Starting InfoMaker from the command line 54 InfoMakerTable 1-13: InfoMaker command-line parametersExamplesThe following examples use im11.5 to repre
Sin 738 InfoMakerSinDescription Calculates the sine of an angle.Syntax Sin ( n )Return valueDouble. Returns the sine of n if it succeeds and –1 if a
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 739Return value The datatype of returnexp. Returns the nbottom-smallest value if
Space 740 InfoMakerSettings for Rows include the following:• For the Graph or OLE presentation style, Rows is always All.• For Graph controls, Rows
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 741Examples This expression for a computed field returns 10 spaces in the comput
StDev 742 InfoMakerStDevDescription Calculates an estimate of the standard deviation for the specified column. Standard deviation is a measurement o
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 743For graphs and OLE objects, you do not select the range when you call the fun
StDevP 744 InfoMakerThis expression for a computed field in a crosstab returns the estimate for standard deviation of the values in the qty_ordered
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 745Return value Double. Returns the standard deviation for column.Usage If you s
String 746 InfoMakerThis expression returns the standard deviation of the values in group 1 in the column named salary:StDevP(salary for group 1)Thi
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 747Syntax String ( data {, format } )Return valueString. Returns data in the spe
Users Guide 55CHAPTER 2Working with LibrariesAbout this chapterInfoMaker stores all the objects you create in libraries. This chapter describes how to
StripRTF 748 InfoMakerString(2005-01-31 06:08:00, 'mmm dd, yyyy, h "hrs and" m "min"')This expression:String(nbr, &quo
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 749Examples This expression is used in a compute field expression to remove the
Sum 750 InfoMakerReturn value The appropriate numeric datatype. Returns the sum of the data values in column.Usage If you specify range, Sum returns
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 751Not in validation rules or filter expressionsYou cannot use this or other agg
Time 752 InfoMakerPiSinTimeDescription Converts a string to a time datatype.Syntax Time ( string )Return value Time. Returns the time in string as a
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 753TodayDescription Obtains the system date and time.Syntax Today ( )Return valu
Truncate 754 InfoMakerReturn value The datatype of x. If n is positive, returns x truncated to the specified number of decimal places. If n is negat
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 755UpperDescription Converts all characters in a string to uppercase letters.Syn
Var 756 InfoMakerReturn value Double or decimal if the arguments are decimal. Returns an estimate for the variance for column. If you specify group,
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 757Settings for Rows include the following:• For the Graph presentation style, R
About InfoMaker libraries and special files 56 InfoMaker• Bundle reports, forms, and pipelines in an application that you and others can useFor info
VarP 758 InfoMakerAssuming a report displays the order number, amount, and line items for each order, this computed field returns the estimate for t
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 759Return value Double or decimal if the arguments are decimal. Returns the vari
WordCap 760 InfoMakerThis expression returns the variance of the values in group 1 in the column named salary:VarP(salary for group 1)This expressio
CHAPTER 24 DataWindow Expression and InfoMaker FunctionsUsers Guide 761This expression concatenates the characters in the emp_fname and emp_lname co
Year 762 InfoMaker
PART 7 AppendixesThis part contains descriptions of the rules for identifiers in InfoMaker and the extended attribute system tables.
Users Guide 765APPENDIX AIdentifiersAbout this chapterYou use identifiers to name objects. This chapter describes valid identifiers. ContentsRules Ide
Reserved words 766 InfoMakerExamplesHere are some valid identifiers:first_quarter_summaryEMPLOYEE_LABELSEmployeeSalarySummaryEmployee_by_#Here are s
Users Guide 767APPENDIX BThe Extended Attribute System TablesAbout this appendixThis appendix describes each column in the extended attribute system t
CHAPTER 2 Working with LibrariesUsers Guide 57Creating new librariesWhen you create a new library, the new library becomes the current library. Unt
The extended attribute system tables 768 InfoMakerCautionYou should not change the values in the extended attribute system tables. InfoMaker maintai
APPENDIX B The Extended Attribute System TablesUsers Guide 769About font pitch and familyFont pitch and family is a number obtained by adding toget
The extended attribute system tables 770 InfoMakerTable B-4: The PBCatFmt table Table B-5: The PBCatVld table Table B-6: The PBCatEdt table Column C
APPENDIX B The Extended Attribute System TablesUsers Guide 771Edit style types for the PBCatEdt tableTable B-7 shows the edit style types available
Edit style types for the PBCatEdt table 772 InfoMakerRadioButton edit style (code 86)Table B-10 shows a sample row in the PBCatEdt table for a Radio
APPENDIX B The Extended Attribute System TablesUsers Guide 773DropDownListBox edit style (code 87)Table B-12 shows a sample row in the PBCatEdt tab
Edit style types for the PBCatEdt table 774 InfoMakerDropDownDataWindow edit style (code 88)Table B-14 shows a sample row in the PBCatEdt table for
APPENDIX B The Extended Attribute System TablesUsers Guide 775Edit edit style (code 89)Table B-16 shows a sample row in the PBCatEdt table for an E
Edit style types for the PBCatEdt table 776 InfoMakerTable B-16: Sample row in PBCatEdt for an Edit edit style Table B-17: Values used in Edit edit
APPENDIX B The Extended Attribute System TablesUsers Guide 777Edit Mask edit style (code 90)Table B-18 shows a sample row in the PBCatEdt table for
ContentsviiiInfoMakerSaving data in an external file... 208Saving the data as PDF ...
About the Library painter 58 InfoMakerAbout the Library painter❖ To open the Library painter:• Click the Library button in the PowerBar.Views in the
Edit style types for the PBCatEdt table 778 InfoMakerRange Character representation (in decimal) of spin control range. The min value and max value
Users Guide 779Symbols* (multiplication) 619+ (addition) 619+ operator 240, 564/ (division) 619= (relational) 620@used in crosstabs 439used in v
Index780InfoMakerapplicationsabout 575creating 576defining toolbars 581distributing 576executing pipelines 588identifying in Help>About 585initi
IndexUsers Guide 781BMP filesadding to forms 565adding to reports 238in rich text 480books, online 40boolean expressionsin filters 298in validati
Index782InfoMakercolumnsadding to data source for forms 560adding to forms 561adding to reports 235appending to table 90applying display formats t
IndexUsers Guide 783conditional expressionsexample 633, 634, 638conditional expressions, IF function 685conditional modificationexample, gray bar 3
Index784InfoMakerCUR filesselecting mouse pointers 220CUR files, selecting mouse pointers 555currency display format 263currency, and rows 683curr
IndexUsers Guide 785specifying fonts in tables 87using in graphs 413database administrationdatabase access 119executing SQL 115painting SQL 115se
Index786InfoMakerdefining primary keys 100executing SQL statements 118exporting table syntax 95exporting view syntax 108generating SQL statement
IndexUsers Guide 787defining code tables with 285Edit Mask edit styledefining 278defining code tables with 285spin controls 280edit style propertie
CHAPTER 2 Working with LibrariesUsers Guide 59About sorting the Name columnWhen you click the Name column header repeatedly to sort, the sort happe
Index788InfoMakerFill function 679FillA function 680filtersfunctions in expressions for 629in Data Manipulation view 112removing 299First function
IndexUsers Guide 789running 523running in executable 586saving 522saving data in 526selecting rows when running 558setting borders 545setting colo
Index790InfoMakergrid lines, graph 429Grid stylebasic properties 219detail band in 195displaying grid lines 219of reports 146reordering columns
IndexUsers Guide 791Month 716Now 716Number 717Page 718PageAcross 719PageCount 719PageCountAcross 720Percent 721Pi 723Pos 724, 725ProfileInt 725Profile
Index792InfoMakerJoin dialog box 107joinsnumber of tables in 48, 50joins, in Select painter 170JPEG filesadding to forms 565adding to reports 238
IndexUsers Guide 793sorting 59using drag and drop 59views 58what you can do in 55workspace 58LIKE operator 620in expressions 620LIKE operator, in
Index794InfoMakerNName column, sorting 59name tags 148namesof columns in reports 195of controls in reports 226of executable files 577of forms 52
IndexUsers Guide 795detail band in 195of reports 148OObject Details view 78Object Layout view 78objectsaccessing recently opened 18creating new
Index796InfoMakerusing views 19working in 18painting SQL statements 115panesadding 23docking 22floating 22in views 20moving 21removing 23resizing
IndexUsers Guide 797placeholders, in validation rules 291plus sign in text patterns 703point of view, in 3D graphs 422pointer property 339pointers
Working with libraries 60 InfoMakerFor example, you can drag a library from the Tree view and drop it in the List view to quickly display the object
Index798InfoMakerbrush.hatch 329color 330font.escapement 331font.height 332, 336font.italic 333font.strikethrough 334font.underline 335font.weight 335
IndexUsers Guide 799MicroHelp 199moving controls 248opening 63resizing bands 199resizing controls 249retrieving data 200saving data 208selecting
Index800InfoMakertext, adding 236U.S. number format 630units of measure 216years, how interpreted 268reports, OLEOLE object 487, 488presentation
IndexUsers Guide 801selecting 690selecting when running forms 558sorting 110, 112, 299sorting in SQL Select 177suppressing repeating values 301usi
Index802InfoMakerslidingin forms 551in reports 251Slide dropdown toolbar, in Report painter 196used in nested reports 361Small function 738snakin
IndexUsers Guide 803Lower 702Match 702Mid 709MidA 710Pos 724PosA 725Replace 730ReplaceA 731Right 733RightA 733RightTrim 734Space 740Trim 753Upper 755W
Index804InfoMakerrows, number retrieved 48saving data in external files 114selecting for SQL Select 156, 165specifying extended attributes 89speci
IndexUsers Guide 805icons in the Design view 464properties 465tree node icons 465Trim function 753Truncate function 753truth table for boolean exp
Index806InfoMakerWordCap function 760workspacein Data Pipeline painter 125, 127in Database painter 78in Library painter 58wrap height, default in
CHAPTER 2 Working with LibrariesUsers Guide 61Filtering the display of objectsYou can change which objects display in expanded libraries. Settings
Working with libraries 62 InfoMakerFiltering the display of libraries and foldersIn either the Tree view or the List view, you can control what disp
CHAPTER 2 Working with LibrariesUsers Guide 63Opening and previewing objectsYou can open and preview objects in the current library.❖ To open an ob
Working with libraries 64 InfoMaker2 Click the Copy button or the Move button on the Painterbar, or select Entry>Copy or Entry>Move from the m
CHAPTER 2 Working with LibrariesUsers Guide 652 If you want the root to be a directory or library, type the path or browse to the path.If you set t
Working with libraries 66 InfoMakerInfoMaker displays the Properties dialog box. The information that displays is for the first object you selected.
CHAPTER 2 Working with LibrariesUsers Guide 67Optimizing librariesYou might need to optimize your libraries occasionally. Optimizing removes gaps i
ContentsUsers Guide ixResizing controls in a report... 249Aligning controls in a report...
Regenerating library entries 68 InfoMaker• When you make extensive changes to objects, you can rebuild entire libraries so that objects are regenera
CHAPTER 2 Working with LibrariesUsers Guide 69Migrating librariesWhen you upgrade to a new version of InfoMaker, your existing libraries need to be
Creating a library directory report 70 InfoMaker
PART 2 Working with DatabasesThis part describes how to use InfoMaker to manage your database and how to use the Data Pipeline painter to copy data f
Users Guide 73CHAPTER 3Managing the DatabaseAbout this chapterThis chapter describes how to manage a database from within InfoMaker.ContentsBefore you
Working with database components 74 InfoMaker• Indexes• Database views• Extended attributes• Additional database componentsTables and columnsA datab
CHAPTER 3 Managing the DatabaseUsers Guide 75In the following illustration there is a join on the dept_id column, which is a primary key for the de
Working with database components 76 InfoMakerExtended attributesExtended attributes enable you to store information about a table’s columns in speci
CHAPTER 3 Managing the DatabaseUsers Guide 77Events can be used in a SQL Anywhere database to automate database administration tasks, such as sendi
Commentaires sur ces manuels