2 pass report

[rste]

Here's the problem:

User runs a report which results in ~100 rows w/ sub-totals & totals etc rendered as a nice pretty & portable pdf.  So far, so good.  Now they want to remove a few lines (for various business reasons) from this particular run of the report.  Can't efficiently be done in pdf.

Here's the work-around:

User get's the report output as MS-Excel and then "cleans" the data and the prints to pdf from Excel.

Here's my proposed solution:

2 "coordinated" reports.  report 1 renders the 100 lines in an html table with checkboxes on each line.  the user then checks the lines to be redacted and submits the form.  a custom servlet stores the IDs of the lines to remove and then returns the results of report 2 which is the report we use now set up to ignore the redacted data.

I suppose on a subsequent run of report 1, it would automatically check lines which had been checked in a previous run.

Make sense?  Possible?  better way?

Thanks