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 > > [excessive quoting removed by server] _______________________________________________ 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/CABQeDnV_1a08cOcGB0WQk9faNfynep_66jyKEHy=uawy03r...@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.
