suppress lines in reports

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

Guest

My problem is that the Can Shrik property doesn't work in my case.
Any help?

Here's my line that returns a value but I want to get rid of the spaces in
between.

=IIf([Status]="Active" And [due]>100,[Customer],Null)

Thanx
 
Are you talking about the Can Shrink property of the control, or of the
section the control is in?

We're not there, so when you say "get rid of the spaced in between", we can
only guess in between what?

Have you tried using the formula in a query that your report is subsequently
based on, or are you doing this directly in the report?

--
More info, please ...

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/
 
Robbie said:
My problem is that the Can Shrik property doesn't work in my case.
Any help?

Here's my line that returns a value but I want to get rid of the spaces in
between.

=IIf([Status]="Active" And [due]>100,[Customer],Null)
Click to expand...


Why doesn't CanShrink work for you?

Get rid of the spaces in between WHAT?

The effectiveness of CanShrink is dependent on what else is
in the report and where the other information should be
displayed.

Your text box expression kind of implies that you are trying
to suppress an entire record's worth of data when certain
conditions are met. If that is indeed the case, then you
should be filtering those record out using criteria in the
report's record source query.
 
Sorry guys, this was supposed to be a continuation of someone else's thread.
However, with the formula provided I get some blank lines in between records
 
Did you try my earlier suggestion about fitering out the
offending data in the report's record source query?
--
Marsh
MVP [MS Access]


Robbie said:
Sorry guys, this was supposed to be a continuation of someone else's thread.
However, with the formula provided I get some blank lines in between records
My problem is that the Can Shrik property doesn't work in my case.
Any help?

Here's my line that returns a value but I want to get rid of the spaces in
between.

=IIf([Status]="Active" And [due]>100,[Customer],Null)
Click to expand...
Click to expand...
 
That is a good choice of workaround. However, I'm gonna need the same
information for [due]<100 later on. That's why I wanted to see if I could get
the formula in the report source instead. :)

Marshall Barton said:
Did you try my earlier suggestion about fitering out the
offending data in the report's record source query?
--
Marsh
MVP [MS Access]


Robbie said:
Sorry guys, this was supposed to be a continuation of someone else's thread.
However, with the formula provided I get some blank lines in between records
My problem is that the Can Shrik property doesn't work in my case.
Any help?

Here's my line that returns a value but I want to get rid of the spaces in
between.

=IIf([Status]="Active" And [due]>100,[Customer],Null)
Click to expand...
Click to expand...
Click to expand...
 
That was not a workaround, it is by far the preferred way to
deal with data that should not be displayed in either a form
or report. The ability to use criteria is what using a
query for the record source is all about and there are lots
of features to support dealing with dynamic criteria values.

You have yet to explain what data you do an do not want to
see in the report and I still have no idea what the report
is supposed to look like.

As a last resort in very unusual situations you can suppress
an entire section by making the section invisible or by
canceling its Format or Print event.
--
Marsh
MVP [MS Access]


Robbie said:
That is a good choice of workaround. However, I'm gonna need the same
information for [due]<100 later on. That's why I wanted to see if I could get
the formula in the report source instead. :)

Marshall Barton said:
Did you try my earlier suggestion about fitering out the
offending data in the report's record source query?


Robbie said:
Sorry guys, this was supposed to be a continuation of someone else's thread.
However, with the formula provided I get some blank lines in between records
on the Report. I wanna be able to suppress those lines so their all together.

:
My problem is that the Can Shrik property doesn't work in my case.
Any help?

Here's my line that returns a value but I want to get rid of the spaces in
between.

=IIf([Status]="Active" And [due]>100,[Customer],Null)
Click to expand...
Click to expand...
Click to expand...
 
Back
Top