IIf statement and blank lines

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the following statment in my report. My problem is that I would like
to eliminate the blank lines in between the records that it returns. I am
just not sure what I need to do the the following statement to do eliminate
the null values.

=IIf([Sales]>=50000000 And [ROLE]>=0.1,[Text77],Null)
 
I have the following statment in my report. My problem is that I
would like to eliminate the blank lines in between the records that it
returns. I am just not sure what I need to do the the following
statement to do eliminate the null values.

=IIf([Sales]>=50000000 And [ROLE]>=0.1,[Text77],Null)
Click to expand...

You do not indicate what's all in the detail section.

Supposing it is not more than the field containing the formula above, the
field should not have a label, the detail section property "CanShrink"
should be set to yes and this should also be done for the "CanShrink"
property of the field.
 
jderrig said:
I have the following statment in my report. My problem is that I would like
to eliminate the blank lines in between the records that it returns. I am
just not sure what I need to do the the following statement to do eliminate
the null values.

=IIf([Sales]>=50000000 And [ROLE]>=0.1,[Text77],Null)
Click to expand...


Try setting both the text box's and its section's CanShrink
property to Yes.
 
Actually I have 6 sets of these IIF statements in the detail section.

I have six quadrants on my report depending on the combination of two
different criteria (sales and ROLE). I have (Confusing, I know, I just try
to do what they tell me to do):

=IIf([Sales]>=50000000 And [ROLE]>=0.1,"Q1")
=IIf([Sales]<50000000 And [ROLE]>=0.1,"Q2")
=IIf([Sales]>=50000000 And [ROLE]>=0 And [ROLE]<0.1,"Q3")
=IIf([Sales]<50000000 And [ROLE]>=0.1,"Q4")
=IIf([Sales]>=50000000 And [ROLE]<0,"Q5")
=IIf([Sales]<50000000 And [ROLE]<0,"Q6")

I took off all sorting and grouping and was hoping to get them lined up
according to the Quadrant ranking.

Marshall Barton said:
jderrig said:
I have the following statment in my report. My problem is that I would like
to eliminate the blank lines in between the records that it returns. I am
just not sure what I need to do the the following statement to do eliminate
the null values.

=IIf([Sales]>=50000000 And [ROLE]>=0.1,[Text77],Null)
Click to expand...


Try setting both the text box's and its section's CanShrink
property to Yes.
Click to expand...
 
I figured a better way to do this was to put the Quadrants into the query
instead of trying to hodge-podge like I was. Thanks for the help.

jderrig said:
Actually I have 6 sets of these IIF statements in the detail section.

I have six quadrants on my report depending on the combination of two
different criteria (sales and ROLE). I have (Confusing, I know, I just try
to do what they tell me to do):

=IIf([Sales]>=50000000 And [ROLE]>=0.1,"Q1")
=IIf([Sales]<50000000 And [ROLE]>=0.1,"Q2")
=IIf([Sales]>=50000000 And [ROLE]>=0 And [ROLE]<0.1,"Q3")
=IIf([Sales]<50000000 And [ROLE]>=0.1,"Q4")
=IIf([Sales]>=50000000 And [ROLE]<0,"Q5")
=IIf([Sales]<50000000 And [ROLE]<0,"Q6")

I took off all sorting and grouping and was hoping to get them lined up
according to the Quadrant ranking.

Marshall Barton said:
jderrig said:
I have the following statment in my report. My problem is that I would like
to eliminate the blank lines in between the records that it returns. I am
just not sure what I need to do the the following statement to do eliminate
the null values.

=IIf([Sales]>=50000000 And [ROLE]>=0.1,[Text77],Null)
Click to expand...


Try setting both the text box's and its section's CanShrink
property to Yes.
Click to expand...
Click to expand...
 
Back
Top