how to find grand total in crytsal report and how to run a complex query in crystal report
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.
Marimuthu ArigovindasamyPosted Jun 28, 2010, 2:15 AM
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.