Crystal report is a window based report writer that enables the programmer to make reports from different data sources with a minimum of written code. Crystal report can access data from various data-bases and can synchronize data from multiple databases into a single report.
To connect crystal report to the databases, there are two ways
Yes, it is possible to create your own formulas in Crystal reports. For that from insert menu item choose “Formula Field”. Write the formula in “Formula Editor”, here you will see “Function Tree” , “Field Tree” , “Operator Tree” which will show the report fields, functions supported by crystal reports, operators etc.
For more information, click the link below.