Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Why won't Crystal Reports let me update the Database Expert Query?

Posted on 2007-03-23
3
243 Views
Last Modified: 2008-02-01
Hello everybody!  I am in the process of trying to update the Database Expert Query, but when I hit OK and go back and check, there is no change to the query.  What am I doing wrong and how do I change the Database Expert Query?  Is there anything I can do to change this?
0
Comment
Question by:VBBRett
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 18779959
What are you trying to do?

What do you mean update?
Have you tried DATABASE --> VERIFY DATABASE

mlmcc
0
 
LVL 13

Accepted Solution

by:
crgary_tx earned 500 total points
ID: 18779962
By D/b expert query I assume the command object?
You need to store the command object in the repository first and then update the current query with the new query in the repositoy. You can refer to the link to kbase article in this thread:

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

Gary
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 18780157
If this is a report from a previous version of Crystal that is based on a Crystal Query (created using the Crystal SQL Designer) then you have two options:

1)  If you have Crystal Reports Server, Crystal Enterprise 10 or BusinessObjects Enterprise XI, then you can use the Database Migration Wizard.  This will convert the query to a SQL Command Objects

2)  If you don't have any of the above software, you can rewrite the report.

~Kurt
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question