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
Win XP w/ SP3
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