How to hide ColumnFooterBand for reports with 2 columns

rbuser

Hi guys,

I've got sub-report layout like this:


Column1 Column2
1
2
3
4
.....
Summary in ColumnFooterBand


So, if number of records > 4, then it starts to print in the second column.
I put some sum filelds in column footer band.

It works fine, but it displays summary in both column footer bands. I need
to get it working in the following way:
if the number of records<=4 then show columnfooterband1 anf hide
columnfooterband2;
if the number of records>4 and report continues to print in the second
column then hide columnfooterband1 anf display columnfooterband2;

How to do that ?

Cheers,
Dmitry

nardmoseley

Perhaps in the ColumnFooter.BeforePrint event check something like:

if (Report.CurrentColumn = 1) and not (Report.DataPipeline.Eof) then
{set components to not visible}
else
{set components to visible}



--
Nard Moseley
Digital Metaphors Corporation
http://www.digital-metaphors.com