Posts Tagged ‘Crystal Reports’
Sunday, July 18th, 2010
There is a lot of discussion back and forth about reporting speeds in business and accounting applications. I recently did some benchmark testing as shown in this video below to highlight the difference.
MAS90 and MAS200 run on a flat file database. The way it is written, internal ‘hard coded’ reports run fairly quickly, but reports and external applications that access its data via ODBC (such as Crystal Reports) can be painfully slow.
This issue becomes even more obvious when reports use more than one ‘left outer join’ which means you are matching up data from two places where there isn’t a guarantee data exists to link in both tables. An example of this is an Invoice History report showing salesperson information from another table but yet MAS 90 doesn’t require a salesperson to be associated with an invoice.
(more…)
Tags: business intelligence, ca, Crystal Reports, ct, Florida (FL), New Hampshire (NH), new york city, nj, ny, pa, reporting performance, speed
Posted in Microsoft Dynamics NAV | 6 Comments »
Tuesday, September 22nd, 2009
Here is a new overview guide of what’s new in the upcoming release of SAP Business One 8.8 scheduled for Q1 2010.
Highlights include:
- Full native SAP Business Objects Crystal Reports Integration
- All built in forms are now Crystal Based
- Most built in reports are Crystal Based
- Custom reports can be created and added in seemlessly
- Reports provide the ability to drill back into source SAP Business One Transaction screens
- Available to Promise (ATP) is available during order entry
- A new Accountings Receivable Aging and Accounts Payable Aging Report
- Support for embedded Crystal Xcelsius views
- An option for a new fresh Look and Feel in the GUI. Users can choose between the classic and new views.
- Data Archiving is now available to copy outdated history to reportable tables. This will speed up daily activities since they don’t have to hash through long outdated information.
- Changes have been made to the SDK that should allow add-on products to run faster
This version can directly upgrade 2005A/B and 2007A/B installs. The new version is now one version for all localizations which should simplify future upgrades and third party development.
Click What’s New in SAP Business One 2008 for the document.
Tags: accounting for a llc, Albuquerque, Allentown, Altoona, Anaheim, Arizona (AZ), Arkansas (AR), Arlington, Atlanta, Austin, Baltimore, Baton Rouge, Birmingham, Bloomsburg, Boston, Buffalo, ca, california, California (CA), Charlotte, Chicago, Cincinnati, Cleveland, Colorado (CO), Colorado Springs, Columbus, connecticut, Connecticut (CT), Corpus Christi, CRM Software help in: Alabama (AL), Crystal Reports, ct, Dallas, Delaware (DE), Denver, Detroit, El Paso, Florida (FL), Fort Worth, Fresno, Georgia (GA), Glendale, Harrisburg, Hazelton, Hempstead, Houston, Idaho (ID), Illinois (IL), Indiana (IN), Indianapolis, Iowa (IA), Islip, Jacksonville, Jersey City, Kansas (KS), Kansas City, Kentucky (KY), Las Vegas, Lock Haven, Long Beach, Los Angeles, Louisiana (LA), Maine (ME), manhattan, Maryland (MD), mas 500, mas200, mas500, mas90, Massachusetts (MA), Memphis, Mesa, Miami, Michigan (MI), Milwaukee, Minneapolis, Minnesota (MN), Mississippi (MS), Missouri (MO), Montana (MT), Nashville, Nebraska (NE), Nevada (NV), New Hampshire (NH), new jersey, New Jersey (NJ), New Mexico (NM), New Orleans, new york, New York (NY), new york city, newark, nj, Norfolk, North Carolina (NC), North Dakota (ND), ny, nyc, Oakland, Ohio (OH), Oklahoma (OK), Oklahoma City, Omaha, Oregon (OR), pa, pennsylvania, Pennsylvania (PA), Philadelphia, Phoenix, phone support, Pittsburgh, Portland, Raleigh, Reading, remote support, Rhode Island (RI), Sacramento, San Antonio, San Diego, San Francisco, San Jose, Scottsdale, Scranton, Seattle, South Carolina (SC), South Dakota (SD), St. Louis, St. Petersburg, State College, support, Tampa, Tennessee (TN), Texas (TX), Toledo, Tucson, Tulsa, Utah (UT), Vermont (VT), Virginia (VA), Virginia Beach, Washington, Washington (WA), West Virginia (WV), Wichita, Wilkes-Barre, Williamsport, Wisconsin (WI), Wyoming (WY) CRM and Accounting Software Support for the following Metropolitan Areas: New York
Posted in SAP Business One, Uncategorized | No Comments »
Wednesday, September 16th, 2009
Thanks to Wayne Shulz at www.s-consult.com for his blog post on doing this. If you use Crystal Reports as a mechanism for exporting data out of MAS90 or MAS200 (or against any database for that matter.)
Normally it will only export the number of characters that you can physically see on the preview or printout as it’s quite ‘literal.’
Here’s a link to Wayne’s solution. We hope you find this helpful
Tags: ca, Crystal Reports, data extraction, database, export data, exporting, extraction, long text fields, mas200, mas90, new york city, nj, ny, pa
Posted in Sage MAS 90 and MAS 200 | No Comments »
Tuesday, September 1st, 2009
Error 12 SWCOCX 130, "A DLL is either corrupt, not been properly registered, or incorrect version. Please contact your System Administrator" when printing graphical forms.
Possible Resolutions:
Notes:
- Use extreme caution when editing the Registry. If the Registry is edited incorrectly, Windows may not function properly or may not run at all. Sage Software Support is not responsible for assisting with editing the Registry. Always back up the Registry before accessing it. If necessary, seek the assistance of a qualified computer technician.
- Sage Software Customer Support is not responsible for assisting with workstation permission issues and takes no responsibility for changes made to your system or for errors in these instructions. Consult your network administrator before making changes.
(more…)
Tags: bronx, brooklyn, ca, Crystal Reports, ct, edison, error, holmdel, il, manhattan, mas 200, mas90, md, new jersey, new york, nj, ny, nyc, pa, parisppany, pennsylvania, queens, tx, yonkers
Posted in Sage MAS 90 and MAS 200, Tech Tips | No Comments »
Subscribe to RSS
There is a lot of discussion back and forth about reporting speeds in business and accounting applications. I recently did some benchmark testing as shown in this video below to highlight the difference.