Crystal Reports with ManageIT software HELP

[BoniR]

Hello!
I am at a loss with this problem and thought maybe I would get lucky here...
First, I am using Crystal 8.5 to adjust some reports that are built into the ManageIT software by Logic Built...
ManageIT uses a dao/ado file from an Access database for its connection...I am also adding a table from the database to this ado through Crystal (not Access)...
Once the report is altered it is neccessary to put the report in the custom folder provided by ManageIT (upon install)...
Now, when a user runs reports from the local machine they are fine but if someone comes into the same machine remotely (through Terminal Services) there is an error message generated when trying to run the customized reports...it is a "{table} not found at {table} location" error...
I know this is a long shot but I am hoping that someone out there has had this problem before and found a solution either with ManageIT software or maybe something similar...
Anyway, thank you so much for taking time to read my question and thanks to anyone who can provide any type of assistance!!!
Boni



Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269

 

[synapsevampire]

It may be that you're referencing a mapped drive instead of the UNC. This means R:\path\... instead of \\server\path\...

I don't understand why you're adding the other datasource into Crystal instead of Access. Access is a much faster database engine, and you can LINK (don't import) to any ODBC data source.

Then create a Access Query as the basis for your Crystal Report.

If you're not allowed to use the current Access database, create another one and link everything into it.

-k

 

[BoniR]

Synapsevampire-
Thank you for your superfast response! Your suggestions might just work...I knew it had something to do with the fact that I was using a mapped drive!
I don't have access to the actual dao file so I was unable to manipulate it, but it is possible that I could recreate it by copying the SQL and creating a new dao...
Thank you for again bailing me out!
Peace
Boni


Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269

 

[synapsevampire]

Ahhh, I missed that you're one of Howard's associates. The pleasure was mine, and please say hi to Howard for me.

-k

 

[BoniR]

Definately will!
Thanks again!
Boni


Boni J. Rychener
Hammerman Associates, Inc.
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter

http://www.hammerman.com

800-783-2269