RKL eSolutions Blog Trends and Insights

Using Crystal Reports to Generate Reports from a Command Line

A lot of Sage 500 ERP clients ask us how they can have some reports generated automatically, put on a schedule and email them to team members. This is what I am going to discuss in the post. For this posting I am running on Windows Server 2012 R2 64 ...

Continue reading
Tagged With: Crystal Reports

Use Crystal Reports to Calculate the Number of Days Between Two Date Fields

  Do you need a report that calculates the number of days between two date fields? This is a simple Crystal Formula:  minus What if you need to exclude the weekends from your calculation?  This formula is a little bit more complex. Let’s say that ...

Continue reading
Tagged With: Crystal Reports

Crystal Reports Doesn’t Display All Objects in the Database

If you use Crystal Reports with an ERP System database, chances are you have encountered this issue. There is a registry setting in Crystal Reports that restricts the objects that are available to add to a report to 8000 objects. This can be ...

Continue reading
Tagged With: Crystal Reports

Using Crystal Reports to Generate Reports from a Command Line

  A lot of Sage ERP MAS 500 clients ask us how they can have some reports generated automatically, put on a schedule and email them to team members. This is what I am going to discuss in the post. For this posting I am running on Windows Server 2008 ...

Continue reading
Tagged With: Crystal Reports, Sage 500

Crystal Report Generation and Overrides from Sage X3 4GL

In Sage X3, Crystal Reports can be generated from code, including passing parameters as variables to the Crystal Report, and defining the output location of the report. This can be useful in generating reports with different parameters on the fly, ...

Continue reading
Tagged With: Crystal Reports, Sage X3

How to Add a Custom Report in Sage X3

  This is the sixth lesson in the series Learning Sage X3.  In this lesson we will cover 'How to Add a Custom Report in Sage X3.' Usually clients do not use the AP Check format delivered with Sage ERP X3. For this example, it is a good practice to ...

Continue reading
Tagged With: Crystal Reports, Sage X3

Sage 500 Provides MRP Strength for Pro Tapes & Specialties

Customer Spotlight Pro Tapes & Specialties uses Sage ERP for core accounting, manufacturing, and distribution. RKL eSolutions has assisted Pro Tapes & Specialties in a variety of ways over the last 6+ years. We performed two upgrades of ...

Continue reading
Tagged With: Crystal Reports

Forget Constructing Multiple Crystal Reports – Use Dynamic Sorts

Are you doing too much S O R T I N G  ? ? No Need to Construct Multiple Reports - Use Dynamic Sorts! Problem:  How do we get a report to change which field it uses to sort your data, depending upon a prompt or other formula? The old school method ...

Continue reading
Tagged With: Crystal Reports