This is a basic sub summary report with no body part. There are many examples in the Starter Solutions that show the layouts for these reports, and the scripts associated with them. Look at the Invoices Starter Solution. There's probably a quarterly report for sales.
Also, the FileMaker Training Series (v12) has a section showing how to create a cross tab report showing sales figures by quarters
Can we do this using scripts with ExecuteSQL command?
ExecuteSQL is a function. It's used in calculations and the results of its query is returned to that one single field.
There's a script step with nearly the same name, but it's used to push data to an ODBC data source.
Use a summary report. It's simpler to set up.
Here's a tutorial on summary reports: Creating Filemaker Pro summary reports--Tutorial
Thanks for the help.
I have added summary field with count of suppose "field A". It shows proper count.
But now I want count of "field A" but with only unique values. Can you please provide possible way for this.