When creating Crystal Reports. The Data Folder does not get set when I select a different company. Is this a Timberline Bug?

Question

I have a report that I created using a DSN that was set to company ABC. When I run the report depending on the company I have selected it gets me the corresponding data. I have another report that was created the exact same way, only this one will not respect the company change and will only reference the DSN setup I used to create the report. 
 Are there certain steps you have to follow to get this to work? 
 Problem is we have reports that are created 1 for each company, and we have others were the switch is respected, and therefor only need 1 report. 
 Help on this would be much appreciated.

Denise Pierce · Answer

Good morning, 
 
I'm a little late to the conversation but let me recap the typical integration formulas you would want on a Crystal Report: 
 
tsDataFolder is the one that lets the report pull data from the appropriate company folder when the report is run from the Sage menu. The folder path in the formula is just a place holder and doesn't need to point to actual data unless you want to run the report directly in Crystal. 
 
tsDesignMode allows the report to run in Sage even if the users DSN is set to a different mode than the one used to create the report. Typically, you'll want to set your DSN to Standard when creating a report and include the tsDesignMode with a value of "SDesc". That way even if the users workstation is set with the DSN as Custom the report will still run. 
 
If the report is written using a transaction table that has values of new, current, history when the report is run in Sage you'll get the choice of which file to select regardless of the one used to create the report. The tsAskFile can be used to limit which are available to select to or to automatically select just one of them. 
 
In the Users Guide there is a chapter for Crystal Reports that includes information on these formulas as well as other integration formulas you may find helpful. 
 
Denise

Sage Construction & Real Estate

When creating Crystal Reports. The Data Folder does not get set when I select a different company. Is this a Timberline Bug?

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING