We are currently developing reports in Jaspersoft Studio. We have created for example a project highlight report and we added a couple of input controls like project manager, project, OBS etc.
Al these input controls have a sql to retrieve the information. In SQL developer execution of every query is milli seconds so far so good.
But when we try to open the report and it is building his options filter it is taking for ever. Anyone experience or best practice?