Personalization, Customization and Productivity Tools

[JSchreibman]

We have a need to automatically run some Crystal Reports at night.  Have tried to find out if KNOWLEDGESYNC will do the job or if there is something less expensive like Saber Logic's Logicity.  Downloaded and installed Logicity but can't get it to work.  Any ideas?

Also, one of the nightly jobs is to create an Excel file for use in one of the other reports required nightly.

[Emily]

I've been using VisualCUT to run automated Crystal reports for a few years now and I've been very happy with it.  It was relatively inexpensive.  It can email, export to Excel, CSV or other formats.  VisualCUT paired with a simple batch file and the Windows scheduler has worked well for me.

It's a very small company (one man show, I believe), but his tech support is awesome - he's very responsive and helpful.

[BigLouie]

Welcome to the Sage Community. We use Knowledge Sync and really like what it can do for us.  Well worth the cost. We send out invoices to customers, late payment notices, shipping notifications with tracking numbers, reports to various deparments. We can send out as PDF or Excel or Text. We update our install of SalesLogix with it. We have MAS, SalesLogix and MS Access as data sources.

[connex]

I use Logicity for a number of clients and haven't had a sinlge issue.  I've found it reliable and the support excellent.  I use it to export Excel and PDF both to the file system and to email.

If you detail your symptom, you might have been luck getting some suggestions.

[JSchreibman]

We need to run many of the SAGE MAS 200 Standard pre-defined reports or slightly customized versions of them.

I have been told that Logicity will only run totally customized reports which do not require data selection using the MAS front-ends.  Is there anything other than KNOWLEDGESYNC which will handle the standard reports?

[BigLouie]

Do you have an issue with Knowledge Sync?  We use Knowledge Sync and have found it to be a great product with great customer service. One of the best MAS add-ons out there. It is extremely versatile with the ability to not only run reports but also to update databases.

[rjledger]

SURE!.. and it's called TaskCentre - tons better IMHO than KS.

If you would like more info, feel free to contact me directly

Office: +1 508.809.9513 or email:rjledger@rjlsystems.net

[smalm]

JSchreibman,

Any of the modules that have been brought up to the business framework allow for a COM interface to run standard MAS 200 reports using the BOI (business object interface).  There is a training class availble for this or you can contact your reseller to get more information.  To get a feel for how you might be able to do this (i.e. this is not real code) here are the methods used to print a report:

SET oRPT = oScript.NewObject("AR_AgedInvoiceReport_rpt", oSS) ' instantiate object

retVal = oRPT.nSelectReportSetting("STANDARD") ' select report setting - use any saved setting for report selections

retVal = oRPT.nProcessReport("DEFERRED") ' print report to deferred printing (can also use PREVIEW or PRINT)

Hope this helps

Steve