Retrieval of 3 Consecutive Months Data in WebI 3.1
We have a requirement where data is retrieved from SQL Server DB. I need to develop a report based on 3 consecutive months data. The report is basically of Stud name,Marks and months. I need to retrieve the data for 3 consecutive months based on marks. If marks are greater than 90 for consecutively 3 months then need to display the stud names. I have tried using Running sum but no luck. Appreciate your help.