We cannot edit the SQL made by crystal reports. However we can view the SQL. For that select ‘Show SQL Query’ in Database menu item. Limitation is if you are using only one database. If you use two databases then you can’t even view the SQL prepared by crystal report.

 There are certain limitations in crystal reports. They are: -
 1. If database is having field whose length is more than 255 characters, then you cannot make formula using that field.
 2. While exporting data formatting is lost.
 3. When you browse data just by right clicking on the field then it displays that is there in the database not the data selected by the query.

 Yes, we can suppress printing if no records are fetched. Select ‘Report Options’ in File menu item. ‘Report Options’ dialog box will pop up. In that there is one option ‘ Suppress printing if no records’ Check this option. If no records are found then nothing will be printed on the report.

 Report has got standard sections like ‘Page Header’, ‘Page Footer’, ‘Report Header’, ‘Report Footer’, and ‘Details’.
However you can add other sections also. Select ‘Sections’ in the Insert menu item. You can insert group sections also.
If you don’t want to show any section just right click on that section and suppress that.

 Yes, we can add any database field afterwards also. Select ‘Database Field’ in Insert menu item.
If you are using crystal report built in query then it will display the tables that you have selected. And you can select whichever field you want to display on the report.
But if you are using ‘.qry’ file then it will display Query and you can select only those field, which are there in the query.

 No, Crystal report does not support all the functions. Like Decode function is there in SQL but not there is crystal report. You need to convert that in crystal report format (in if and else etc.).
However if you use ‘.qry’ files then it take the SQL as such. There is no need of changing any syntax.

 Yes, we can use stored procedure.

 Crystal reports provide features like grand total, sub-total, running total etc. You can select any of these features in Insert menu item.
You can sum up records on the basis of each record or on change of group using ‘Running Total ‘ option in Insert menu item.

 If you are getting such an error then click the icon for ‘Report Expert’. It will give a warning saying that formatting will be lost. Ignore this you will get ‘Standard Report Expert’ dialog box. Reverse the links of access database table and it will work.