Need help modifying a sql query.

[beilstwh]

I am a senior developer at my company, but an absolute newbie with Crystal Reports. Our site has a web server that is integrated with crystal reports 7.0.1.100 and I have been tasked with speeding up a report that was taking 24 hours to run. I have the base view down to 8 minutes, but I can't figure out how to edit the query that is used by the report. I have checked the web and everything reference version 9 through 11. I have found a book on version 7 and it has no information on editing an existing query. I did a binary dump of the report definition file and it had no query strings in it. If any one can help me out, I would really appreciate it.

[beilstwh]

I am sorry that I am bumping my question, bt I haven't received a single answer in a week. I guess people just don't want to answer questions in codeguru. Can anyone at least suggest a place that might have an active crystal reports forum? (No response at the offical Crystal Reports site either).

[JaganEllis]

Go on then, I'll bite :) (Although I don't use V7)

What do you mean by 'I have the base view down to 8 minutes'?
Have you looked at the SQL (Database menu, Show SQL Query) and changed it outside of Crystal so that it performs better?
When you choose the Database Expert option from the Database menu do you have a command (does V7 support this?) or a list of tables?
Are the table joins any good (the links tab in the database expert)?
What are your selection criteria? (Report menu, selection formulas)?

i.e. there's no single place where you edit Crystal's query (unless it's a command query) - it's built up from how your report is defined in a number of different screens. Depending on what you specify, Crystal composes a query that it'll pass down to the database.

What is it about the current report that takes the time?
Is it the SQL query itself thrashing the database server?
Is it the sheer number of records to process?
Is it a load of Crystal subreports?

I think it's fairly obvious from both this forum and the CR one that they are both pretty active and people are willing to help when they can. And I think that's the point - when they can. The overly complicated requests often get little response, as do the overly vague ones.
Unfortunately, I think yours falls into the latter category as there's nothing really specific to help with without understanding what it is you want to do. You might think that asking how to edit the query is pretty concise, but actually it's not! Not in CR anyway.

[beilstwh]

I am not worried about the base view, the report should use. I simply need information on editing an existing query in version 7. I can see the querys being used in the logs and the consultant did a horrible job in designing them. I simply need to be able to modify the report query to use my redesigned view.