how do i edit the sql in crystal reports 11

hi all

i never use crystal reports at all, but i need to urgently edit a report created by someone whos on holidays, and as far as i can see it was created with a sql script, which i can see by going to database> show sql

but how can i edit this?
LVL 2
meteorelecAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

pssandhuCommented:
The SQL you are looking at is created dynamically by the Crystal Report engine. You will have to know crystal to make the changes you are looking for.
The only place a SQL syntax could have been written would be under the "SQL Expression" under the "Field Explore Menur" on the right. But that might only be part of the whole SQL that you are looking at.
P.
0
jgbreedenCommented:
Do you need an additional field from the database, or are you just changing summaries or calculations?

I'm just wondering if the changes you need actually require changing the SQL, or if you could get your results by working within the groups and formulas on the report.
0
meteorelecAuthor Commented:
hi
he sent me an email before he left saying here is the sql that he used to create the report incase i need to ammend the date range within the report, its a really basic report with just 5 or 6 fields and one parameter passed at the start
as far as i see there are no formulas or stored sql procedures, and the date range isnt set in selection expert,  but i really am a crystal novice so i am proably missing something simple,
0
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

pssandhuCommented:
Run the report with its default values. Then go to Database>database expert
For all the tables listed on the right ( I am guessing it is only one), right click to see if it is SQL Command or not. If it is SQL Command then when you right click yuo should see the option "Edit Command".
P.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
mlmccCommented:
If it isn't a command, you can't changethe SQL directly.

You can change the date range through the SELECT EXPERT under the REPORTS menu.

mlmcc
0
meteorelecAuthor Commented:
cheers pssandhu that done the trick!
 
mal
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.