How to loop query with given parameters in Birt Report

Question

I Have made a report in birt. The dataset of the report containing the query which contains many where conditions using a Startdate parameter. I have made two parameters Startdate and Enddate. I want to loop that parameter from a Startdate parameter to Enddate parameter.

I want to run a single query with different parameter eveytime, Starting from Startdate till enddate

Answer 1

This can be done through beforeOpen Script of the data Set.