Wednesday, February 9, 2005
From the Edge: Creating a Tabular 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.30209 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 tabular 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 NameType 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
CustPhone07. 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. Keep all default options for Report Layout, Orientation 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 the 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 Label and then hold down the Shift key and click the
corresponding DB Text control directly below it and click on the click
on 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.
P.S. This document is intended to help *new* R:BASE 7.1 users who have recently joined the R:BASE World!
--- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected]
(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, place any text to search for.
================================================
