 | | From: | Ruud Droog | | Subject: | how to suppressIfBlank on a footerband | | Date: | Wed, 08 Dec 2004 11:10:01 -0500 |
|
|
 | using d+ 2.5
the changes in the reportdesigner affected on old reports bad behavior.
So the suppressIfBlank on all fields on a footerband do still "print" the footerband.(only spaces)
In 2.21 only the footerband with data was printed
How do I solve this problem?
|
|
| | From: | Ruud Droog | | Subject: | Re: how to suppressIfBlank on a footerband | | Date: | Wed, 08 Dec 2004 14:31:19 -0500 |
|
|
| This problem happens also on the detailband....
What is the reason of this changes in de reportdesigner?
I don't like this!
Ruud Droog Wrote:
> using d+ 2.5
>
> the changes in the reportdesigner affected on old reports bad behavior.
> So the suppressIfBlank on all fields on a footerband do still "print" the footerband.(only spaces)
> In 2.21 only the footerband with data was printed
> How do I solve this problem?
>
|
|
| | From: | Ken Mayer [dBVIPS] | | Subject: | Re: how to suppressIfBlank on a footerband | | Date: | Wed, 08 Dec 2004 13:06:01 -0800 |
|
|
| Ruud Droog wrote:
> This problem happens also on the detailband....
> What is the reason of this changes in de reportdesigner?
> I don't like this!
This was an attempt to fix a problem in the designer where you can't see
the detailBand or other bands unless you put something on them, but you
can't put anything on them because you can't see them. The problem is,
the height gets streamed out, even if you didn't change anything, didn't
put anything onto the band, etc.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
|
|
| | From: | Ken Mayer [dBVIPS] | | Subject: | Re: how to suppressIfBlank on a footerband | | Date: | Wed, 08 Dec 2004 08:12:04 -0800 |
|
|
| Ruud Droog wrote:
> using d+ 2.5
>
> the changes in the reportdesigner affected on old reports bad behavior.
> So the suppressIfBlank on all fields on a footerband do still "print" the footerband.(only spaces)
> In 2.21 only the footerband with data was printed
> How do I solve this problem?
>
Set the footerBand height to zero if there is nothing to print ...
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
|
|
| | From: | Ruud Droog | | Subject: | Re: how to suppressIfBlank on a footerband | | Date: | Wed, 08 Dec 2004 12:51:49 -0500 |
|
|
| Hey Ken,
I use the footerband in this report to print de agsum and min :
text = {||this.parent.parent.agSum({||this.parent.rowset.fields["bdr_hfl"].value})}
and
text = {||dttoc(this.parent.parent.agMin({||this.parent.rowset.fields["datum"].value}))}
The details are not printed. Only the invoices are printed where the sum<>0 (an canrender event). So there are footerbands (some bad paying customers a lot) which have to be printed.
How can I manage the height depending on the sum of the invoices?
Ruud
-------------------------------
Ken Mayer [dBVIPS] Wrote:
> Ruud Droog wrote:
> > using d+ 2.5
> >
> > the changes in the reportdesigner affected on old reports bad behavior.
> > So the suppressIfBlank on all fields on a footerband do still "print" the footerband.(only spaces)
> > In 2.21 only the footerband with data was printed
> > How do I solve this problem?
> >
>
> Set the footerBand height to zero if there is nothing to print ...
>
> Ken
>
> --
> /(Opinions expressed are purely my own, not those of dataBased
> Intelligence, Inc.)/
>
> *Ken Mayer* [dBVIPS]
> /Golden Stag Productions/
> dBASE at goldenstag dot net
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase
|
|
| | From: | Marc Hamelin | | Subject: | Re: how to suppressIfBlank on a footerband | | Date: | Wed, 8 Dec 2004 13:10:28 -0500 |
|
|
| > Hey Ken,
>
> I use the footerband in this report to print de agsum and min :
> text =
>
{||this.parent.parent.agSum({||this.parent.rowset.fields["bdr_hfl"].value})}
> and
> text =
>
{||dttoc(this.parent.parent.agMin({||this.parent.rowset.fields["datum"].valu
e}))}
>
> The details are not printed. Only the invoices are printed where the
> sum<>0 (an canrender event). So there are footerbands (some bad
> paying customers a lot) which have to be printed.
>
> How can I manage the height depending on the sum of the invoices?
I'd do it in the canRender event, which you said you were already using.
When you the sum is 0, just set the height property to 0 and then return
false.
Marc Hamelin
|
|
| | From: | Ken Mayer [dBVIPS] | | Subject: | Re: how to suppressIfBlank on a footerband | | Date: | Wed, 08 Dec 2004 10:26:59 -0800 |
|
|
| Ruud Droog wrote:
> Hey Ken,
>
> I use the footerband in this report to print de agsum and min :
> text = {||this.parent.parent.agSum({||this.parent.rowset.fields["bdr_hfl"].value})}
> and
> text = {||dttoc(this.parent.parent.agMin({||this.parent.rowset.fields["datum"].value}))}
>
> The details are not printed. Only the invoices are printed where the sum<>0 (an canrender event). So there are footerbands (some bad paying customers a lot) which have to be printed.
>
> How can I manage the height depending on the sum of the invoices?
I would move away from using codeblocks, and start using the canRender
events. (Codeblocks are limited ...)
With the canRender event, you can then manage the height of the band by
checking the value returned by your agASum/agMin, etc.
Ken
--
/(Opinions expressed are purely my own, not those of dataBased
Intelligence, Inc.)/
*Ken Mayer* [dBVIPS]
/Golden Stag Productions/
dBASE at goldenstag dot net
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase
|
|
