Author: Joe Yoder
Posted: 2015-07-01 12:11:50 Link
I am trying to add header and detail bands inside a Report Summary band to
handle data in three cursors. Is there a way to do this? Another way to
get the cursor data onto the report?
Thanks in advance,
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/CABQeDnUXDojfrAkZmkHxvndfxgcbOpkz4RQkHktTEmaakJJCUg@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.
Author: Kurt Wendt
Posted: 2015-07-01 12:55:01 Link
In theory - you could pre-format the data layout & stuff it into a Memo field - and then print the memo.
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Joe Yoder
Sent: Wednesday, July 01, 2015 1:12 PM
To: profoxtech@leafe.com
Subject: Outputting the contents of cursors in a Report Summary
I am trying to add header and detail bands inside a Report Summary band to handle data in three cursors. Is there a way to do this? Another way to get the cursor data onto the report?
Thanks in advance,
Joe
--- StripMime Report -- processed MIME parts --- multipart/alternative
text/plain (text body -- kept)
text/html
---
[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/80838F1CA795B14EA1AF48659F35166F1CB022@DREXCH02.corp.globetax.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.
Author: Joe Yoder
Posted: 2015-07-01 13:08:46 Link
I was planning on the formatting capabilities of the report writer. I
guess one possibility would be to create a separate Summary Report and try
to 'glue' the two reports together into a single PDF. Any simple way to do
that?
On Wed, Jul 1, 2015 at 1:55 PM, Kurt Wendt <Kurt_Wendt@globetax.com> wrote:
> In theory - you could pre-format the data layout & stuff it into a Memo
> field - and then print the memo.
>
> -----Original Message-----
> From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Wednesday, July 01, 2015 1:12 PM
> To: profoxtech@leafe.com
> Subject: Outputting the contents of cursors in a Report Summary
>
> I am trying to add header and detail bands inside a Report Summary band to
> handle data in three cursors. Is there a way to do this? Another way to
> get the cursor data onto the report?
>
> Thanks in advance,
>
> Joe
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[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/CABQeDnVx7y-zE_c-bimZ5+1+_yfMDcX-Ek4t=0TqEcmFwM-ofg@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.
Author: Kurt Wendt
Posted: 2015-07-01 14:05:03 Link
At one point - a While ago - I did something like that. Literally - generated one type of report - and somehow generated it as Text to be pulled into a Memo field - and then incorporated that Memo field on another report.
Although - I still must admit - part of your initial request didn't seem to make sense: " I am trying to add header and detail bands inside a Report Summary band to handle data in three cursors. " I mean - a Detail and a Header are each different bands in the report. But, so is the Summary. So - how can you put a Header band Inside of a Summary band? That just didn't seem to make sense...
-K-
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Joe Yoder
Sent: Wednesday, July 01, 2015 2:09 PM
To: profoxtech@leafe.com
Subject: Re: Outputting the contents of cursors in a Report Summary
I was planning on the formatting capabilities of the report writer. I guess one possibility would be to create a separate Summary Report and try to 'glue' the two reports together into a single PDF. Any simple way to do that?
On Wed, Jul 1, 2015 at 1:55 PM, Kurt Wendt <Kurt_Wendt@globetax.com> wrote:
> In theory - you could pre-format the data layout & stuff it into a
> Memo field - and then print the memo.
>
> -----Original Message-----
> From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of
> Joe Yoder
> Sent: Wednesday, July 01, 2015 1:12 PM
> To: profoxtech@leafe.com
> Subject: Outputting the contents of cursors in a Report Summary
>
> I am trying to add header and detail bands inside a Report Summary
> band to handle data in three cursors. Is there a way to do this?
> Another way to get the cursor data onto the report?
>
> Thanks in advance,
>
> Joe
>
>
> --- StripMime Report -- processed MIME parts --- multipart/alternative
> text/plain (text body -- kept)
> text/html
> ---
>
[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/80838F1CA795B14EA1AF48659F35166F1CB05E@DREXCH02.corp.globetax.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.
Author: Tracy Pearson
Posted: 2015-07-01 14:38:33 Link
Joe Yoder wrote on 2015-07-01:
> I was planning on the formatting capabilities of the report writer. I
> guess one possibility would be to create a separate Summary Report and
try
> to 'glue' the two reports together into a single PDF. Any simple way to
do
> that?
>
Joe,
It has been a long time since I worked with related cursors in a report. So
this is from memory.
Your primary cursor will relate to the cursors that will run in the detail
bands.
Using the Target Alias Expression sets which cursor will be looped in that
band. (Found on the Detail Band Properties)
To prevent a band from printing, the filtered group will need to have no
records.
Adding a third cursor would be the same as adding the second you already
have.
If the Detail Header/Footer values print/display, then you can use the Print
When expression to see if you are !EOF("SummaryCursor") .
HTH,
Tracy
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/000301d0b435$849e0800$8dda1800$@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.
Author: Joe Yoder
Posted: 2015-07-01 15:39:44 Link
It looks like my clear description wasn't - sorry about that! I'll try
again:
The detail of the report comes from two cursors. The group header with
data from the first cursor shows the customer detail and amount paid while
the detail band with the second cursors, gives the detail of what the
customer ordered. This is working fine.
The data I need on the summary page breaks down the data three different
ways:
1. Type of payment (cash, check, credit card etc)
2. Type of discount(Early registration or Scholarship, etc.)
3. Type of purchased(Earned or Unearned Reservations for lodging, meals
etc)
Each of the breakdowns can have a varying number of entries or no entry at
all.
It is my impression that I could use the report writer functionality to get
each of these summaries but that it would need to loop through the data
three times. My code is generating cursors for each of the three breakdowns
I need but I have not figured out how to have their data appear in the
Summary band. When I mentioned adding bands to the summary band I assumed
this would be the way to have the report loop through each cursor. I did
see some reference to doing something like this looping through an array
but I did not understand the process or see how one would control the
placement of the data on the form.
Still muddy? Advice?
Thanks,
Joe
On Wed, Jul 1, 2015 at 3:38 PM, Tracy Pearson <tracy@powerchurch.com> wrote:
> Joe Yoder wrote on 2015-07-01:
> > I was planning on the formatting capabilities of the report writer. I
> > guess one possibility would be to create a separate Summary Report and
> try
> > to 'glue' the two reports together into a single PDF. Any simple way to
> do
> > that?
> >
>
> Joe,
>
> It has been a long time since I worked with related cursors in a report. So
> this is from memory.
>
> Your primary cursor will relate to the cursors that will run in the detail
> bands.
> Using the Target Alias Expression sets which cursor will be looped in that
> band. (Found on the Detail Band Properties)
> To prevent a band from printing, the filtered group will need to have no
> records.
>
> Adding a third cursor would be the same as adding the second you already
> have.
>
> If the Detail Header/Footer values print/display, then you can use the
> When expression to see if you are !EOF("SummaryCursor") .
>
> HTH,
> Tracy
>
>
> 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/CABQeDnV_1a08cOcGB0WQk9faNfynep_66jyKEHy=Uawy03rYYQ@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.
Author: Richard Kaye
Posted: 2015-07-01 15:59:31 Link
You could try using report variables to store the various values you want to appear in the summary band.
--
rk
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Joe Yoder
Sent: Wednesday, July 01, 2015 4:40 PM
To: profoxtech@leafe.com
Subject: Re: Outputting the contents of cursors in a Report Summary
It looks like my clear description wasn't - sorry about that! I'll try
again:
The detail of the report comes from two cursors. The group header with data from the first cursor shows the customer detail and amount paid while the detail band with the second cursors, gives the detail of what the customer ordered. This is working fine.
The data I need on the summary page breaks down the data three different
ways:
1. Type of payment (cash, check, credit card etc)
2. Type of discount(Early registration or Scholarship, etc.)
3. Type of purchased(Earned or Unearned Reservations for lodging, meals
etc)
Each of the breakdowns can have a varying number of entries or no entry at all.
It is my impression that I could use the report writer functionality to get each of these summaries but that it would need to loop through the data three times. My code is generating cursors for each of the three breakdowns I need but I have not figured out how to have their data appear in the Summary band. When I mentioned adding bands to the summary band I assumed this would be the way to have the report loop through each cursor. I did see some reference to doing something like this looping through an array but I did not understand the process or see how one would control the placement of the data on the form.
Still muddy? Advice?
Thanks,
Joe
On Wed, Jul 1, 2015 at 3:38 PM, Tracy Pearson <tracy@powerchurch.com> wrote:
> Joe Yoder wrote on 2015-07-01:
> > I was planning on the formatting capabilities of the report writer.
> > I guess one possibility would be to create a separate Summary
> > Report and
> try
> > to 'glue' the two reports together into a single PDF. Any simple
> > way to
> do
> > that?
> >
>
> Joe,
>
> It has been a long time since I worked with related cursors in a
> report. So this is from memory.
>
> Your primary cursor will relate to the cursors that will run in the
> detail bands.
> Using the Target Alias Expression sets which cursor will be looped in
> that band. (Found on the Detail Band Properties) To prevent a band
> from printing, the filtered group will need to have no records.
>
> Adding a third cursor would be the same as adding the second you
> already have.
>
> If the Detail Header/Footer values print/display, then you can use the
> Print When expression to see if you are !EOF("SummaryCursor") .
>
> HTH,
> Tracy
>
>
> 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/BN4PR10MB09131D4CC753142540561500D2A80@BN4PR10MB0913.namprd10.prod.outlook.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.
Author: Tracy Pearson
Posted: 2015-07-01 16:46:09 Link
+1 - Sounds like the way you'll need to do it.
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Richard
Kaye
Sent: Wednesday, July 01, 2015 5:00 PM
To: profoxtech@leafe.com
Subject: RE: Outputting the contents of cursors in a Report Summary
You could try using report variables to store the various values you want to
appear in the summary band.
--
rk
-----Original Message-----
From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Joe
Yoder
Sent: Wednesday, July 01, 2015 4:40 PM
To: profoxtech@leafe.com
Subject: Re: Outputting the contents of cursors in a Report Summary
It looks like my clear description wasn't - sorry about that! I'll try
again:
The detail of the report comes from two cursors. The group header with data
from the first cursor shows the customer detail and amount paid while the
detail band with the second cursors, gives the detail of what the customer
ordered. This is working fine.
The data I need on the summary page breaks down the data three different
ways:
1. Type of payment (cash, check, credit card etc)
2. Type of discount(Early registration or Scholarship, etc.)
3. Type of purchased(Earned or Unearned Reservations for lodging, meals
etc)
Each of the breakdowns can have a varying number of entries or no entry at
all.
It is my impression that I could use the report writer functionality to get
each of these summaries but that it would need to loop through the data
three times. My code is generating cursors for each of the three breakdowns
I need but I have not figured out how to have their data appear in the
Summary band. When I mentioned adding bands to the summary band I assumed
this would be the way to have the report loop through each cursor. I did
see some reference to doing something like this looping through an array but
I did not understand the process or see how one would control the placement
of the data on the form.
Still muddy? Advice?
Thanks,
Joe
On Wed, Jul 1, 2015 at 3:38 PM, Tracy Pearson <tracy@powerchurch.com> wrote:
> Joe Yoder wrote on 2015-07-01:
> > I was planning on the formatting capabilities of the report writer.
> > I guess one possibility would be to create a separate Summary
> > Report and
> try
> > to 'glue' the two reports together into a single PDF. Any simple
> > way to
> do
> > that?
> >
>
> Joe,
>
> It has been a long time since I worked with related cursors in a
> report. So this is from memory.
>
> Your primary cursor will relate to the cursors that will run in the
> detail bands.
> Using the Target Alias Expression sets which cursor will be looped in
> that band. (Found on the Detail Band Properties) To prevent a band
> from printing, the filtered group will need to have no records.
>
> Adding a third cursor would be the same as adding the second you
> already have.
>
> If the Detail Header/Footer values print/display, then you can use the
> Print When expression to see if you are !EOF("SummaryCursor") .
>
> HTH,
> Tracy
>
>
> 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/000501d0b447$57d503c0$077f0b40$@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.
Author: Joe Yoder
Posted: 2015-07-01 18:27:18 Link
Is there a way to read the cursors into arrays when the form initializes?
I can manually place an abundance of fields to cover the maximum expected
array size and have the each field pointing to an array element. I may
check into programmatically generating code in the .frx.
It would sure be a lot less work if there were a way to move the record
pointer in the cursors and just print the data directly from there.
Thanks,
Joe
On Wed, Jul 1, 2015 at 5:46 PM, Tracy Pearson <tracy@powerchurch.com> wrote:
> +1 - Sounds like the way you'll need to do it.
>
> -----Original Message-----
> From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of
> Richard
> Kaye
> Sent: Wednesday, July 01, 2015 5:00 PM
> To: profoxtech@leafe.com
> Subject: RE: Outputting the contents of cursors in a Report Summary
>
> You could try using report variables to store the various values you want
> to
> appear in the summary band.
>
> --
>
> rk
> -----Original Message-----
> From: ProfoxTech [mailto:profoxtech-bounces@leafe.com] On Behalf Of Joe
> Yoder
> Sent: Wednesday, July 01, 2015 4:40 PM
> To: profoxtech@leafe.com
> Subject: Re: Outputting the contents of cursors in a Report Summary
>
> It looks like my clear description wasn't - sorry about that! I'll try
> again:
>
> The detail of the report comes from two cursors. The group header with
> data
> from the first cursor shows the customer detail and amount paid while the
> detail band with the second cursors, gives the detail of what the customer
> ordered. This is working fine.
>
> The data I need on the summary page breaks down the data three different
> ways:
>
> 1. Type of payment (cash, check, credit card etc)
> 2. Type of discount(Early registration or Scholarship, etc.)
> 3. Type of purchased(Earned or Unearned Reservations for lodging, meals
> etc)
>
> Each of the breakdowns can have a varying number of entries or no entry at
> all.
>
> It is my impression that I could use the report writer functionality to get
> each of these summaries but that it would need to loop through the data
> three times. My code is generating cursors for each of the three breakdowns
> I need but I have not figured out how to have their data appear in the
> Summary band. When I mentioned adding bands to the summary band I assumed
> this would be the way to have the report loop through each cursor. I did
> see some reference to doing something like this looping through an array
> but
> I did not understand the process or see how one would control the placement
> of the data on the form.
>
> Still muddy? Advice?
>
> Thanks,
>
> Joe
>
> On Wed, Jul 1, 2015 at 3:38 PM, Tracy Pearson <tracy@powerchurch.com>
> wrote:
>
> > Joe Yoder wrote on 2015-07-01:
> > > I was planning on the formatting capabilities of the report writer.
> > > I guess one possibility would be to create a separate Summary
> > > Report and
> > try
> > > to 'glue' the two reports together into a single PDF. Any simple
> > > way to
> > do
> > > that?
> > >
> >
> > Joe,
> >
> > It has been a long time since I worked with related cursors in a
> > report. So this is from memory.
> >
> > Your primary cursor will relate to the cursors that will run in the
> > detail bands.
> > Using the Target Alias Expression sets which cursor will be looped in
> > that band. (Found on the Detail Band Properties) To prevent a band
> > from printing, the filtered group will need to have no records.
> >
> > Adding a third cursor would be the same as adding the second you
> > already have.
> >
> > If the Detail Header/Footer values print/display, then you can use the
> > Print When expression to see if you are !EOF("SummaryCursor") .
> >
> > HTH,
> > Tracy
> >
> >
> > 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/CABQeDnXjLpLPcebwN_jWQuC1Teot6RwoYabm0ENXL5SnA2T9hQ@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.
Author: Ken Dibble
Posted: 2015-07-01 19:25:56 Link
>Is there a way to read the cursors into arrays when the form initializes?
SELECT * FROM MyCursor INTO ARRAY aMyArray
Autocreates the array if it doesn't exist. But you can reference as
many different distinct data sources as you have fields in the
report, as long as they are in scope, so I don't see why you would
prefer arrays to cursors in that case.
If you want the execution of the report itself to generate the
summary data then the report variables are the way to go.
Though I agree with the people who say: Denormalize and process
everything down to one or more cursors, perhaps, say, one cursor per
detail band, and one cursor for header and summary data, before
running the report. It's a lot easier to understand, and it has the
advantage of being portable in case you need the same or similar data
in a radically different report layout.
Ken Dibble
www.stic-cil.org
_______________________________________________
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/62.38.14080.46984955@cdptpa-oedge02
** 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.