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 <[email protected]> wrote: > +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 > > > > [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/cabqednxjlplpcebwn_jwquc1teot6rwoyabm0enxl5sna2t...@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.
