Joe Yoder wrote on 2015-06-29: > 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
Joe, Now that you have the report set up. Open it for editing. Then open the Data Environment. You'll find it under the "View" menu. There you should be able to see the Tables you used, and the relationship that was set between them. The key should be listed in the properties of the Relation object. Now you have the information needed for updating the code to use the Cursors, INDEX ON, and SET RELATION TO. You would need to remove those from the Data Environment before you can use the Cursors. Be sure to have the Parent Table selected when you run the report. 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.
