Help with creating a "Banded" report.

[Darrick]

I'm trying to create a banded report. I can't use the record number in my formula to "band" every other record. I'm not using every other record. I'm using the Group header to display my information and sometimes the record number is 1 number different or several thousands records differnt. It's already a very complex report, at least for me, but it is using subreports and all sorts of stuff.

If someone has any suggestions on how to make every other record "banded", but based off of the displayed records only I would appericate it!

Please help,

Darrick
darrick3@yahoo.com

 

[DjangMan]

* Off the top of my head warning *
You might try using a formula with a variable:

whileprintingrecords;
global BooleanVar PlainLine;
PlainLine := not(PlainLine);

Place that formula in your section that prints (you might have to conditionally suppress this formula too).

Then conditionally set the color of the section based on the value of PlainLine:

whileprintingrecords;
global BooleanVar PlainLine;
if PlainLine then color (255, 255, 255) else color (235, 235, 235);

DjangMan

 

[Ngolem]

Put a formula into the detail line that covers the area that you want shaded and set the shaded color to a customized light grey tone (visible but not overpowering)

the formula, @banded is simply a line counter but doesn't display anything

whilePrintingRecords;
numberVar linecounter;

if onFirstRecord then Linecounter := 0;

Linecounter := Linecounter + 1;

" "; /added to display nothing

in the conditional supress for this formula put the formula

WhilePrintingRecords;
numberVar linecounter;
remainder(linecounter,2) = 0;


that shud work ... I am not sure if this would work but you might add under WhilePrintingRecords the line

evaluateAfter({@banded })