1. Is there any feature like summing total in crystal report?

Yes, There are options in crystal reports for summing up
the records. You can sum the records by group , or by grand
total. There is also another feature for summing up
is "Running Total". You can just insert running totals, or
summaries by just using the icons or you can write your own

2. What is caching? What are the different types of caching?

I don't know how this question can be answered interms of
crystal enviroment. Anyhow I know somethig abt caching,
There are many servers comes along with your CRS suite, BO,
or Crystal Enterprise suite.
All these servers run behind crystal reports to run and
publish the reports successfully. Maintaining all these
servers is kind of amin job.
Below are the list of servers that work together to make
Crystal reports a successfull pack:
1) Input server(File repository Server)
2)Output server(File Repository Server)
3) Cache server
4) destination job server
5) event server
6)list of values job server
7) page server
8)program job server
9) RAS(Reports Application Server)
10)report job server
11)CMS(Central Management Server)

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

No its not supporting all the functionalities or oracle
like triggers, cursors etc.

4. Can we use stored procedure for creating the report?

Yes we can use stored procedure for creating the report
with the help of Add commoand.

5. Can we add any database field once we have chosen Close button?

Yes, go to the main menu on the top of the window..--
>Database-->database expert..through this you can add any
d/b fileds.

6. What are the sections that we have in Crystal reports?

Report Header, Page Header,Detail section,Report Footer,
Page Footer.

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

We can use our own sql by add command funtion in to the
crystal reports.

8. Can we create report using more than one database?

We can create the report but we must having the primary
key for both the database, otherwise it fails to create the
smart linking between two database.
Generally using more than one link is not supported.

9. Can we export data of reports into other format like in world doc etc?

We can export the data in Word doc. Adobe Acrobat,
HTML,Excel,Rich Text format,XML.

10. How do we format field?
How do we connect to the database?

Go to Field explorer-right click on any of the filed
like formula field,Database field,special fields,Formula
field, running total field etc.

Using Database expert-->Current connection-->OLEDB
Connections-->Microsoft OLEDB SQL SERVER OR choose whatever
the database like oracle,sql server,sybase..etc..
-->will get another window with server info.address. and
login information.

Download Interview PDF