how to find grand total in crytsal report and how to run a complex query in crystal report

Question

Can anyone tell me if I want to show data in crystal report using complex query with groupby,joins and where clause.How will I do it.Also how to find the grand total in crystal report.

Answer 1

1. Create new connection
2. Add command and select > icon from Databse expert window
3. Type ur query and click OK.
4. Drag and drop the fields from the database fields.
 
To show summary of Amount field:
Right click the Amount field from details section
Insert --> Summary (Select Grand total) and then click OK.