Solved

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

Posted on 2007-03-23
3
239 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
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 …
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

771 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now