Skip to Content
author's profile photo Former Member
Former Member

Removing Command Object

I still consider myself a beginner at Crystal Reports (XI), even though I've had some successes. I know I lucked out in getting my reports done and probably couldn't tell you exactly how I actually did them. I appreciate any help and apologize if I missed something obvious.

What I'm trying to do now is update the reports I was able to first create. I want to add several more tables and fields. Also, because the original reports are using a command object, they ran very slowly. I want to remove the command object and query the database directly. I can do that, right? Well, I did that first thinking this would be the easy part - but I'm not sure if I did it correctly - basically deleting the command object and updating the formula fields to pull directly from the tables. I also went through the Set Database location to update to the new tables and then verified the database. In the Field Explorer, I can browse the data, but when previewing the report no data is returned. There is no error messages. I'm connecting to the database (SQL) via OLE.

Can someone help fill me in on what I missed?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 08:09 PM


    Well, you need to create the new query/view first.

    Make sure that it contains all the fields you are presently using ( the new fields). Make sure the Date Types are the same as the old fields that you want to replace. Even name the fields the same as in the command object. (... with an "AS" clause...table.field as "Order ID").

    Now add the new view to the report. This should activate the "Mapping" feature. The "Mapping" dialog will show you what mapping it thinks is right and which ones it can't figure out. Check them all out, map the new fields to the old fields and click ok. Now you can add the new fields you created because they will show up under "Database" in your report.

    Make sure all the old fields are replaced by the new ones.

    You can tell because all the check marks beside the old fields will be gone. When the fields are all replaced, you can delete the old command object.

    If you miss a step or don't do one of the steps right, the mapping feature will not come up when you add the new view.

    I don't know of another way to force the mapping feature to appear. Maybe someone else knows.

    Happy Hunting,

    The Panda

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.