90 Minds Sponsor

Crystal Reports Is Slow Opening in Sage 100 ERP 2013

Are you experiencing slow starting of Crystal Report on Sage 100 ERP 2013? Is it taking a minute or more to open CRW  from inside SAGE 100 ERP after clicking designer button?

Brett Zimmerman has the solution:

Uncheck “Check for Updates on Start up” on the Help menu inside Crystal.

Crystal_update

Sage 100 ERP File Layouts and Data Dictionary – Online

sage mas90 file layout

Looking for file layouts / data dictionaries for Sage 100 ERP v3.70 to v4.30? Search no more – follow the link below to view the latest layouts.

If you are using version 4.4+ of Sage 100 (fka MAS90 or MAS200) then look in your software under Tasks – Resources – File Layouts for your copy of the dictionaries.

Sage 100 ERP File Layouts and Data Dictionaries

Suppressing a Sub-Report in Crystal But Still Use Variables Embedded There In Your Main Report

Crystal Reports Tips

 

Thanks to Jim Woodhead from DSD for this tip.

If you have a report (Crystal Reports XI R2) that containes one subreport that passed values back to your main report and want to suppress (not show) the subreport on the main report but still use the values from the shared variables (4 total shared variables) this can be difficule.   When you suppress or hide a section in the main report where the subreport lies, then Crystal  clears (zeroes) out any shared variable values because it doesn’t actual run the calculations and processing of the hidden subreport when it gets there.

So what do you do…..

Well we have the answer!!

What you need to do is on your subreport hide all of the fields. On the main report right click on the subreport and click on the last tab. Check the suppress blank subreport checkbox. This will allow your shared variables to still run without showing them. Their will still be a blank space on your main report. If you want to get rid of that go into the section export, and for the band which has the subreport in it, select underlay following section and suppress blank subreport. Now you will not have an empty space either.

Another option if the blank subreport overlaps something in the next section, you can also format it to not grow (deselect the Can Grow checkbox on the Common tab) then make it as small as possible.

How Do I Add the User ID To My Custom Report in MAS 90? How Do I Show The Name Of The Person Who Printed This Custom Report in Sage MAS 90 / 200 4.40?

MyNameIs

Photo via psanford

How can I add the user who printed a report to a custom report I added to the menu in Sage MAS 90 / 200?

In order to print the User ID on any Crystal Report being run from the MAS 90 menu, you have to create a new formula in the Crystal Report named PrintedByUser. Using Basic Syntax the formula would be: Formula=””’ (and using Crystal Syntax would be: “”).

PrintedByUserFormula

You can use this tip on custom reports for both business framework modules and legacy modules.

There are number of variables that MAS 90 passes through to Crystal Reports that are run from within MAS 90 and can be used in the same manner:
CompanyCode
CompanyName
CompanyAddress1
CompanyAddress2
CompanyAddress3
CompanyAddress4
CompanyPhone
CompanyFax
CompanyFederalID
CompanyStateID
CompanyURL
ModuleDate
CompanyNameCode (CompanyName + CompanyCode)

That’s great, but I want the user name on my custom report.

OK, that’s a little trickier. You still need to create the PrintedByUser field as above, however to get the user name you’re going to need to create a subreport.

Creating a Subreport to Add the User Name to a Custom Report

You have to use a subreport because you’re going to have to join the SY_User table by the PrintedByUser formula field you created.

From the Crystal Report, go to Insert | Subreport.

Create a name in New Report Name; I’m calling mine UserNameSub and click Report Wizard.

InsertSubReport

Using the Report Wizard you’re going to create a new report based on the SY_User table. Add the First Name and the Last Name to the subreport and click Finish.

On the Link tab, select the PrintedByUser formula as the field to link by and from the dropdown select UserLogon. Click OK.

SubLinkTab

Drop the subreport on your main report.

Now for a little cleanup. Right click the subreport and select Edit Subreport. I’d suggest suppressing any Headers or Footers in the subreport and if you want instead of having the FirstName and LastName fields, you can create a formula combining the two into one field.

Close the Subreport and save your report and run from the MAS 90 menu and you should get the user name on your report.

Sage MAS 90/200 Quick Tip from Zip: Crystal, blank date

If you ever need the ability to enable criteria on a Crystal Report, for dates that equal ‘blank’, a simple formula like this will do the trick:  {date field} = Date (0000, 00, 00)

Posted by Brett Zimmerman.