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
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)
No its not supporting all the functionalities or oracle
like triggers, cursors etc.
Yes we can use stored procedure for creating the report
with the help of Add commoand.
Yes, go to the main menu on the top of the window..--
>Database-->database expert..through this you can add any
Report Header, Page Header,Detail section,Report Footer,
We can use our own sql by add command funtion in to the
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.
We can export the data in Word doc. Adobe Acrobat,
HTML,Excel,Rich Text format,XML.
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