[RBASE-L] - From the Edge: Creating a Vertical Style Report Using ReportWizard

[A. Razzak Memon]

Tuesday, February 15, 2005
From the Edge:  Creating a Vertical Style Report Using Report Wizard
Section:        Report Designer
Chapter:        Running R:BASE Your Way!
Platform:       R:BASE 7.x and V-8 "Turbo" for Windows
Build:          7.1.79.30214 and higher
R:BASE 7.x and V-8 "Turbo" for Windows Report Designer contains a
Report Wizard that allows you to quickly create an report layout.
This document will show you how to design a vertical style report
using built-in Report Wizard.
Steps:
01. Start RBG7, connect to ConComp sample database
02. Database Explorer | Reports | New Report
                                                        
03. Type the new Report Name as MyFirstReport
    Select Customer from the drop-down list of available
    Table/View Name
    Type My First Report for the Description
    Check the option for Use Report Wizard
    Click on [OK] button (Figure 1)
04. First page of the Report Wizard will appear (Figure 2)
05. Click on the Company field in the Available Fields list box
    and click the right arrow '>' to move the field to the Selected
    Fields list box.
    Note: You can also move a field from Available Fields list box
    to Selected Fields list box by double-clicking it.
06. Repeat Step 05 to select the following fields: (Figure 3)
    CustID
    CustCity
    CustState
    CustPhone
07. Click on the Next button to access the next page of the Wizard.
    (Figure 4)
        
    This page of the Report Wizard is used to define Breaks. No break
    is required for this example; therefore, click on the Next button
    again.
08. Click on the Vertical radio button located in the Layout group box.
    Keep the Orientation as Portrait and Adjust field widths so all
    fields fit on page. (Figure 5)
09. Click on Next button.  Notice the Report Style options. (Figure 6)
10. Click on each of the style options in the list box to preview each
    of the available styles.
11. Select the Corporate style and click the Next button.
12. Click on the Finish button. (Figure 7)
    The report layout will be generated and you'll have the option to
    click on the "Report Preview" tab of the Report Designer so that
    you can view the report. (Figure 8)
    Note: All headings (using Label Control) in Page Header band represent
    the exact name used for the column in Customer table. You may change
    the caption of these labels if you wish.
13. Click on the Report Preview tab to preview the report. (Figure 9)
14. Click on the Report Design tab.
15. Select the CustID DB Text control representing the value for CustID
    and click on the the Left Justify icon on the Format Toolbar.
    Note: The CustID column is INTEGER, therefore, the Label and DB Text
    controls were right justified when created by the Report Wizard.
16. Click on the Report Preview tab to preview report. (Figure 10)
    Click the Page Width and 100% buttons to view the report on a larger
    scale.
    Type 80 in the % edit box and press enter.
    Type 120 in the % edit box and press enter again. The report can be
    scaled for viewing at any size up to 250%.
    Click the Page Width button to continue viewing the report.
    Click the Next and Prior page buttons to navigate through the pages
    of the report.
    Click the Print button to access the print dialog. From here you can
    print All, Current, or a specified Range of pages. Click the Cancel
    button to close the dialog.
17. Click on the Report Design tab.
18. Set the Report to Two-Pass Mode
    Click on the System Variable control [Page 1] on the far right of
    the Page Footer band.
    Use the drop-down list control in the far left corner of the Report
    Designer's "Edit" toolbar to change the variable type from Page No
    Desc to Page Set Desc.
    Notice that the System Variable control description on the far right
    of the Page Footer band is changed from [Page 1] to [Page 1 of 1].
    (Figure 11)
    Note: Selecting Page Set Desc option will automatically set the
    report Pass Setting option to Two Pass. To verify, select Report |
    Pass Setting from the Report Designer main menu. Notice that Two
    Pass option is checked. Setting the report Pass Setting to Two Pass
    will cause the report to generate all of the pages automatically.
    One Pass report only generates the first page, and then any pages
    requested after that. This does not allow the report to calculate
    the total number of pages. Two-pass reports are required whenever
    you are using the Page Count in a System Variable.
19. Save the report and close Report Designer.
    Note: Save your work frequently to avoid losing changes should
    your computer unexpectedly lose power or crash.
A PDF version of this document with step-by-step instructions is
available at:
From The Edge: http://www.razzak.com/fte (Powered by R:WEB Suite)
Very Best R:egards,
Razzak.