Hello all,

I would like to state that I have no formal training in Crystal/databases, which is probably why I’m experiencing this problem in the first place. By tinkering with existing reports I’ve learned quite a bit but there must be some fundamental data connectivity concept that is lacking. Here is the setup:

Sage Timberline 9.5.0 w/ update 6

Crystal Reports XI R2

I’m trying to modify a pre-existing crystal report that comes stock with Timberline. If I run the report directly in Timberline, as is and unmodified, it runs fine. If I open it in Crystal and try and to print preview, it gives me a couple errors.

First, it says the data folder doesn’t exist. In the formula of the report it has an entry for

tsDataFolder = “c:\tsData\”

I don’t understand why this is hardcoded into the report, yet it works when I run in out of Timberline directly when my data does not reside there.

Second, if I correct the above entry and run a print preview I get a number of errors due to “no such table or object exists.” In the report, the Timberline Data Source has tables that look like this

“ARA_ACTIVITY__ACTIVITY”

Whereas the connected Timberline Data Source I’m working with has tables like

“ACTIVITY_ARA_ACTIVITY”

Every single one of the tables in the report has this transposed naming convention. If I then select “Set the Datasource location” and manually replace all of the tables with the correct ones from my datasource, Viola! I can print preview!

I then proceed to run the report from Timberline and the application crashes! Even if I take the original report and only try to link another table from the datasource, it still crashes when I try to run it in Timberline.

What am I missing here?

Thanks in advance,

-J