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