1 / 9

SQL Report Writer

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.

todd-davidson
Download Presentation

SQL Report Writer

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SQL Report Writer

  2. 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.

  3. 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>

  4. 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.

  5. Installation – Con’t • Attach it to a menu somewhere, run app SQL, type INPUT, name APPX SQL

  6. 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.

  7. 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.

  8. 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

  9. Creating a Report • Demonstrate!

More Related