by Sheila Zhang
We know that Sage 300 ERP is smart enough to use the local SQL database login to replace the SQL database login that is used on the development computer. So you don’t always need to install your client database when developing a general logic report for them on your computer. We did this for a while. However, you need to do this if you are referring to an additional data tabl...

By Sheila Zhang

After Sage 300 ERP upgraded to SAP Crystal Report 2011, several changes appeared for developers and end users. Here are some interesting differences I found comparing version 6.0 and 6.1 besides the logo, icon picture and control name changes. 

You may already notice that the big Close button at lower right corner is removed.

Version 6.0:
...

By Jacky Xu
Last week, we had a project to print a Crystal Report in Sage 300 ERP that must also work with PrintBoss. But, when the program directly prints to PrintBoss, it does not work. Crystal Report 2011 does not have an SDK document for VB6. I add a simple .net class library with COM interface and VB6 project can use this library to print to PrintBoss.
Below are some source codes:
1. COM...

By Kristi Feng
When working with Crystal Reports, sometimes it is hard to add all the tables to the main report to achieve the desire result. We can add subreports to help us, but sometimes we just want to add subreports to do calculations only, and it might leave extra blank spaces that are not needed if the subreport is in its own section. By following the three steps below, the extra spaces wil...

By Sheila Zhang
Last week, someone asked me if it is possible to run A/R Aged Trial Balance Report by transactions’ Account Sets instead of Customers’ Account Sets.
The answer is yes, with a bit of customization. We have a solution to help you accomplish this within Sage 300 ERP. It also can be used to run A/R Aged Trial Balance Report by transactions’ Salesperson codes.
A li...