Hi Jimmy,
I want to execute the report in sql.
can u please guide me.
Thanks
Vinoth
Hi Vinoth,
This report will need data from the JEs so you will need a join with JDT1.
The grouping by Month/Qtr/Year will be achievable depends on where the report will be run, in B1 using query report, in a Crystal report or in Excel.
For Crystal report or Excel, it's relatively easy to use a pivot table format and have the numbers grouped by the dates. If it's required to run as a query report, then you may use some PIVOT statement in your SQL script.
Cheers,
Jimmy
Add comment