21⟩ What are the sections that we have in Crystal reports?
Report Header, Page Header,Detail section,Report Footer,
Page Footer.
Crystal Enterprise Suite
Home Data Warehouse Crystal Enterprise Suite
“Crystal Enterprise Suite frequently Asked Questions in various Crystal Enterprise Suite job Interviews by interviewer. Get preparation of Crystal Enterprise Suite job interview”
27 Crystal Enterprise Suite Questions And Answers
22⟩ 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.
23⟩ 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.
24⟩ 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.
25⟩ 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.
26⟩ 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
formula.
27⟩ 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.
