RE: Outputting the contents of cursors in a Report Summary

Author: Tracy Pearson

Posted: 2015-07-01 at 16:46:09

+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