Has anyone obtained any toolkit for reporting on APS Database?

We have asked Crystal and been told there is one but cannot get hold of it

Can anyone guide us


Thanks

Can you explain more what you are looking for?
Do you mean that Baan data in the APS module is not available in Crystal?
If not, I suggest using Croko Reporter which builds its own datadictionary from the Baan data dictionary
www.croko-reporter.nl

We are trying to get some statistics on the reports
themselves

ie How many times a job is requested
How frequently is it requested
What time of day is it requested
How long does it run , longest , shortest
What is the delay time between schedule request and start time
What is the delay time between schedule request and finish time
How many jobs get requested per hour during 24 hours


etc
etc

One of Crystal Enerprise's partner organisations - APOS Systems Inc - is offering a solution called "View Time Security".

It takes advantage of Crystal's processing extensions capability to format activity log transactions to an external database. Using this solution you can obtain statistics on report usage, system activty performance, User ID activty, date/time stamping, etc. Their website is www.apos.on.ca.

I obtained this information from the crystaldecisions knowledge database, so it isn't a personal recommendation as such. There may be other vendors in the UK offering similar solutions.

[OR]

Frank,

You can build your own program based on the tools tables from Job Data and Job History.


ie How many times a job is requested
How frequently is it requested
What time of day is it requested
How long does it run , longest , shortest
What is the delay time between schedule request and start time
What is the delay time between schedule request and finish time
How many jobs get requested per hour during 24 hours

The job management module in BaaN provides information on jobs that have been executed within BaaN (ie you might schedule a report of MRP reschedule message - timrp1437m000 - to run overnight).

What Frank is talking about, though, is monitoring the traffic & performance of scheduled Seagate crystal reports themselves that run on the Crystal Info Report server.

If you are reporting out of the Crystal Enterprise APS Database, your best bet is to stream out the data (via XML) into another database for reporting. There is an administrative crystal "Plug-in" that will allow you to fully expose the APS database (which has many fields that are all combined into 1 field) and parse out the data.

Once upladed into a new database, there are many vital stats that can be retreived.

Note: Crystal Decisions does not reccomend or support reporting directly off the APS.

Thanks davids !

Do you have the Admin "plug in" if so how did you acquire it ?
If not do you know how to get hold of it ?

We have been told by the Crystal support group in Canada? it exists and that the UK support site would be in contact but.... they haven't for 2/3 weeks now so we have gone back to the Canada? support site for further assistance

The Admin SDK comes with Crystal Enterprise. I'm checking with one of out tecnical folks as to the file names.

There also is documentation on the CE CD that can walk you through the Admin SDK.

Dave