I need to be able to show a tax form, but with certain amounts redacted. Is there a way, with any of the reporting tools in koolreport pro, to blank out specific amounts. for example

wage QREs                     xxxxx
contract QREs                 xxxxx
total QREs                     $  xxxx
3 previous years QREs$   xxxx
line 5 divided by line 21 $  xxxx

total credit                        $12,000

In my example, all of the x'x are redacted and i am just showing the total credit. Is there any type of pro report that would work for this?

This is what i want to end up with. An Excel would be fine. How should "stage" the data so that it can be easily put into this format? I have all of the data already in datatables which I am already running reports from. Should I be "grabbing" the "totals" from the bottom of each report? How to do this?

For example, I want to grab the Total Qualified Wages amount and stick it in F2. How do I grab these results? and put them into the spreadsheet?

Thx. I want to also grab the total amounts from a previously rendered report so I can stick them into an excel sheet. Suggestion on how to do that? Or should I be running a brand new sql statement, each time?

works well! thanks