I have a report that amounts to simply printing each record from a table.
There is no subgrouping of the data. All that is needed is a grand total
at the bottom. How does one setup the report writer to get and print the
total?
TIA - Joe
--- StripMime Report -- processed MIME parts ---
multipart/alternative
text/plain (text body -- kept)
text/html
---
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CABQeDnXr=OZ+Qxa1Xb91OZ8xNPuBMg=4tvSOXFFPoYrhHmhijA@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Joe Yoder wrote on 2016-08-23:
> I have a report that amounts to simply printing each record from a table.
> There is no subgrouping of the data. All that is needed is a grand total
> at the bottom. How does one setup the report writer to get and print the
> total?
>
> TIA - Joe
>
Joe,
Under the Reports, menu, select Optional Bands.
In the Report Properties window on the Optional Bands tab you'll want to
check Report has summary band.
Then click over to Variables, I create variables with the m. notation. So I
add m.summary
Value to store is the field you want to sum.
Initial value is 0
Reset value based on is report
Calculation type is Sum
Then you add a textbox to the Summary band (the names are at the bottom of
the band) and put in m.summary. (or the variable name you used)
Tracy Pearson
PowerChurch Software
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/002101d1fd4d$29c795b0$7d56c110$@powerchurch.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Thanks Tracy. That was exactly what I needed. I was suspicious that the
use of a variable was required but since I use the report writer so
infrequently I thought I'd ask if there is something I am overlooking.
Thanks agin - Joe
On Tue, Aug 23, 2016 at 10:46 AM, Tracy Pearson <tracy@powerchurch.com>
wrote:
> Joe Yoder wrote on 2016-08-23:
> > I have a report that amounts to simply printing each record from a
> table.
> > There is no subgrouping of the data. All that is needed is a grand
> total
> > at the bottom. How does one setup the report writer to get and print the
> > total?
> >
> > TIA - Joe
> >
>
> Joe,
>
> Under the Reports, menu, select Optional Bands.
> In the Report Properties window on the Optional Bands tab you'll want to
> check Report has summary band.
> Then click over to Variables, I create variables with the m. notation. So I
> add m.summary
> Value to store is the field you want to sum.
> Initial value is 0
> Reset value based on is report
> Calculation type is Sum
>
> Then you add a textbox to the Summary band (the names are at the bottom of
> the band) and put in m.summary. (or the variable name you used)
>
>
> Tracy Pearson
> PowerChurch Software
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CABQeDnWXkrUfX-YBh5+fMV3HdiOSSQt2JFu_dTqkMdT=XX9sqw@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
You don't actually need a variable - do this:
Click on the field you want to sum.
Copy it into the summary band.
In the summary band right click on the field for properties.
Choose Calculate and select Sum.
Laurie
On 23 August 2016 at 16:55, Joe Yoder <joe@wheypower.com> wrote:
> Thanks Tracy. That was exactly what I needed. I was suspicious that the
> use of a variable was required but since I use the report writer so
> infrequently I thought I'd ask if there is something I am overlooking.
>
> Thanks agin - Joe
>
> On Tue, Aug 23, 2016 at 10:46 AM, Tracy Pearson <tracy@powerchurch.com>
> wrote:
>
> > Joe Yoder wrote on 2016-08-23:
> > > I have a report that amounts to simply printing each record from a
> > table.
> > > There is no subgrouping of the data. All that is needed is a grand
> > total
> > > at the bottom. How does one setup the report writer to get and print
> the
> > > total?
> > >
> > > TIA - Joe
> > >
> >
> > Joe,
> >
> > Under the Reports, menu, select Optional Bands.
> > In the Report Properties window on the Optional Bands tab you'll want to
> > check Report has summary band.
> > Then click over to Variables, I create variables with the m. notation.
> So I
> > add m.summary
> > Value to store is the field you want to sum.
> > Initial value is 0
> > Reset value based on is report
> > Calculation type is Sum
> >
> > Then you add a textbox to the Summary band (the names are at the bottom
> of
> > the band) and put in m.summary. (or the variable name you used)
> >
> >
> > Tracy Pearson
> > PowerChurch Software
> >
> >
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/CAMvTR9fd8K9i46wSuoXbRSTpBpBur70VeP-e6J2VFGkvzTiYjQ@mail.gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
A simpler way to do that, without using any variables is thus:
Copy the control you use to display each record in the summary band, but
set the calculation type to sum
At the end of the report this control will show the sum of the records,
as requested
Rafael Copquin
On 23/08/2016 11:46, Tracy Pearson wrote:
> Joe Yoder wrote on 2016-08-23:
>> I have a report that amounts to simply printing each record from a table.
>> There is no subgrouping of the data. All that is needed is a grand total
>> at the bottom. How does one setup the report writer to get and print the
>> total?
>>
>> TIA - Joe
>>
> Joe,
>
> Under the Reports, menu, select Optional Bands.
> In the Report Properties window on the Optional Bands tab you'll want to
> check Report has summary band.
> Then click over to Variables, I create variables with the m. notation. So I
> add m.summary
> Value to store is the field you want to sum.
> Initial value is 0
> Reset value based on is report
> Calculation type is Sum
>
> Then you add a textbox to the Summary band (the names are at the bottom of
> the band) and put in m.summary. (or the variable name you used)
>
>
> Tracy Pearson
> PowerChurch Software
>
>
[excessive quoting removed by server]
_______________________________________________
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message: http://leafe.com/archives/byMID/profox/736b57ab-e112-f5b8-ebf6-de5dc734c0cd@gmail.com
** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.