Green Lines Report

[pchelper1]

Moved from A5. I had been using this trick to create green line reports..
If(INT(mrecno()/2=memrecno()/2,"White on Cyan","")
It works on and looks good on print preview but the print out is a mess of heavy color on all lines is this Alpha or the printer ?

JIm

[Stan Mathews]

Re: Green Lines Report

Why not try

If(INT(mrecno()/2=memrecno()/2,"White on Black","")

or similar to see if you get different results?

[G Gabriel]

Re: Green Lines Report

Something oddly wrong with this expression:
If(INT(mrecno()/2=memrecno()/2,"White on Cyan","")

Did you mean:
If(INT(mrecno()/2)=memrecno()/2,"White on Cyan","") ?

And if so, and though not directly responsive to your question, isn't the same as:
If(mrecno()/2=memrecno()/2,"White on Cyan","")

which is also the same as:

If(mrecno()=memrecno(),"White on Cyan","")

And who is memrecno() anyway? A UDF?

[jaryder]

Re: Green Lines Report

Gabe,

What I think he meant was:

If(INT(mrecno()/2)=mrecno()/2,"White on Cyan","")

And that is not the same as:

If(mrecno()/2=mrecno()/2,"White on Cyan","")

By using the INT() command even results from mrecno() will be true and odd results from mrecno() be false.

int(4/2) = 2 and (4/2) =2

int(5/2) = 2 and (5/2) = 2.5

[jaryder]

Re: Green Lines Report

You could also do:

If(mod(mrecno(),2)=0,"White on Cyan","")

Result will be 0 for even numbers and 1 for odd numbers.

[G Gabriel]

Re: Green Lines Report

Yes Jeff, but:
int(5/2) will have the same outcome as int(4/2), both will yield 2.
Which make me believe he is not testing for odd and even but rather something else that has to do with the outcome of a UDF, the memrecno().
If you are testing for odd and even, you need to use mod() not int().

[jaryder]

Re: Green Lines Report

Gabe,

I have used int() for years on a language that did not have a mod() command for determining even/odd and it works just fine.

if int(a/2) = (a/2) then
     // even code 
  else
    // odd code
end if

[G Gabriel]

Re: Green Lines Report

Gabe,

I have used int() for years on a language that did not have a mod() command for determining even/odd and it works just fine.

if int(a/2) = (a/2) then
     // even code 
  else
    // odd code
end if

Nothing wrong with that.

[G Gabriel]

Re: Green Lines Report

Gabe,

I have used int() for years on a language that did not have a mod() command for determining even/odd and it works just fine.

if int(a/2) = (a/2) then
     // even code 
  else
    // odd code
end if

Nothing wrong with that except the original question says:
INT(mrecno()/2=memrecno()/2
Perhaps a typo.

[jaryder]

Re: Green Lines Report

Nothing wrong with that except the original question says:
INT(mrecno()/2=memrecno()/2
Perhaps a typo.

Agreed.

[G Gabriel]

Re: Green Lines Report

And a nit-picking mathmatician-programmer (not me) will tell you:
in an expression like:
If (int(mrecno()/2)=mrecno()/2) you are using 2 evaluations, while in:
if(mod(mrecno(),2=0) you are using only one!
The difference would be just about enough to buy a hot dog or a burger!

[pchelper1]

Re: Green Lines Report

Yes you guys found the fat thumb typo, Your assumtions on the correct "mrecno" are correct. I know it is not the printer. It printed this perfectly from V5. V9 shows it in the print preview pane absolutely correctly...It just does not print it the way it is displayed. Evidently V9 just does'nt like to print this type of green lines preview. I have tried several different definitions for the expression (none worked)

Jim

[G Gabriel]

Re: Green Lines Report

I doubt it's alpha. Most likely the printer. Try a different printer.
The expression, lacking the typos, is fine. (I prefer mod for simplicity but tha's not a big deal really).You must have changed printers since it worked last. Also Cyan is a heavy color, you might want to choose a lighter one.

[pchelper1]

Re: Green Lines Report

Just to finish this up.. The printer I am using is the same printer that I was using on V5. To prove it is V9 I moved a database from V5 to V9 and guess what ? It worked perfectly to my printer. I think it has to do with the way V9 sets up the color types .. i.e. solid, etc.. It gives you no way to set a fill pattern that works.

Jim

[pchelper1]

Re: Green Lines Report

No Green Line Reports Can Be Set Up In V9..however If You Bring The Database From V5 It Is The Only Way To Do It. I Guess I Have To Live With This..not Being Able To Do It In V9

Jim