Link to home
Start Free TrialLog in
Avatar of Lani Vriezema
Lani Vriezema

asked on

Crystal Report and Sage

How do you redirect crystal report to pull the information from the current company file you are in Sage?
Avatar of Mike McCracken
Mike McCracken

Are you running the reports from Sage?

DId you create the reports?

mlmcc
Avatar of Lani Vriezema

ASKER

Mike,

Yes, I am running the reports from sage. My problem the report does not want to pull the data from the company file that is open in Sage.
I made sure I had the following formula in my report to redirect the report to pull the data from whichever company file is open. I am on version 18.

tsDataFolder:
"c:\tsData"

TsDesignMode
"SDesc"
I don't know anything about how Sage runs reports.

Is this a standard report they provided?

Does the report always pull from the same company?

mlmcc
Mike,

It used to until Sage went to version 17
ASKER CERTIFIED SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Can you open the report in Crystal and look at the report filter?

mlmcc
I built the report in crystal.
It had to do with the TsDesignMode formula. I was able to figure it out. Thank you for your assistant.