Index
2015-07-01 12:11 – Joe Yoder : Outputting the contents of cursors in a Report Summary
2015-07-01 12:55 – Kurt Wendt : RE: Outputting the contents of cursors in a Report Summary
2015-07-01 13:08 – Joe Yoder : Re: Outputting the contents of cursors in a Report Summary
2015-07-01 14:05 – Kurt Wendt : RE: Outputting the contents of cursors in a Report Summary
2015-07-01 14:38 – Tracy Pearson : RE: Outputting the contents of cursors in a Report Summary
2015-07-01 15:39 – Joe Yoder : Re: Outputting the contents of cursors in a Report Summary
2015-07-01 15:59 – Richard Kaye : RE: Outputting the contents of cursors in a Report Summary
2015-07-01 16:46 – Tracy Pearson : RE: Outputting the contents of cursors in a Report Summary
2015-07-01 18:27 – Joe Yoder : Re: Outputting the contents of cursors in a Report Summary
2015-07-01 19:25 – Ken Dibble : Re: Outputting the contents of cursors in a Report Summary
Back to top
Outputting the contents of cursors in a Report Summary

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.

©2015 Joe Yoder
Back to top
RE: Outputting the contents of cursors in a Report Summary

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.

©2015 Kurt Wendt
Back to top
Re: Outputting the contents of cursors in a Report Summary

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.

©2015 Joe Yoder
Back to top
RE: Outputting the contents of cursors in a Report Summary

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.

©2015 Kurt Wendt
Back to top
RE: Outputting the contents of cursors in a Report Summary

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.

©2015 Tracy Pearson
Back to top
Re: Outputting the contents of cursors in a Report Summary

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

> 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/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.

©2015 Joe Yoder
Back to top
RE: Outputting the contents of cursors in a Report Summary

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.

©2015 Richard Kaye
Back to top
RE: Outputting the contents of cursors in a Report Summary

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.

©2015 Tracy Pearson
Back to top
Re: Outputting the contents of cursors in a Report Summary

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.

©2015 Joe Yoder
Back to top
Re: Outputting the contents of cursors in a Report Summary

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.

©2015 Ken Dibble