Ditch the idea of Report data environments. Create the cursor you want externally and then run the report which will use the cursor as data. That way you don't jave to prefix field names with the table and you don't get into a mess with page/group breaks etc as you can see the data you import into the report first by browsing BEFORE the report. The added bonus is that it is really easy to make the report external to the .exe so it can be changed at will.
I limped along for many years using report DE's and invariably they cause problems which are very difficult to fix. You know it makes sense and it makes the reporting process more modular i.e. data extract first then report. Dave -----Original Message----- From: ProFox [mailto:[email protected]] On Behalf Of Joe Yoder Sent: 29 June 2015 20:14 To: [email protected] Subject: Cursors and Report Writer for a beginner I am working on an application that reads in a pair of .CSV files, tweaks their data, and then call the VFP report writer to produce a paper report. 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 When I did the report using tables and then recreated the tables the report would no longer run. Apparently the wizard adds index tags to the tables which my rewrite eliminated. It is probably obvious that I have very little experience with One to many reports so am stumbling around finding lots of things that don't work. If someone could suggest the best approach for a beginner I think it would save me a lot of time. My preference would be to stay in cursors and setup the environment in code before calling a report. I will have multiple reports and will find it easier to understand the code in a .prg rather than buried in the report. Thanks in advance for any help, Joe --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [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/[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.
