Yep, for Friday they announce temps up to 35° C...which is horrifically warm
for us, poor Belgians....
No worry, got a cold cellar full of nice wine...and a swimming pool...and
airco at my work...
I will survive......I think....
Grtz
Luc D.
--------------------------------------------------
From: "Wills, Steve" <[email protected]>
Sent: Wednesday, June 30, 2010 8:38 PM
To: "RBASE-L Mailing List" <[email protected]>
Subject: [RBASE-L] - RE: zebra stripes on reports
Are you serious, 32°C? That's gettin' warm. We are having a bit of a
"cool" spell right now; it's only 31°C/88°F right now in Memphis:
http://forecast.weather.gov/MapClick.php?CityName=Memphis&state=TN&site=MEG&textField1=35.1056&textField2=-90.007&e=0.
Stay hydrated and superficially ventilated ... counter-current heat
exchange, right?
Steve
-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Luc
Delcoigne
Sent: Wednesday, June 30, 2010 1:22pm 13:22
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: zebra stripes on reports
Hi Steve,
thanks for the example.
Wouldn't want to get you crazy for all the money in the world...
I need the zebraband to get my quotes for the insurance companies right.
Boring, boring, boring....
Have a nice day in Memphis....
32° C over here in Belgium.
Luc D.
From: Wills, Steve
Sent: Wednesday, June 30, 2010 7:03 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: zebra stripes on reports
Luc, although it might occur to you spontaneously||naturally, it's
possible to "get crazy" with the zebra stripe functionality.
In my volunteer/parent work coaching cross country kids, I developed a
couple of "Top Secret" comparative performance report that changes
zebra-gray color to a school-specific color based on the value of the
SchoolID field in the runners record. What that means, in simple terms
is, when one of my 'SAA' runners appears in the report, the box color is
changed to blue.
Specifically, here's my 'On Before Generate' EEP (with "enhanced"
comments):
--**********************************************************
--*** "WHERE_ARE_OUR_RUNNERS.EEP" **************************
--**********************************************************
--*** On_Before_Generate routine extending ZEBRA-stripes ***
--*** to visually accentuate where our kids finished ***
--*** among all the competitors in a given race. ***
--**********************************************************
--*************************************
--*** ComponentID = rcshp_ZebraBox, ***
--*** defined & located on report. ***
--*** Default color = custom_gray ***
--*************************************
PROPERTY rcshp_ZebraBox BRUSH_COLOR '[R192,G192,B192]'
--*** ZEBRA STRIPE *****************************
--*** vPositionCounter, defined in report, ***
--*** uses stored value of runner's position ***
--*** at finish of race (based on WHERE ... ***
--**********************************************
--*** Is counter variable ODD||EVEN? ***
--**********************************************
IF (MOD(.vPositionCounter,2)) = 1 THEN
--*** Make shape-box visible, i.e. gray ***
PROPERTY rcshp_ZebraBox VISIBLE 'TRUE'
ELSE
--*** Make shape-box invisible, ="white" ***
PROPERTY rcshp_ZebraBox VISIBLE 'FALSE'
ENDIF
--*************************************
--*** WHEN IT'S ONE OF OUR KIDS *******
--*************************************
--*** St. Agnes Girl ******************
IF vNameOfSchoolCD = 'SAA' THEN
--*** Paint shape-box BLUE ***
PROPERTY rcshp_ZebraBox BRUSH_COLOR '[R120,G140,B255]'
PROPERTY rcshp_ZebraBox VISIBLE 'TRUE'
ENDIF
--*** St. Dominic Boy ******************
IF vNameOfSchoolCD = 'SDS' THEN
--*** Paint shape-box PURPLE ***
PROPERTY rcshp_ZebraBox BRUSH_COLOR '[R190,G140,B255]'
PROPERTY rcshp_ZebraBox VISIBLE 'TRUE'
ENDIF
RETURN
Now, all that shown, you might imagine how much "fun" this can be, even to
the point silliness.
I would add that, if such nuance of hue were required in an app'||report,
it would probably be better to define its location in the appropriate
table(s) in the database, store the [RGB] values accordingly, then assign
them to a (report) variable as needed. (Obviously, I don't always
practice what I preach ...)
HTH,
Steve in Memphis
From: [email protected] [mailto:[email protected]] On Behalf Of Luc
Delcoigne
Sent: Wednesday, June 30, 2010 9:14am 09:14
To: RBASE-L Mailing List
Subject: [RBASE-L] - zebra stripes on reports
HI,
i have a report and I want to print the detail lines with a "zebra" stripe
pattern, in a color of my choice.
How to do this is obvious for forms, but I haven't sorted out yet how to
do this on a report.
I suppose it will also be something simple......
Any help would be welcome...
Luc delcoigne
