[AccessD] Reports - Conditional formatting question

Bruce Bruen bbruen at unwired.com.au
Wed Mar 28 07:32:18 CDT 2007


1)  This is driving me beserque!!!
2)  It was a short trip.

In band X I have a text field (numeric).
Its' background style, like all the others in the band, is transparent.

If its' value is in error, i.e. value=0, then I want to set its' background 
colour to vbBloodyBrightRed!
If its' not in error then I want to leave its' background transparent.

These seem to be incompatible.  If I change one the the other changes for the 
rest of the report, viz: if I impose conditional formatting then the rest of 
the report gets a bright white background,  if I set the backgraound 
transparent then the condition dissappears.

BTW: I have tried setting the formatting in both the design and via code.

Ooooh.  

It would be really nice to be able to set the LABEL background at the same 
time.


BTW, the field is a dCount value if that's any more information.  Basically, 
its a test coverage report, we have 1.4 gazillion use cases each having 0..* 
active test cases.  ->

	Report
		for each use case in schedule
			"display" [UC].[details] & Count([UC].[activetestcases])
		next
	end

So out of 300 odd test cases it's a bit hard to see the ones we've missed.
The band fields are transparent because...
we also want to highlight bands that are relevant vs ones that aren't.  (So 
the band background is shaded 5% for the ones that aren't, and by 
GeeWillikers that works goodbut.

Any ideas?  Any previous infuriation?  Any bar?  

Final BTW: AXP

-- 
regards

Bruce



More information about the AccessD mailing list