General Consultant Discussion

Normally we get the company name from SY0_Company for custom crystal reports. SQL does not have this table available in Premium. What is the solution for this?

How about the CompanyCode from GL_Options?

Sorry, didn't finish the thought. Get the CompanyCode from GL_Options and join that to SY_Company to get CompanyName.

SY0_Company is not available. But SY_Company is available under MAS_### --> dbo --> Views. Join that to your Tables (MAS_### --> dbo --> Tables

EDIT - If you are adding the report to Custom Reports menu, you can add one of the common formula fields (from Sy_ReportCommon) and show the Company Name. Whenever a custom report or worktable report / form is processed by Sage 100 (Std / Adv / Prem), these fields are sent to the Crystal print engine. You just have to expose it in the RPT. There is an article by @RobertWood on this - @CompanyName - http://community.90minds.com/2011/05/27/add-user-name-to-mas90-custom-report/ In your case, open the RPT with Crystal then create a formula called @CompanyName or @CompanyNameCode (for the name + code). Then the formula contents is just """" if using Crystal syntax otherwise formula="""" for Basic syntax. Then just add the formula field to the RPT. You won't see the data directly in the Crystal designer but you will when you print / preview from Custom Reports menu.