The scenario: We are creating a project update report which shows all tasks and tickets related to a project. We want to be able to select on a row by row basis which tasks/tickets/etc we show to the client.
So an admin would search for a project, see the complete search results, preferably with each row "checked" to be included on the client report. The admin would then uncheck anything they wanted to hide from the client report and once they were ready, hit the "Client report" button which would take them to another report layout, displaying only the selected rows.
Since we aren't wanting to modify the originating datasource (mysql databases), I'm wondering if there's a way to add record level variables to the Koolreport datastore? And to have them also be session specific since we may end up with multiple admins running reports at the same time eventually.
Any pointers appreciated.
Thanks, Rooze