Crystal 10, Manually Changing, SQL Changes, Blank Report - bug?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Zhandra (zhandra_at_igmax.com)
Date: 04/14/04 

Date: 14 Apr 2004 09:12:53 -0700

In Crystal 10, I have a report that runs well, but needs one more
field from a different table. When I add that table, the report goes
blank. When I remove the offending table the report stays blank.

1. So I reloaded the original report that runs, and copied the SQL
statement from the Main Menu -> Database -> Show SQL Query, and pasted
it into a database query tool, and it ran fine.
2. Then I added the offending new table, copied the new SQL from
Crystal, and pasted it to my query tool, and it was broken.
3. But here's the freaky thing... When I deleted the offending table
from Crystal, the SQL changed again, but still very different from the
original SQL, and still broken. (wouldn't you think you could add a
table, and instantly remove it, and the SQL should revert to the
original SQL? Not so!)
4. So I decided to track down the error. I added the table back in
Crystal, linked it up correctly, copied the SQL to my query tool (and
as I expected, it was broken)... so I fixed the SQL to work in my
query tool...
5. But now I don't know how to get it back into Crystal. In older
versions, I could just paste it back into the place I got it. In
crystal 10 it is greyed out, so I can copy it, but I can't change it.

Does anyone know if this is a known bug? Has anyone found a fix for
this?

When I go to Business Object site to see if they have any hotfixes, I
can find plenty of fixes for Crystal 9 and below, but no hot fixes for
crystal 10.

Any ideas?

Thanks in advance,

Zhandra

Relevant Pages

  • Re: Populating a list -- table structure?
    ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ... KitID, long integer ...
    (microsoft.public.access.forms)
  • Re: SCAN.EXE - McAfee AntiVirus Software
    ... > | of network computers and have only report summaries sent to be via ... > | Virus Scan Report File ... > | application RemoteProcessLaunch. ...
    (microsoft.public.security.virus)
  • Re: Populating a list -- table structure?
    ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)
  • Re: Populating a list -- learning Access
    ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL! ... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... Queries (just shows the QBE grid for convenience -- ...
    (microsoft.public.access.forms)
  • Re: Problems adding "All" to combo box
    ... SQL for each combo box is in a previous post). ... You have a report defined that is named AI Thru Hole Work Log_Operator ... of the report or form you want to filter ...
    (microsoft.public.access.formscoding)