Thursday, August 15, 2002
From The Edge: Creating CrossTab Reports Section: Report Designer Chapter: Running R:BASE Your Way! Platform: R:BASE 7.0 for Windows Build: 1.855xRT03 and Higher Creating CrossTab reports are now a snap with the new R:BASE 7.0 for Windows Report Designer. Simply click on CrossTab icon in the tool bar and place the CrossTab object in any section of an existing report. Unlimited row, column and value dimensions are supported. When more than one row or column dimension is defined, subtotals are displayed for the outermost levels. You can use a CrossTab component when you want to display calculated values in a multi-dimensional grid format. You can define three types of dimensions: Columns, Rows and Values. You can select fields from the list of available columns as dimension values. This is usually done by right- clicking over the CrossTab component in the report designer and selecting the Configure... menu option. A diagram of the CrossTab definition is then displayed. Here you can specify column dimensions by dragging fields from the field list into the 'New Column' cell. Row and Value dimensions can be created by dragging fields into the 'New Row' and 'New Value' cells. Once your dimensions are defined, you can configure the 'look and feel' of your CrossTab by selecting the dimension in the diagram and then using the formatting controls in the dialog. When the CrossTab is generated, the row and column dimensions that you define become the captions which appear on the outside edges of the CrossTab grid. The unique field values for each dimension become the caption values. The value dimensions which correlate to the given row and column values are displayed within the grid. If there are no corresponding values for a given column/row pair, a blank is displayed. The "Draw" property of CrossTab (Defaults to True) determines whether the CrossTab will actually be rendered in the report. Setting Draw to False will keep the CrossTab from rendering. Setting "Visible" to False will keep the CrossTab from both generating and rendering. Therefore, you will need to make sure that the Visible property is set to True if you intend to use the techniques described above. The "Pagination" property determines the order in which CrossTabs which do fit on a single page will print. There are two possible values: Across then Down: Print all of the pages across the top of the matrix, then print the next 'row' of pages, etc., etc until the matrix is completely printed. Down then Across: Print all of the pages down the side of the matrix, then print the next 'column' of pages, etc, etc until the matrix is completely printed. The "ParentWidth" property determines whether the CrossTab component spans the width the section. You can set this property to false and resize the CrossTab in order to create 'side-by-side' CrossTabs. Position (Left): The Left property determines the horizontal coordinate of the left edge of a CrossTab component relative to the left edge of the parent band's starting print position. Position (Top): The Top property determines the vertical coordinate of the top left corner of a CrossTab component. The value of top is relative to the value of a report component's parent band. Position (Width): The Width property expresses the horizontal size of a component in report units. Position (Height): The Height property expresses the vertical size of the component in report units. Position (BottomOffset): Use the BottomOffset property to define the vertical space that should appear after the CrossTab has printed. The BottomOffset is expressed in report units. Notes: The BottomOffset acts as a margin between the stretching component and the components that are shifting or stretching in relation to it. Position (OverFlow Offset): Use the OverFlowOffset property to define the vertical space that should be above the component when it is overflowing onto an additional page. The OverFlowOffset is expressed in report units. Notes: The OverFlowOffset acts as a margin between the stretching component and the top of the page. Position (StopPosition): Use the StopPosition property to define the vertical position at which the stretchable will stop printing. The StopPosition is expressed in report units. Notes: Together with the Top and OverFlowOffset properties, the StopPosition can be used to restrict a stretchable component to a certain position on the page. This is often useful when you are printing on pre-printed forms and need to print information within a certain rectangular area on the page. ShiftRelativeTo: When multiple stretching objects occupy the same section on the report, use this property to specify how each object should be positioned relative to other stretching objects. ShiftRelativeTo can only be used for objects that are dynamically sized. If you have a static object, such as a Label, which needs to shift relative to a given stretching object, then place the object in a region and set the Region's ShiftRelativeTo to the stretching object. Notes: When stretching objects are placed within a region, the ShiftRelativeTo property is disabled. Stretch: The Stretch property determines whether the Height of the CrossTab automatically stretches to allow the entire contents of the CrossTab to be printed. Defaults to True. To set the Stretch property from the Report Designer, position your mouse cursor over the component and click the right mouse button. The Stretch option should be near the bottom of the speed menu. If it is checked, the CrossTab will stretch, overflowing to additional pages if necessary. Selecting the Stretch option from this menu will toggle its value. Style: Style property determines the 'look and feel' of the CrossTab. There are two styles currently provided with the CrossTab object, i.e., 'Standard' and 'Repeated Captions'. The Repeated Captions style forces the CrossTab to reprint the appropriate row and column captions when a CrossTab does not fit on a single page. Visible: The Visible property determines whether the CrossTab object will be printed. The default is set to True. Notes: If Visible is set to False, then the CrossTab grid will not be generated. If you want to hide the CrossTab rendering, but still generate the CrossTab grid, use the Draw property. PDF version of this technical document is also available at: From The Edge: http://www.razzak.com/fte (Reports and Labels) (Powered by R:Tango) Enjoy and make sure to have fun! Very Best Regards, Razzak. ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
