>I need to print report, which consist of 3 independent reports (I process 3 different program), but my boss want to combine in 1 report ( I wish I could have 3 detail bands). Any ideas, how to do this in VFP 5.0a.I tried to send to ASCII file and then use automation with MS Word, but because I am using proport. fonts, ASCII files look terrible.
>Thanks in advance for help.
>Jerry
Hi Jerry,
I've done the same kind of thing with FPW2.6 reports without using Crystal, but it's not pretty. What I did to solve it is look at the three reports, and identify a common key that can be used for grouping. (In one case, I had to create my own key). I then use SQL statements to create temporary cursors that can be linked together to a parent table/cursor using SET RELATION. In some cases, I'm relating the cursors together on different fields, and the parent table/cursor is actually what drives the print job. Then I using a mess of report groups, and simulate additional detail bands in group footers. Like I said it's not pretty, and often I have to programmatically issue my REPORT FORM command in a loop to print one report per common key.
I am in the process of redeveloping my reporting system in VFP5.0a, and my plan is to replace these messy reports with a single report done in Crystal like Craig suggested. HTH
Roxanne M. Seibert
Independent Consultant, VFP MCP
Code Monkey Like Fritos