Sage 100

Client would like to find out if it's possible to use KnowledgeSync to track when certain users run certain MAS90 reports. I told him that I didn't believe we could query the database in such a way, since I'm not sure how we would monitor work tables or access alone. Client went to Vineyardsoft directly and they told him it was possible with VB scripting. Before I go down the road of exploring a script, does anyone have an idea if this is actually feasible?

I can see or rather understand how this would work. The script would probably write out info to either Excel or Access which KS would monitor and then send you an alert. I would talk with Don who would probably be able to give you a detailed explination of how it would work.

Theoretically, if you can attached a VB script to run when the report is executed, the script could write a row to a table logging the report run, who ran it, date, time, etc. Knowledgesync could then monitor this table and generate a report. KSync may have other options for initiating a KSync event via a script that I am unaware of. However, this would still depend upon an event trigger on the report execution.

I wounldn't exactly know how it's done, but I could see a script attached to the report task (the preview or print button?) so when it's run an entry is made to a log file. Then KS can report on the log file. Sound feasable?

I think this depends on the report. Certainly for forms Bill is correct you could replace the Print button with a button script that logs and then invokes the overlayed button. However, you cannot modify buttons on regular reports because those are Library Master (common) panels that aren't customizable. I think you would be better off with trying the approach with one of the 3rd party Crystal enhancements that provide file management within Crystal. Ken Hamady lists some 3rd party enhancements here: http://www.kenhamady.com/uflfunctions.pdf

Thank you Dan! I will review the link you sent. That sounds like an interesting route.

If you use Paperless Office to automatically retain a copy of the reports in question you can monitor the PL_ReportPDFLog and join it with the SY_User file to track specific users and reports. No script should be needed.

Thanks Mike - I like that idea but we'd have to force users to print to Paperless which is not going to happen with this client, since there's not ""auto"" PDF of anything but registers/journals.