+1 - Sounds like the way you'll need to do it. -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Richard Kaye Sent: Wednesday, July 01, 2015 5:00 PM To: [email protected] 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:[email protected]] On Behalf Of Joe Yoder Sent: Wednesday, July 01, 2015 4:40 PM To: [email protected] 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 <[email protected]> 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: [email protected] 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/[email protected] ** 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.
