Can we use our own SQL for creating a report?

Categories >> Software >> Microsoft Related >> Crystal Reports
Suggest New Category

Question Posted / guest

5 Answers
15002 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can we use our own SQL for creating a report?..

Answer / mlmcc

The Crystal Designer tool was dropped in Crystal 9.
Crystal replaced it with an option to build a Crystal
Command as the data source. You can build any valid SQL in
the command feature.

Is This Answer Correct ?

5 Yes

1 No

Can we use our own SQL for creating a report?..

Answer / rahul

We can also make our own query using Crystal SQL Designer
tool provided by SQL. Here you can insert your SQL
statement as such. It will save this file as .qry . And
when you create a report instead of using Database button
use Crystal SQL Statement button.

Is This Answer Correct ?

4 Yes

1 No

Can we use our own SQL for creating a report?..

Answer / vijay yadav

Yes we can use our SQL query, when developer select the
table or the procedure name for create the report so at the
place of them select Add Command and than a editor will
display so there you can add ur query.

Is This Answer Correct ?

2 Yes

1 No

Can we use our own SQL for creating a report?..

Answer / abhishek

Dear frnds,

I have one doubt...
am using sql server 2005..
in this i restored two databases..(A & B)
in the both dbs have same sql query's...
but the the result is different...result format is same...
EX in both EMPID,EMPNAME
a sp result 1 abhi
and
b sp result 2 ravi

in the crystal reports i want to show both results in one
report...
i dont know how to do this....

plz send how can i get the result in one report...

basg.004@gmail.com

Is This Answer Correct ?

1 Yes

0 No

Can we use our own SQL for creating a report?..

Answer / arvind gupta

Yes, Using Crystal SQL writer

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More Crystal Reports Interview Questions

How many sections are there in the report

6 Answers

How can we improve the performance of a crystal report?

0 Answers

Does Crystal Report support all the functions that we have in Oracle?

2 Answers MPS Techologies, Target,

How to access crystal reports in .net?

0 Answers

How to Filter the Crystal reports?

12 Answers CCIL, Mammut Building Systems,

Explain basic steps required to display a simple report in crystal?

0 Answers

HOW TO USE 5 CRYSTAL REPORT OR SUBREPORT ON DIFFERENT CONDITIONS IN ONE VB PROGRAM

1 Answers

How to write a formula to change a font based upon data ?

2 Answers

Can we use Crystal report as a stand-alone application?

4 Answers Covansys,

to ensure that all of the data from a field is displayed in a report text object you should do which of the following?? a) use the format wizard b) size the text object manually c) select the auto format option for the text object d) select the can grow option for the text object e) set the can grow option to the details section of the report

2 Answers

What does it mean when we get the error message "Invalid report version" when try to open a Crystal Report?

3 Answers

How to refresh the crystal report from the application ?

6 Answers Satyam,

For more Crystal Reports Interview Questions Click Here