Reports and columns

Thanks in advance for the help.

I'm using VFP 7 SP1

I have a 4 column report and I would like a total at the bottom of the last
column only. The entire report fits on one page.

If I set up a summary page it prints on the second page.
If I set up a column footer it prints under all 4 columns.

I've tried using various expressions in the Print When dialog but nothing
I've tried so far has worked.

The only thing I can think of is calculating the total before running the
report and inserting one more record in the table with the report total
data.

There must be something more elegant than that, however.

Does anyone have any idea?

Thanks,

Jeff

Dennis
Tue Sep 21 10:48:05 CDT 2004

Jeff,

I use VFP6 but hopefully what I am about to tell you will work in 7 as well.

Open the report in the report designer. Select Report from the menu.
Select the Title/Summary option. In the dialog box, you will see a summary
section with New Page checked. Just remove the checkmark and see if that
fixes your problem.

HTH,

Dennis Longfellow

"Jeff Grippe" <jgrippe@hilldun.com> wrote in message
news:10l0inaqo64cn7d@news.supernews.com...
> Thanks in advance for the help.
>
> I'm using VFP 7 SP1
>
> I have a 4 column report and I would like a total at the bottom of the
last
> column only. The entire report fits on one page.
>
> If I set up a summary page it prints on the second page.
> If I set up a column footer it prints under all 4 columns.
>
> I've tried using various expressions in the Print When dialog but nothing
> I've tried so far has worked.
>
> The only thing I can think of is calculating the total before running the
> report and inserting one more record in the table with the report total
> data.
>
> There must be something more elegant than that, however.
>
> Does anyone have any idea?
>
> Thanks,
>
> Jeff
>
>

Jeff
Wed Sep 22 09:31:36 CDT 2004

Dennis,

That was the way I coded the report initially. The summary still printed on
a new page even though the New Page box was not checked.

I took the path of least resistance and appended a record for the total
which I computed before printing the report.

Thanks for the help.

Jeff
"Dennis Longfellow" <xxxdrlongfellowxxx@xxxdirectracx.xxx.com> wrote in
message news:e6D6eJ$nEHA.1152@TK2MSFTNGP11.phx.gbl...
> Jeff,
>
> I use VFP6 but hopefully what I am about to tell you will work in 7 as
well.
>
> Open the report in the report designer. Select Report from the menu.
> Select the Title/Summary option. In the dialog box, you will see a
summary
> section with New Page checked. Just remove the checkmark and see if that
> fixes your problem.
>
> HTH,
>
> Dennis Longfellow
>
> "Jeff Grippe" <jgrippe@hilldun.com> wrote in message
> news:10l0inaqo64cn7d@news.supernews.com...
> > Thanks in advance for the help.
> >
> > I'm using VFP 7 SP1
> >
> > I have a 4 column report and I would like a total at the bottom of the
> last
> > column only. The entire report fits on one page.
> >
> > If I set up a summary page it prints on the second page.
> > If I set up a column footer it prints under all 4 columns.
> >
> > I've tried using various expressions in the Print When dialog but
nothing
> > I've tried so far has worked.
> >
> > The only thing I can think of is calculating the total before running
the
> > report and inserting one more record in the table with the report total
> > data.
> >
> > There must be something more elegant than that, however.
> >
> > Does anyone have any idea?
> >
> > Thanks,
> >
> > Jeff
> >
> >
>
>

Dennis
Wed Sep 22 16:53:28 CDT 2004

Jeff,

That's what I get for not testing before posting. I just assumed it would
work, which means that most of my reports must have the summary printed on a
new page because I have not experienced this problem. If I ever do, I will
try your solution.

Thanks for the idea.

Dennis

"Jeff Grippe" <jgrippe@hilldun.com> wrote in message
news:10l336akq9n3kf1@news.supernews.com...
> Dennis,
>
> That was the way I coded the report initially. The summary still printed
on
> a new page even though the New Page box was not checked.
>
> I took the path of least resistance and appended a record for the total
> which I computed before printing the report.
>
> Thanks for the help.
>
> Jeff
> "Dennis Longfellow" <xxxdrlongfellowxxx@xxxdirectracx.xxx.com> wrote in
> message news:e6D6eJ$nEHA.1152@TK2MSFTNGP11.phx.gbl...
> > Jeff,
> >
> > I use VFP6 but hopefully what I am about to tell you will work in 7 as
> well.
> >
> > Open the report in the report designer. Select Report from the menu.
> > Select the Title/Summary option. In the dialog box, you will see a
> summary
> > section with New Page checked. Just remove the checkmark and see if
that
> > fixes your problem.
> >
> > HTH,
> >
> > Dennis Longfellow
> >
> > "Jeff Grippe" <jgrippe@hilldun.com> wrote in message
> > news:10l0inaqo64cn7d@news.supernews.com...
> > > Thanks in advance for the help.
> > >
> > > I'm using VFP 7 SP1
> > >
> > > I have a 4 column report and I would like a total at the bottom of the
> > last
> > > column only. The entire report fits on one page.
> > >
> > > If I set up a summary page it prints on the second page.
> > > If I set up a column footer it prints under all 4 columns.
> > >
> > > I've tried using various expressions in the Print When dialog but
> nothing
> > > I've tried so far has worked.
> > >
> > > The only thing I can think of is calculating the total before running
> the
> > > report and inserting one more record in the table with the report
total
> > > data.
> > >
> > > There must be something more elegant than that, however.
> > >
> > > Does anyone have any idea?
> > >
> > > Thanks,
> > >
> > > Jeff
> > >
> > >
> >
> >
>
>