SpiceRAQ
In the ClassPag reports menu at the bottom is a new item. SpiceRAQ reports.
SpiceRAQ has been available for a long time but William made it more available as of version 5.66. It can now be launched from within ClassPag.
A user can view and run the report.
Someone can run SpiceRAQ separately and run the reports without running ClassPag.
Creating a report
Press insert to create a report.
There will be a amenu on the left side, go down the menu items to reae yor report.
Form Size
Data Tables: pick a table, you are given a choice of many tables. Name and description is displayed on the screen.
Field Selection
Data that will be in the report. Press insert and select fields. AS you select fields SR will show you a dialog. You do not have to change anything in that dialog if you do not want to; this is automatically formatting the field to fit on the screen in order left to right as you add them. If you insert a field when a field other than the last one is selected, it inserts the field below the field selected.
You can stop here and exit and save when prompted. Now your report can be viewed from the reports dialog.
You can also change the data appearance with length and data type.
Headings
Select the field and enter. You can click on the "heading" button and put text in the text box. This will be the column heading for the field.
"Headings and footings" allows you to enter header and footer for the entire report. This can include dynamic elements such as date.
Tabulations
Summary data. You could show area used.
Sorting
You can change the sort key. Multiple sort levels are allowed, you can go as deep as you want to. You can select a group summary for the sort.
Export table
This outputs the file to a csv format. You have to click the export button, put in the name. You need AppLauncher (and Excel) if you want to View. This is a simple PC application, download from the SCS support website, unzip and follow instructions to install.
There's more than is shown here. When you purchase SpiceRAQ it includes training.
Filtering
You can filter on the data as well.
You can link databases together, select the second database and respond "yes" to the link. You then choose the key to link the databases together. Edit segments, from table, select field name, do this once for each table.
Chris suggests doing your report incrementally, adding one field or a couple of fields at a time, make a change and run, rather than making many changes and finding you have an error and then having to figure out which of the changes you made caused the error.
Keith and the AdMax people know a lot about this product; they use it more than the ClassPag people at this time. But they are getting into it more deeply. It has been around for a long time. It is more recently applied more to ClassPag.
SpiceRAQ is new to the ClassPag environment and is not included in first round of contracts with any current users. Cost is $3000. Built-in reports are separate from this and do not cost extra. The engine for this drives all the reports but this is the ability to create your own reports.
This compares timewise with Crystal Reports as faster by a factor of 60.
SpiceRAQ has been available for a long time but William made it more available as of version 5.66. It can now be launched from within ClassPag.
A user can view and run the report.
Someone can run SpiceRAQ separately and run the reports without running ClassPag.
Creating a report
Press insert to create a report.
There will be a amenu on the left side, go down the menu items to reae yor report.
Form Size
Data Tables: pick a table, you are given a choice of many tables. Name and description is displayed on the screen.
Field Selection
Data that will be in the report. Press insert and select fields. AS you select fields SR will show you a dialog. You do not have to change anything in that dialog if you do not want to; this is automatically formatting the field to fit on the screen in order left to right as you add them. If you insert a field when a field other than the last one is selected, it inserts the field below the field selected.
You can stop here and exit and save when prompted. Now your report can be viewed from the reports dialog.
You can also change the data appearance with length and data type.
Headings
Select the field and enter. You can click on the "heading" button and put text in the text box. This will be the column heading for the field.
"Headings and footings" allows you to enter header and footer for the entire report. This can include dynamic elements such as date.
Tabulations
Summary data. You could show area used.
Sorting
You can change the sort key. Multiple sort levels are allowed, you can go as deep as you want to. You can select a group summary for the sort.
Export table
This outputs the file to a csv format. You have to click the export button, put in the name. You need AppLauncher (and Excel) if you want to View. This is a simple PC application, download from the SCS support website, unzip and follow instructions to install.
There's more than is shown here. When you purchase SpiceRAQ it includes training.
Filtering
You can filter on the data as well.
You can link databases together, select the second database and respond "yes" to the link. You then choose the key to link the databases together. Edit segments, from table, select field name, do this once for each table.
Chris suggests doing your report incrementally, adding one field or a couple of fields at a time, make a change and run, rather than making many changes and finding you have an error and then having to figure out which of the changes you made caused the error.
Keith and the AdMax people know a lot about this product; they use it more than the ClassPag people at this time. But they are getting into it more deeply. It has been around for a long time. It is more recently applied more to ClassPag.
SpiceRAQ is new to the ClassPag environment and is not included in first round of contracts with any current users. Cost is $3000. Built-in reports are separate from this and do not cost extra. The engine for this drives all the reports but this is the ability to create your own reports.
This compares timewise with Crystal Reports as faster by a factor of 60.
posted by JoAnne at 6:41 AM
0 Comments:
Post a Comment
<< Home