Re: Using different background colors with rows

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: "Briscobar" <youcant@xxxxxxxxxxxxxx>
Date: Tue, 1 Nov 2005 12:07:40 -0500

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.

.

Follow-Ups:
- Re: Using different background colors with rows
  - From: Alison Givens

References:
- Re: Using different background colors with rows
  - From: Alison Givens

Prev by Date: Re: Setting Parameter to NULL in CR 10 ?
Next by Date: Re: Crystal not returning any data
Previous by thread: Re: Using different background colors with rows
Next by thread: Re: Using different background colors with rows
Index(es):
- Date
- Thread

Relevant Pages

Re: Using different background colors with rows
... Sometimes, I get the right solotion, row white, row yellow etc. ... >> I made the formula in Basic Syntax and is like this. ... > case 0: crWhite ... > case 1: crYellow ...
(microsoft.public.vb.crystal)
Re: Using different background colors with rows
... Are you suppressing the details section at all (rather than using record ... >>> select case Recordnumber mod 2 ... >> case 0: crWhite ... >> case 1: crYellow ...
(microsoft.public.vb.crystal)