Hello,
I have a table with the name and classification of some students exams. The student may have an observation (P - Para Recuperação aka R - Recovery) if he/she hasn't done the exam.

Where the classification number is shown, I have the classification field and the observation field so that when there is no classification it shows the observation.

I want to be able to print 2 pages:

1) where the classifications are > = 10 and no observations
2) All the classifications (positive, negative and observations)

On section details, on the surpress field, I wrote the following code:

if {?positivas} = 1 then
{Avaliacao.classificacao} < 10
and I get this: http://imageshack.us/photo/my-images/843/positivas.jpg/

else if {?positivas} = 2 then
{Avaliacao.classificacao} >= 10
http://imageshack.us/photo/my-images/217/negativas.jpg/


Thing is, on the first IF it shows me the observations field too.
I've tried doing
{Avaliacao.classificacao} < 10 and isnull({avaliacao_observation.abr}) = false
but it shows me all the positive, negative and observations...


Can anybody help me on this?

Thanks

Yes, on this part I really mean to surpress everything bellow 10, observations included:

if {?positivas} = 1 then
{Avaliacao.classificacao} < 10

But I can't because it keeps showing me the observations field as well

if {?positivas} = 1 I want to surpress the rows where there is observation fields.

All the exam marks:
http://imageshack.us/photo/my-images/836/allzw.jpg/


And this is what I have on the main report:
http://imageshack.us/photo/my-images/838/reportho.jpg/

There is 2 fields in the same place on the classification table: one that shows me the mark numbers, and other that, in case there is no mark, shows me the observation abreviation

Blue fields = positive
Red fields = negative
Green fields = observations.

I'm doing it on the section details. {?positive} is a static parameter.
If positive = 1  I mean to show only the blue fields;
if positive = 2  I mean to show the blue, red and green fields.

If I'm not making myself clear, please, tell me

when I said "red" and "blue fields", I meant the ones on the image. On crystal I only have, let's say, 2 fields (one that gives me the red and blue fields , other that gives me the green fields).

I tried surpressing on the text itself instead of the section, but it supresses the the field and the row stays there because there are other fields in the row.

This is the 1st pic.


2nd Pic

I can't do it like that.

You see, I have 2 fields:

classification field gives me the result of the exam from 0 to 20

observation field that gives me an observation if there isn't any exam mark. It shows F (=M as in Missed) or P (=R as in Recovery).

If the parameter selection is 1, it should show any mark above 10, so I wrote {Avaliacao.classificacao} < 10

This is half correct because it surpresses everything below 10, but it shows the observation field which is on the same exact place where classification field is.

I've tried {Avaliacao.classificacao} < 10 and isnull({Avaliacao_Observacoes.abr}) = false

or

{Avaliacao.classificacao} < 10 and {Avaliacao_Observacoes.abr} = {Avaliacao_Observacoes.abr}

and many other ways, but I can't seem to figure it out how to supress it along with the marks below 10







Edited by Goldberg - 07 Jul 2011 at 12:59am