User manual BUSINESS OBJECTS CRYSTAL REPORTS EXPLORER XI

[. . . ] Crystal Reports Explorer XI User's Guide Crystal Reports Explorer XI Patents Business Objects owns the following U. S. patents, which may cover products that are offered and sold by Business Objects: 5, 555, 403, 6, 247, 008 B1, 6, 578, 027 B2, 6, 490, 593 and 6, 289, 352. Business Objects, the Business Objects logo, Crystal Reports, and Crystal Enterprise are trademarks or registered trademarks of Business Objects SA or its affiliated companies in the United States and other countries. All other names mentioned herein may be trademarks of their respective owners. [. . . ] To move an object Drag any object to reposition it within its section of the report. To resize an object On the Design tab, select the field or text object that you want to resize. To resize a section On the Design tab, move the pointer over the boundary of the section you want to resize. When the pointer becomes a resizing cursor, drag the boundary to make the section bigger or smaller. Adding and editing text objects 1. To add a text object On the Design tab, right-click any white space in the section where you want to add a text object. To edit a text object Right-click the text object whose text you want to edit. To remove a text object Right-click the text object you want to remove. On the shortcut menu, click Remove Field. Crystal Reports Explorer User's Guide 61 5 Formatting Reports Formatting objects and sections Formatting field and text objects 1. On the Design or Report tab, right-click the object you want to format. Use the options available on the Common, Border, Font, Number and Date tabs to format the object as required: · · Use the Common tab to set properties like suppress, horizontal alignment, and keep object together, for a desired field. Use the Border tab to format the borders, background fill, and drop shadows for selected fields on your report. Using the options on the Border tab, you can create a variety of effects that can enhance the look of your report and highlight important data. Use the Font tab to change the fonts, the font size, and the font style for text and data fields on your reports. Use the Number tab to format numbers in your reports, for example setting decimal places and currency symbols. Use the Date tab to format the appearance of the date and time in your reports. See "Date tab (Format Editor dialog box)" on page 68. · · · 4. Click Apply; then click OK. Note: You can also format fields from the Report tab. Adding special fields to the report Special fields are predefined fields that can be added to your report on the Design tab. For more information on setting special fields in Crystal Reports, please refer to your Crystal Reports documentation. To insert a special field into the report On the Design tab, right-click any white space in the section where you want to add a special field. From the shortcut menu, click the special field that you want to insert. The following list describes the special fields that are available to you: 62 Crystal Reports Explorer User's Guide Formatting Reports Formatting objects and sections 5 Data Date Use the Data Date Field to include a field that contains the date the data was last retrieved (refreshed). This field can be placed in any section of your report, depending on how often you want it to print. Data Time Use the Data Time Field to include a field that contains the time the data was last retrieved (refreshed). This field can be placed in any section of your report, depending on how often you want it to print. File Author Use the File Author Field command to include a field that displays the name of the author of the report. File Path and Name Use the File Path and NameField command to insert a field that displays the file path and file name for the report. Group Number Use the Group Number Field to number each group in your report. You can place this field in either the Group Header or Group Footer section of your report. Group Selection Formula Use the Group Selection Formula Field to insert a group selection formula field into your report. Modification Date Use the Modification Date Field to include a field that contains the date the report was last modified. [. . . ] For example: //option loop example option loop 256; //make name upper case Local StringVar outString; Local StringVar inString := {Customer. Customer Name}; Local NumberVar i; For i:=1 to Length(inString) do outString := outString + upperCase(inString[i]); outString If Customer. Customer Name is greater than 255, an error message will be shown: "A loop was evaluated more than the maximum number of times allowed. " Crystal Reports Explorer User's Guide 117 7 Crystal Syntax Reference Limitations Limitations For reference purposes, here are the sizing limitations of the formula language: · · · · The maximum length of a String constant, a String value held by a String variable, a String value returned by a function or a String element of a String array is 65, 534 characters. (This applies to functions that can have an indefinite number of arguments such as Choose). The maximum number of loop condition evaluations per evaluation of a formula is 100, 000. Note that you can use the Option Loop (Crystal Syntax) statement to change this limit. [. . . ]