This is the basic steps to make a simple report using Developer workbench.
Description
In this Lesson you will learn how to make a simple report. In this report you are using a customer table from
eg Data ODBC Connection. To make the report, follow the steps described below.
In
Actuate Create a new report by selecting File =>
New.
In
the New File Dialog box, select Blank Report Design.
In New Report Design, give the Title, Filename and Report Root Name. Title: Appears in the title bar of the Designer Workbench. It does not appear in the report as the title. Set Report titles as specified in Actuates Pagelist component. File Name: Name of the design file. (i.e.
cfMontylyCashFlow.rod) Report Root Name: Name that appears as the top node in the structure pane of a report design.
In the Content Slot, place Report Section from Structure Palette.
In Connection Slot place connection component and select AcodbcConnection from Select Component Dialog.
In Component properties dialog set datasource to
egData.
In DataStream slot, place Query component and double click on it.
In
Component Editor click on the Ellipse button and give blank
username and password in Database Login.
Place
a label control in the frame and change its Text to Name.
Place
a text control to it and set ValueExp to [Address.AddrName].
Put Pagelist Control into Pagelist Slot and select
AcSimplePageList. Page list defines the page layout of the report. There are 3 types of
pagelayouts. AcLeftRightPageList, AcSimplePageList,
AcTitlBodyPageList. AcLeftRightPageList is used when you need different layouts for left and right pages. AcTitlBodyPageList is used when you need different layouts for Title and Body pages.
In
pagestyle put page control.
Put
flow into content slot.
Now
your first report is over. You can save and run it!
Let us now add some Header and page number to our report. In page style, put label control and change the Text to Customer Report and change size of it to 24. Put Text Control to bottom of page and set its value expression to "Page " &
PageNo$. Put
date time control also to down of the page and set ValueExp to Now. We can also change the format of Date. Let us set it to
M/dd/yy. Now run the report to view the changes we made.