Reports module error for dropdown values in Sugar 8.0 version


I have Sugar 8.0.2 Enterprise Edition.

I have created report for opportunities module , and I used sales stage in group by statement, when I try to run the report it is showing database failure error check in sugar log.
I have checked in sugar log and it is showing 

sales stage which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by.


Then I tried creating report with any of the dropdown fields iin group by statement, and it is throwing the same error which I have mentioned in the above.


for dropdown values if use group by statement in reports it is throwing data base failure error.


Is anyone facing this issue?? ,is it a  bug in sugar 8.0  or mysql 5.7 change ?