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 groupbyjoins and where clause.How will I do it.Also how to find the grand total in crystal report.

Marimuthu Arigovindasamy · Answer

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.