1. Categories >> Software >> Microsoft Related >> Crystal Reports
  2. Suggest New Category

Can we use our own SQL for creating a report?

Question Posted / guest

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 do you format your crystal reports so that on exporting to word doc or pdf it will not lose the orginal format

3 Answers   Target,

how should i highlight a particular column in a report in actuate e designer report? It should be done dynamically while creating report Thanks in advance!!!!!!!!!!

0 Answers  

hi... i've two crystal reports one is in D: drive name employee.rpt with 5 textobject and another report is in E: drive name employee.rpt with 15 textobject... now i want to write a program to overwrite the D drives report with E drives reports i.e i want to replace the 5 textobject with 15 textobject.. overwriting the reports while it is executing .. is there any code for it please help me.. its urgent..

1 Answers  

What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions)?

1 Answers  

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

3 Answers  

Can we create report using more than one database?

3 Answers   CSC, Seed Infotech, Target,

How do we format field?

4 Answers  

How to print two details fields at the bottom of the page

5 Answers  

HI all, I am developing reports using crystal reports in VS2005 in windows application. I have two crystalreports name called "studentReport" and "familyReport". I have a form with a button. If I click the button I need to show up the two reports in one report like page1, and page2. The page1 consists the "studentReport" and the page2 contains the "familyReport". The "familyReport" contains different header and footer. How to show up the two crystal reports in single crystalreportviewer?

2 Answers  

Where can we find the log file generated when we run a crystal report?

1 Answers  

I had an Interview yesterday for a Crystal Reports Developer position. Some of these I have not done in my reporting experience and I had just a half day's notice for the interview, hence no prep time :-( 1) Is there a way to be able to change an image(company logo) dynamically in a report? Example if you have 100 reports, and with the market uncertainity if you anticipate that the company logo might change, how can you change the image just in one place and have this reflected in all teh reports at run time? 2) What is a SQL expression? 3) What are field expressions and what are the diff types? (I looked this up in the internet and never found anything with regards to types of field expressions) The interviewer really got me confused as I felt he was not clearly setting forth his questions but it could be that I was unable to understand his wording of the questions. I expect a big zero from his feedback but I am hoping this is an experience for future interviews that I face in crystal reports when I do get some more lined up. Thanks in advance! Anita New Jersey, USA.

5 Answers   Barclays,

How do you add a subreport to a report in Crystal Reports?

1 Answers   MindCracker,

For more Crystal Reports Interview Questions Click Here
Categories