Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal 9 Set Location

Status
Not open for further replies.

HowardHammerman

Instructor
Joined
Oct 11, 2001
Messages
640
Location
US
In Crystal 8/8.5, the 'Set Location' option in the Database menu allowed the user to edit the 'Table:' under the Location settings. For a SQL database, Crystal 8/8.5 defaults to a 'table' with the following convention: database_name.owner_name.table_name. Due to the way my client's reports work in our application, he cannot have the database_name indicated, so he would delete it. This was easy to edit in Crystal 8/8.5, but we cannot figure out how this is done in Crystal 9. Can anyone point us in the right direction? This must be an issue for anyone using a SQL database. If it helps, he uses the RDC method.


Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com
800-783-2269
 
Have not found how to remove it but am able to change it in code as in
Changing Database and Server at runtime in VS.Net
I will be watching closely for a solution. I also need just a table name for SQL DB.


Regards
Chuck LaRue
ADRS Computer Services
 
I also have same problem, i am using sql server database and ODBC drivers ...

Few months ago i found article which says that option update in set datasource location won't work with ODBC datasource...

Why, they didn's write...

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top