True DBREPORT 6.0 instructions
DBREPORT is a control that allows users to quickly and easily use powerful reporting systems in applications. It has strong features, methods, and events that allow users to provide a perfect statement in the case of a small amount of work.
DBREPORT allows users to save data to ADO or OLE DB data sources, or acquire data from the data list, or obtain data based on events. Users can easily access or print this data.
Its features include:
Data Access (data interface): This control supports multiple data connection methods. He can connect directly to the database and generate his own dataset, or you can bind to the existing ADO data set or OLE DB data source. You can also enter data to the control from a data list or by conforming to the conditions.
Data Manipulation (Data) This control allows users to classify and control data without writing any code. You can easily define a pair one or more relationship, define filtering conditions to limit data, define the calculated columns (such as the columns of statistical counts). This control can also support the relationship between the primary and the chart (by parallel or serial conditions).
Customize Data APPEARANCE (appearance form of custom data): The user can fully control the properties of the performance of the data, such as the font, color, page settings, brows and footholds, etc. The control has an embedded impression mechanism to convert the code value as a string to implement the user's control requirements.
Objects and collections: This control defines some basic objects. Program designers can completely control these objects in operation: targets (such as clips and details) and objects constitute the definition of reports, which can be defined by using the property page when designing, or can be defined in operation. Many people define when designing because it is interactive visual, while designing is due to the final control of program designers, allowing users to generate reports based on the information of the final input, Take the ultimate needs of users close to users
Hierarchy of Styles: The performance style is used to control the visual properties of the report columns, with a tree grade to organize. The style of the performance can be inherited from the father and can overwrite the original properties. This way can save time because users need to create a small part of the new features when the user needs to create a new style. Such a practice can also have a unified look that the reports made by the user have. This allows the user to make a flexible system that is easily modified and tracked whether it is partial or global modifications.
Maximize Table Usage (Using the window): This control provides a wide range of support to the window, including the brow and foot, the width between columns and columns, and the like.
Control over Report Generation: The user can implement the generation or print or print preview of the report only through a few lines of code. Or users can control the generation and performance of the entire report by defining the properties of this control.
Report Building Wizard: This control has an embedded report generated wizard, which can be easily defined by this wizard to define the generated report, and define the report included by selecting the performance style of the existing basis. Columns, defined the combination of reports, etc. The Report Generation Wizard is a very convenient tool for developers, but this wizard can only be used directly by the final user, only allowing end users to customize the use of the reports they need.
Other Features: This control also includes a visual editor; standard static function for expression; advanced easy-to-operate page controller; easy customization and support for different configurations, etc. :( Right click on the control, select Properties)
The property page includes:
DataSource: You can choose from the drop-down list of DATAMODE (data connection mode):
TDBMODEDASOSOSOURCE (as a data source as a database),
TDBModeMemoryArray (listed as data stores)
TDBModeUseRevent (with user-defined events as data sources)
You can choose from Source of Connection (Data Connection Source Target):
Use data link file, use the Browse key to select the required link file
Use ODBC Data Source Name (using an ODBC Data Source), lists existing ODBC data sources in the drop-down list, with the New key to create new data sources
Use connection string, use the BULID key to select the data source to connect, in the pop-up data link properties box, 'Provider' page is used to allow users to choose the afternoon connection data, 'connection' The page is to let the user select the name of the database you want to use and enter the username and password when logging in to the database. The 'Advanced' page is used to set the network, and all of the settings in 'all' tops
Other Attributes (settings for other properties)
Authentication, by setting the username and password for users to identify
RecordSource, you can enter the corresponding SQL statement in Command Text to select the table and fields and set sorting methods, filter conditions, etc.
General: (Main Attributes) is an outline of the entire property, also an overview of the editing interface of the report, such as whether you display the grid, the size of the grid, etc.
Parameter: (parameter), you can set and modify the parameters of the report
Fields: (Report Column) Sets the columns in the table defined in DataSource, can also increase and modify the column, define the calculation column, such as adding a computational column, click the right button in the left space, in the pop-up Select New in the menu. This new column will appear in the right. Enter the name in Name. Enter the name shown in the report in DisplayName. Define the type of column in Type, define the maximum length in Maxlength. Calculate the calculation method of the computational column in CalculateExpression (Point ... ", pop up an editor, write calculation in Expression)
Filters: (Filter Condition) can increase the deletion of modifying filter conditions, such as adding a filter condition, click the right button in the left blank, select New in the pop-up menu, and on the right FilteExpression, ConditionExpression (Condition Expression) Sample definition of the corresponding conditions
Sections: (Pieces) You can define the format and performance of the report, but you must first definition before making this definition:
Right-click on the DBREPORTS control you want to define, select Report Wizard in the pop-up menu, a Report Wizard window, the first page is: style (style), you can choose the desired style of the report in the list on the left. When the mouse click to a certain style, the selection of this style will appear, and the corresponding example will appear in the box. After selecting the style, click Next and then the second page: Fields (report " Column), listed in the left box is the column selected by this control, the right side is the manifestation of the report column, select the column in the right box with the mouse, can be deleted, click on a list in the left box, click Insert Group will join Group in the selected column, click Add to Group Add this column to the group, click Next after confirming the format of the column: General Option (settings in the main page), Enter the text of the header in Report Header. You can choose Keep Detail Togther, Number Group Headers (displayed in the header), Number Detail Sections (Data Value of Display) Click the Finish button.
Go back to the Sections page of the property box, list the segments defined in the Report Winzard in the box, which can be added and modified in this page to add elements in the pieces and pieces.
To modify the clip: Use the mouse to modify the segment, in the right, the corresponding properties are displayed, the property is divided into the general page and the PLUS page, and the general page of the General page is the setting of the primary properties of this piece: Name Define the name of the disc, can be made in the Comment. You can select the type of segment in Type. Define this piece of expression, define the style in Style; The relationship with the next piece) The drop-down list allows the operator to choose: 0.do Not Care (not paying attention), 1.IF Possible (if possible) 2.at all costs (in any case) 3 .EXPRESSION (judgment according to the expression); the Plus property page is mainly used to set some additional properties: hight set the height of the sniffer, spacingfore (set the front space), spacingafter (set the latted space), Select to be new page, use conditions, call before printing, enter criteria in KeepwithPRevexp and KeepwithnexTexp (only when KeepwithPREV in the General page is 3.Expression).
To add a piece, click the right button on the left side, select New Sections in the pop-up menu, generate a new piece, and the properties of this new piece appear in the right box, users The properties of this segment can be individually set, such as the modified segment.
To modify the elements in the segment: Click on the elements of the desired modification of the left box, the properties of this element are divided into the genral page, the Plus page, Style page, Graphics page, Borders page. The General page defines the main attributes of the element: the name of the representation in Name, write the corresponding instructions in the Comment, the expression of the element is defined in the expression, and the performance style is defined in Style (point ... you can pop up the Expression Editor editor The device can be defined directly), define the width in Width, define a height in Height, define a mixed method in MERGE (mode can be selected in the drop-down list); the PLUS page defines the specific performance of this property: Placement Layout Type (0.Tile Left header on the left, 1.Center horizontally horizontally in the center, 2.Tile Right Title in the right 3.Free Free Definition), define the distance between elements in the cellspan, defined in mapping Way, CallexPerssis, CallBeforePrint (call before printing); STYLE page is mainly used to define related properties such as font size color in this element; the graphics page is mainly used to define the properties of the image in this element. The Borders page is the properties of the way to define the boundaries of the element. To increase the element, click the right button on the corresponding segment position in the left box. Select New Cell in the pop-up menu, then generate a new piece of segment, and the new element appears in the box. Attribute, the user can personalize the properties of this element, such as modifying the element.
Styles: Each piece can have its own style, and these performance style can be defined and modified in this page.
To modify the style, use the mouse to select the name of the style you want to modify, then this style will appear in the right, you can modify the corresponding properties of the General page, Graphics page, BORDERS page, respectively, After modifying these properties, the style of the relevant performance-style element defined in Sections also changes corresponding changes.
To increase the performance style, click Right click in the blank position in the left box. Select New in the pop-up menu, there is a new performance style, and the new style appears in the right, in the General page, Graphics page, Borders page After the attribute has been personalized, the new performance style appears. At this time, you can return to the element page to be defined in the Sections page. The new performance style is selected: Select a piece or element in the section page, select the RECREATE PRETENT that pops up the menu, and then stretched the menu Select Styles, then you can see all existing performance style, select the performance style that users need to use.
Mappings: You can add an image file that deletes the modified report.
To increase image file: Click Right click in the left box, select New Maping in the pop-up menu, the new image file will appear, and the name of the new image file can be defined in the properties box appearing on the right.
To modify the name of the image file, use the mouse to click on the image file you want to modify in the left box and modify it in the Name field of the properties box appearing on the right.
To modify the properties of the column values under an image file, click on the column value with the mouse and modify the attribute in the attribute box on the right: The name of the column value is defined in the key; enter the column value in String String, define the graphics of the value of the column in Picture; specify a graphic file in the PICFile; define the name of the list of links in LinkedKey. (This is no longer a link file as defined as a graphic value). After modifying these properties, the properties of the elements of the related image files defined in Sections also change the corresponding change, if you want to add a column value, click on the image file you want to add column values, click Right click. Select New VALUES ITEM in the pop-up menu and perform personalized settings for properties in the Properties box on the right, such as the modified column value. At this time, you can return to the section of the sections page to contact the new image file: Select a piece or element in the sections page, click Right click, select the recreate presente of the pop-up menu, and then in the menu of the stretched Select Mapping, then you can see all existing image files, select the image file that the user needs to use can be used.
LINE: Define and modify the properties of the lines in the table
To modify the attribute of the line, use the mouse to modify the name of the line in the left box, perform the corresponding modification in the attribute in the right box, define the name in the Name, define the weight of the line in Thickness, in Color The color of the line is defined (click the Color box, pop up a color box, the user can select the color required, can also customize the color), and the preview map of the line will appear in the middle box of the right. After modifying the properties of these lines, the performance attributes of the lines defined in the section of the relevant lines are also correspondingly varied in the sections page.
To increase the line, right click in the blank position in the left box, select New in the pop-up menu, then a new line record, and the corresponding properties appear in the right box, such as modifying the line . At this time, you can return to the Element of the Sections page to contact the new line style: Select a piece or element in the section page, select the RECREATE PRETENT that pops up the menu, and then stretched the menu Select Lines, you can see all existing line records, select the line records you need to use by the user.
Profiles (outline of the report): You can define the contour of the report.
Report Editor Editor (right click on the control, select Edit)
The editor of the report appears, the user can define the representation of the report. When you use the mouse to drag the clip, press and hold the left mouse button to move, then the corresponding change occurs, there is a row of menu buttons at the top of the editor, according to these buttons, you can personalize the report directly:
1. Show Item Properties: Displays the properties of the current piece
2. Show item style: Displays the performance style of the current piece
3. ATTACH CURRENT ITEM'S STYLE TO Other ITEMS: Copy the style of the current piece to another column
4. INSERT A PICTURE (A Cell with a private style): Select the picture of the current piece
5. Insert New Secion: Insert a new piece in the current location
6. Insert New Cell: Insert a new element in the current location
7. Delete SELECTED ITEM (S): Delete selected pieces or elements
8. Undo: Undo the procedure of the previous step 9. Redo: Restore the previous operation
10. Toggle The Alignment Grid: Display Grid
11. Toggle Snap To Grid ON Move / Resize: Aligned to the grid in mobile and changing
12. Toggle Display of Cell Expression / Cell Names: Display Element Expression and Name
13. Align LEFT: Align the selected object
14. Align Top: Align the selected object top
15. Align Right: Align the selected object right
16. Align Bottom: Align the selected object
17. Make Same Width: Keep the selected object
18. Make Same High: Keep the selected object as high
19. make Same Size: Keep the selected object in the same size
Check the syntax error (right-click the control, select Check)
This feature is used to check if there is a syntax error in the properties of the report defined by the user. If there is no error, the prompt: No ErrorS Have Been Found. If there is an error discovery, a table box of an ErrorS will pop up, in the table box Enumeral mistakes
Preview feature (right-click this control, select Preview)
This feature is used to preview the model of the user-defined report, and the preview model can be appropriately modified, so that the report truly in line with the user's expectations.
Restore column values (right-click the control, select Retrieve Fields)
This feature is used to delete the properties of all defined columns, etc., and recover from the data source
Import from an XML file (right-click the control, select Load from XML)
This feature is used to select the XML file import to define the report control, after selecting, an open table box will pop up, so that the user selects the XML file you want to use.
Save the control as an XML file (right-click the control, select Save as XML)
This feature is used to save the definition of the report control as an XML file, select, and save a saved table box, so that the user selects the location and name of the XML file you want to save.
