Crystal Report and Sage

Lani Vriezema
Lani Vriezema used Ask the Experts™
on
How do you redirect crystal report to pull the information from the current company file you are in Sage?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are you running the reports from Sage?

DId you create the reports?

mlmcc

Author

Commented:
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"
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
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
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Author

Commented:
Mike,

It used to until Sage went to version 17
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
You may need to contact Sage as their upgrade may have an error

mlmcc
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Can you open the report in Crystal and look at the report filter?

mlmcc

Author

Commented:
I built the report in crystal.

Author

Commented:
It had to do with the TsDesignMode formula. I was able to figure it out. Thank you for your assistant.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial