I have a report that prints records in groups according to the table from which they are queried. I do not use the data environment of the report. I have a stored procedure that prepares a "reportcursor." This procedure is made up of several SQL statements to select the top 10 results from each of the tables I query for this report. I have all fields AND Group Labels "layered" in the detail band of my report. My procedure adds several parameters to each record, enabling me to use "Print When" commands to properly space out each group. This report works nicely.

Each group prints 10 years of test results that my client reports on. They need to have a modified version of this report that prints the most recent 8 or 9 years of data, leaving a blank line where the 10th year would be so their technicians can hand write this year's result.

I would like to use the same report layout and "reportcursor" that I prepare for the original report. I already have a parameter that marks the last record of each group. I figure if I could alter the font color for this one record when they select the "Field Report" as I will call it, from my Report Selection screen, that would allow the report formatting and spacing to print out as normal, with the exception of the last record being printed in white, or should I say blank. Is there a way to alter report formatting items on the fly such as font color according to some global variable?

Am I thinking correctly on this? Or should I be trying to insert a blank line in my actual report layout? Can that be done on the fly?