• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 274
  • Last Modified:

Setting up a new Datasource Location

I have a report based on an MS Access database query.  I'm trying to keep the same report but use it in another ms access database with a near identical source query.  When I go to set datasource location and bring up the new location there is only tables, views and stored procedures directly under the new database location.  When I highlight the new location the Update command button is highlighted but when I click on it it says: "Some tables could not be replaced, as no match was found in the new Data Source.  Pleawse specify the table required for any unmodified tables"  The problem is that the datasource is not from a table but a query (same as the original source).  How do I select a query instead of a table?  I've got to do a little bit of mapping but can't even get to that point.  Thanks
0
zubin6220
Asked:
zubin6220
  • 4
  • 2
1 Solution
 
crgary_txCommented:
What is your source? you cannot replace the command with any other source. If you need to replace the command, you need to first store the command as the query in the repository and then replace the query with the new table/view/sp/command. Let me find that BO article which has more description on that.

Gary
0
 
zubin6220Author Commented:
Every time I attempt to get into the repository, it asks me to log on to Crystal Management Server but there is none.  The new command object (query) appears to be connected but it only shows up as 'Command'.  Can the name be changed?

Thanks  
0
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
crgary_txCommented:
Repository comes with crystal enterprise/Business objects enterprise? Are u using this to publish your reports?  If you dont I am afraid there is no easy way.

Gary
0
 
crgary_txCommented:
Here is a similar discussion which can provide you a work around

http://www.experts-exchange.com/Database/Reporting_/Crystal_Reports/Q_22735875.html

Gary
0
 
zubin6220Author Commented:
I'm only using Professional so the repository doesn't do me much good. The link you posted does give a work-a-round though.  Thanks for your help.
0

Featured Post

2018 Annual Membership Survey

Here at Experts Exchange, we strive to give members the best experience. Help us improve the site by taking this survey today! (Bonus: Be entered to win a great tech prize for participating!)

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now