we are having a data of 10 records with 4 columns in which one column has integer and another column as average which is empty.
How to fetch the report by calculating the average column and then filter it with average >50
"you can achieve this using combination of SQL Function and Sub Report.
Report 1- Add Columns as ID, English, Hindi, Science and another column in which use SQL function to get the average of English, Hindi &Science row.).
In Report 2 , use report 1 as sub report, and fetch average value from sub report in main report and put filter condition as > 50"
Use a sub-report to calculate the total and in the main report calculate the average. Along with the filter use function alias for calculating sum and average. Thanks