Solved

how do i edit the sql in crystal reports 11

Posted on 2009-07-02
6
424 Views
Last Modified: 2012-05-07
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?
0
Comment
Question by:meteorelec
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 17

Expert Comment

by:pssandhu
ID: 24764106
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
 
LVL 5

Expert Comment

by:jgbreeden
ID: 24764558
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
 
LVL 2

Author Comment

by:meteorelec
ID: 24765010
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
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

 
LVL 17

Accepted Solution

by:
pssandhu earned 500 total points
ID: 24765628
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 24765985
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
 
LVL 2

Author Comment

by:meteorelec
ID: 24770658
cheers pssandhu that done the trick!
 
mal
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
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 …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
Suggested Courses

738 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