Getting Started with dBASE - Can a "page break" be inserted into a report?

Author

Can a "page break" be inserted into a report?

Forrest Ganther

2006-11-20, 7:14 pm

In order to make a report more readable
I want to break the page at the end of a group.
So, the next group is all on the same page.

(all of the data is in one table, separated
with blank rows)

I have been unable to figure this out. Any
ideas and/or suggestions appreciated.

thank you

Ken Mayer [dBVIPS]

2006-11-20, 7:14 pm

Forrest Ganther wrote:
> In order to make a report more readable
> I want to break the page at the end of a group.
> So, the next group is all on the same page.
>
> (all of the data is in one table, separated
> with blank rows)
>
> I have been unable to figure this out. Any
> ideas and/or suggestions appreciated.

Are you using a group headerBand? group footerBand?

If you are using a group headerBand, this is simple. Go to the
headerBand in the inspector and set the beginNewFrame property to true.

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/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

Forrest Ganther

2006-11-20, 7:14 pm

Thanks Ken, that helped a lot, but...
If I did it right, I get a new page with each group.
I would like to have more that one group per
page, but after say 3 groups go to new page.

I also incurred a problem, if I set the footer to
any height other than leaving it at zero, I can
save the report, but get an error if I try to run it
or design it. Most of the coding is gone!

I have probably reconstructed this report 30
or more times. I have numerous different problems.

Thanks for you help!!!!

"Ken Mayer [dBVIPS]" < dbase@_nospam_golden
stag.net> wrote in message
news:2FzUaELDHHA.336@news-server...
> Forrest Ganther wrote:
>
> Are you using a group headerBand? group footerBand?
>
> If you are using a group headerBand, this is simple. Go to the headerBand
> in the inspector and set the beginNewFrame property to true.
>
> 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/dbase/dBASEBook.htm
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase

Michael Nuwer

2006-11-21, 12:14 am

Ken Mayer [dBVIPS]

2006-11-21, 7:13 pm

Forrest Ganther wrote:
> Thanks Ken, that helped a lot, but...
> If I did it right, I get a new page with each group.
> I would like to have more that one group per
> page, but after say 3 groups go to new page.

Take a good look at the HOW TO documents on working with reports, there
are discussions there of calling the band's beginNewFrame() method to
force a new streamFrame ... (this is also in Chapter 19 of my book).

> I also incurred a problem, if I set the footer to
> any height other than leaving it at zero, I can
> save the report, but get an error if I try to run it
> or design it. Most of the coding is gone!

That's very odd, and I can't help. I have never seen this. I work with
footerBands all the time in reports (group footerBands and reportGroup
footerBands) and never see this. Is it possible that there is some
specific code that is causing this?

The last time I lost a bunch of code in a report, I had some structure
that was not ending properly (do while ... / endddo; for/next; etc.) and
it messed things up.

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/dbase/dBASEBook.htm
http://www.goldenstag.net/GSP
http://www.goldenstag.net/dbase

Forrest Ganther

2006-11-21, 7:13 pm

OK, Thank You very much!!

"Ken Mayer [dBVIPS]" < dbase@_nospam_golden
stag.net> wrote in message
news:jZY2oMXDHHA.1212@news-server...
> Forrest Ganther wrote:
>
> Take a good look at the HOW TO documents on working with reports, there
> are discussions there of calling the band's beginNewFrame() method to
> force a new streamFrame ... (this is also in Chapter 19 of my book).
>
>
> That's very odd, and I can't help. I have never seen this. I work with
> footerBands all the time in reports (group footerBands and reportGroup
> footerBands) and never see this. Is it possible that there is some
> specific code that is causing this?
>
> The last time I lost a bunch of code in a report, I had some structure
> that was not ending properly (do while ... / endddo; for/next; etc.) and
> it messed things up.
>
> 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/dbase/dBASEBook.htm
> http://www.goldenstag.net/GSP
> http://www.goldenstag.net/dbase

Forrest Ganther

2006-11-23, 7:13 pm

Thanks Michael, that is what I want to do, and
it worked. But, the setRange doesn't set range
for next group, it count's every row in the table.
If I plug in a hard number it works great. Any
further suggestions? And thanks for the web
link, I will make use of the info there!
Happy Thanksgiving to all!

"Michael Nuwer" <michael@forget.it> wrote in message
news:sf7m2BRDHHA.1744@news-server...
> Forrest Ganther wrote:
>
> Maybe something in this document will help you.
>
> http://econ2.potsdam.edu/dlearn/rep...5PageBreaks.htm

Michael Nuwer

2006-11-26, 7:12 pm

Forrest Ganther wrote:
> Thanks Michael, that is what I want to do, and
> it worked. But, the setRange doesn't set range
> for next group, it count's every row in the table.
> If I plug in a hard number it works great. Any
> further suggestions? And thanks for the web
> link, I will make use of the info there!

In my example there are two tables and the setRange method is run
against the child table. Because you're using only one table you will
need to find a way to count the number of rows that will print in the
next group.

My guess would be that your active index does not include the field
which separates groups. Perhaps you can add the that field to your
index. Then the setRange will restrict the table to only those rows that
will print in the group.

Sponsored Links