Transcript Slide 1

SQL Report Writer
SQL Report Writer
 The
SQL Report Writer is included with
every Appx runtime.
 It is intended to be used by end users to
create their own reports.
 Reports can be saved, and shared with
other users.
 Designers can take a user created report
and copy to a production application.
Installation
 Define
application SQL/00 and
SQL/<version>, if using non 00 version.
 Create source files (should say already
exists)
 Define database Q<version> with SQL
<version> as startup app
 Create files for database Q<version>, App
SQL <version>
Installation – Con’t
 Define
app to store reports, ie, SQA
<version> and create source files.
 The above needs to be done for every
version where you want to run the Appx
report writer. If you have a test (TS) and a
production version (00), and you want to
run it in both, then you need a SQL/TS
and database QTS.
Installation – Con’t
 Attach
it to a menu somewhere, run app
SQL, type INPUT, name APPX SQL
Installation – First Run
 You
will have to designate a Query
Manager. Any query designed by this user
will be available to all as a common query.
 You will have to designate which
application to store the reports in.
Recommend SQA <version>, but can use
anything.
Installation – First Run
 If
you leave it blank, then user id is used.
Note that the Application must exist, which
is inconvenient if user id is used.
Creating a Report
 Creating
a report is intended to be a
simple process where the user is guided
through the steps.
 The user first chooses which application
and which table to use.
 After that they can pick fields to print, join
to other tables, sort in various sequences,
perform calculations and export the data in
various formats
Creating a Report
 Demonstrate!