Thanks for all the help and validation of my prefered approach! I got the report detail going with cursors when I finally included the SET SKIP command. I don't think I have used that for at least 15 years.
Now I need to add a summary at the end of the report showing totals from the report detail summarized by discount type, item type, and payment type. The item type summary needs entries for earned versus unearned income based on the report date in relation to the date of the event being paid for. Should I use the report writer to generate summaries or do it in code and use the report writer to format it? I do want to have the report print everything in one run. If I do the summary externally do I use a Report Summary band and I add multiple Header and detail bands to it to I include the data from the Disc, Item, and Pay cursors? Better approach? Final question - I need pdf output. CutePDFwriter? Thanks in advance, Joe On Tue, Jun 30, 2015 at 6:35 AM, Dave Crozier <[email protected]> wrote: > If your data is consolidated into one cursor you don't have to prefix the > field names with the cursor alias as long as you select the cursor > immediately before running the report. > > Dave > > -----Original Message----- > From: ProFox [mailto:[email protected]] On Behalf Of Man-wai Chang > Sent: 30 June 2015 11:34 > To: ProFox Email List > Subject: Re: Cursors and Report Writer for a beginner > > A cursor is a table, just that you cannot use drag-and-drop it into the > data environment in design time. > > Just design your report using the cursor's alias as table name. > > On Tue, Jun 30, 2015 at 3:13 AM, Joe Yoder <[email protected]> wrote: > > I started out assuming that I could build cursors to feed the report > > but discovered that the report writer wizard wants tables. When I > > tried a workaround I got into trouble so I caved and switched to > > tables > > -- > .~. Might, Courage, Vision. SINCERITY! > / v \ 64-bit Ubuntu 9.10 (Linux kernel 2.6.39.3) /( _ )\ > http://sites.google.com/site/changmw > ^ ^ May the Force and farces be with you! > [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/cabqednxxsaznxioycmpyfohutpee1furymwxsbde7n2hz5a...@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.
