Re: Using different background colors with rows

I hope you don't mean me by idiot :-)

I tried this in the group footer, but when I check the code for errors, it
says 'a field is required here'.
The first 'colour_on' is selected in the second line of the formula, when
the error appears in the screen.

Am I missing something?

Alison



"Iain" <iains@xxxxxxxxxxxx> wrote in message
news:436b2fc1$0$82633$ed2619ec@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Okay, idiot question time :-.
>
> Do you wish the yellow,white switch to include the group lines as well as
> the detail ones?
>
> If so, in both the group and detail background formula do this.
>
> 1. Switch them to Basic Syntax
> 2. Replace the code with the following.
>
> shared colour_on as Boolean
> if(isnull(colour_on) or colour_on = false)then
> formula=crYellow
> colour_on=true
> else
> formula=crWhite
> colour_on=false
> end if
>
>
> If the colour switch should be different for detail and group
> (white/yellow for detail, green/blue for group) then do the same, but
> change the name of the switch variable in the group section.
>
> regards,
>
> Iain
>
> "Alison Givens" <info@xxxxxxxxxxx> wrote in message
> news:u%23xd%23sF4FHA.1420@xxxxxxxxxxxxxxxxxxxxxxx
>>I am not suppressing anything in the details section. I have only selected
>>the 'keep together'.
>>
>> Can you elaborate a bit on your solution for the group?
>> I am kind of new in programming.
>>
>> "Iain" <iains@xxxxxxxxxxxx> wrote in message
>> news:436887bb$0$82662$ed2619ec@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
>>> Are you suppressing the details section at all (rather than using record
>>> selection formula)? The suppressed ones will 'count' towards the
>>> formula.
>>>
>>> As for the group one, The only thing I can suggest is to use shared
>>> variables to count or switch on/off the colours.
>>>
>>> Regards,
>>>
>>> Iain
>>>
>>>
>>> "Alison Givens" <info@xxxxxxxxxxx> wrote in message
>>> news:uCx6ZU43FHA.4076@xxxxxxxxxxxxxxxxxxxxxxx
>>>> Now I get a real strange effect.
>>>> In the details section:
>>>> Sometimes, I get the right solotion, row white, row yellow etc.
>>>> But, with some rows I get two yellow rows after eachother and a few
>>>> corret
>>>> ones and then a few white ones.
>>>>
>>>> In the group footer#1 I use the same code:
>>>> Only the first row has a yellow color.
>>>>
>>>> Alison.
>>>>
>>>>
>>>>
>>>> "Briscobar" <youcant@xxxxxxxxxxxxxx> wrote in message
>>>> news:uyOCfaw3FHA.1148@xxxxxxxxxxxxxxxxxxxxxxx
>>>>> Alison Givens <info@xxxxxxxxxxx> rambled:
>>>>>>
>>>>>> I made the formula in Basic Syntax and is like this.
>>>>>> I only want two colours used.
>>>>>>
>>>>>> select case Recordnumber mod 2
>>>>>> case 0
>>>>>> crWhite
>>>>>> case 1
>>>>>> crYellow
>>>>>> end select
>>>>>>
>>>>>> When I check the syntax of the formula, I get this message:
>>>>>> "The special variable 'Formula' must be assigned a value within the
>>>>>> formula"
>>>>>>
>>>>>> What is wrong here?
>>>>>
>>>>> Your Crystal Syntax is wrong here. Try this:
>>>>>
>>>>> select Recordnumber mod 2
>>>>> case 0: crWhite
>>>>> case 1: crYellow
>>>>> default: crWhite //this line is optional
>>>>>
>>>>>
>>>>> --
>>>>> KB
>>>>>
>>>>> MCNGP #26
>>>>> If you don't hightail it over to www.mcngp.com, your job will be
>>>>> outsourced.
>>>>>
>>>>>
>>>>
>>>>
>>>
>>>
>>
>>
>
>


.

Relevant Pages

  • Re: Text selection stops working
    ... I can switch applications while using word and the mouse works fine ... Safe Mode is like heaven, but Normal Mode is the same problem. ... I did just what you told me, delete DATA key, restarted word, DATA key ... The problem of text selection with mouse, ...
    (microsoft.public.word.application.errors)
  • Re: Unable to modify word Options
    ... limited to bad settings in the Toolbars value, and the toolbar settings have to ... My point is just that one should not continue to use the /a switch for starting ... I need to update the 'Add-Ins' selection ...
    (microsoft.public.word.application.errors)
  • Re: My Indiana Jones just died!
    ... I wouldn't call you an idiot. ... Many years ago when RCA had in home TV repair, ... They might have "nudged" the plug out of the back of the machine... ... I assumed the switch broke so I started to tear it apart. ...
    (rec.games.pinball)
  • Re: LVN_ITEMCHANGING, how can I get it to cancel the change?
    ... switch (uMsg) ... The selection still got changed to the new selection. ... I want the focus to be back to the original state and cancel the changing ...
    (microsoft.public.win32.programmer.ole)
  • Re: S1 sound?
    ... and my most-used sound is the one I get ... I stick the PU selector switch midway between the 4th and 5th ... not use that 'unused' 10th selection to have bridge and neck together. ...
    (alt.guitar)