Can I Edit the SQL Query in Crystal Report 9?

Hi,
Can I Edit the SQL Query in Crystal Report 9?
i just can see the SQL query at "Database"->"Show SQL Query". How do I edit it in Crystal Report?
thank you.In "Database"->"Database Expert".
Edit the command directly if you have a command, or a graphically if you have a list of tables and joins.|||In the "Database"->"Database Expert", i only see 2 tabs which are "Data" & "Links" (both are graphical).

i cannot see any "Edit" or the command.

BTW my CR version is 9.2.|||What exactly do you want to edit about the 'query'?
You add/remove tables in the Data tab, and change the joins in the Link tab - i.e. you do it graphically and the SQL query Crystal runs is altered appropriately.
You add data restrictions (where clause) in the Record Selection formula (Report menu, Selection Formulas, Record)|||Actually... I want to sort out and display the latest transaction to my report.

eg:
In my table:
Item CustOrder Price
A C1 1.90
A C1 2.10
A C1 2.00
B C8 33.90
B C8 32.00

In my report show:
Item CustOrder Price
A C1 2.00
B C8 32.00

So initially i want to use SQL Statement "Group By" clause to sort it out and display, but later i found it got some problem / the record displayed is not correct.

any idea? or what can i do?

thank you.|||Then your SQL is fine; you want to use the Group Expert to group on the column that contains the 'A', 'B' etc. values and then the column for the 'C1', 'C8' etc. values. You might then want to use the Record Sort Expert to order the records within these groups (e.g. is there a timestamp to order them in 1.90, 2.10, 2.00 order?) and display the row you want in the group footer (i.e. suppress the detail).

can i convert Crystal Reports to SRS 2005?

Hello,
Is it any way can i convert Crystal
Reports to SRS 2005? The data source in the Crystal
Reports I am using views from SQL Server 2000.http://msdn2.microsoft.com/en-us/library/aa964127(sql.90).aspx
Reeves
"GGill" wrote:
> Hello,
> Is it any way can i convert Crystal
> Reports to SRS 2005? The data source in the Crystal
> Reports I am using views from SQL Server 2000.
>|||Thanks.
"Reeves Smith" wrote:
> http://msdn2.microsoft.com/en-us/library/aa964127(sql.90).aspx
> Reeves
> "GGill" wrote:
> > Hello,
> > Is it any way can i convert Crystal
> > Reports to SRS 2005? The data source in the Crystal
> > Reports I am using views from SQL Server 2000.
> >

Can i add SQL statement to Parameter Fields?

Hi,
I am new to Crystal Reports. May i know can i add SQL statement to parameter fields under setting default values?
WillyYes, you can add SQL statement, but the statement, is a litlle diferent... not much.
Menu -> Report -> Select Expert ->
Click Show formula >>> then hit the button Formula editor...

Hi,

I am new to Crystal Reports. May i know can i add SQL statement to parameter fields under setting default values?

Willy|||Thanks a lot

Can I add records to or delete them from an sql database throught Crystal Report

Hello. I would like to know if its possible to add records to an sql database field or delete from it through Crystal Reports? Basically, I wish to setup a html fill in form configured to crystal reports whereby I can pull out results and then if required I could add or delete any record.

Is this possible?

Please help.I dont think it is possible in CR
See if you find solution here
www.businessobjects.com|||Hello, Madhi. Thank you for your reply to my question (and any other questions I posted on the forum). I have found a way I can add and delete records from crystal reports to an sql database using sql commands and crystal formulas (via the business objects website). But its all very basic stuff as yet - good stuff, nevertheless.

I will look begin to look further into this. Thank you for you help.

Regards
Saf|||saf,
if you can please walk me throught how did you get it from that website. There is no forums or anything right? Thanks|||Here is the link for the Business Objects tutorial that I followed:

http://support.businessobjects.com/library/kbase/articles/c2011950.asp

It works. Please follow up on the link.

Can Grow function

Hi folks,

I am a beginner in Crystal report, I have tried to use the Can Grow function and it work fine. But will anyone know how to make/trigger other fields to grow together to the same height when particular field is grown? or is there any function to change the height on the field via formula?

Many thanks,
HaroldI am having the same issue - Did you happen to figure this out?

Can Grow crystal report option - does not grow.

Hi.

I am connecting my report file to the domino server. I have a string in the crystal report which is mapped to a text field. the "Can Grow" option is checked but still this string on the report is truncating the data after some 240+ characters.

Any of you have any idea? Your help would be highly appreciatedCheck whether the field has any junk data|||Hi Madhi.

Thanks for your reply. I have checked that there is no junk data in the field...its all simple text...but still the field does not display all of my data in the report. Any idea?.

thanks again for your help.|||Did you try to expand the filed?|||Yes. I expanded the field width. My field is available in the Details Section. I have increased the width but still the complete information does not show up and blank space is displayed from the point the information is truncated.