General information
Category:
Reports & Report designer
>>>Is there a way to send the output of a SUMMARY report created from 4 tables to a new table?
>>>Thanks
>>
>>Raymond, why not just make a SQL to get the summary results you want? (I may be missing something here...)
>>
>>Barbara
>I am already producing a report of all order forms for a month from an SQL of 4 tables. This SQL naturally gives me each order line item. What I am interested in is only the summary of each order for this report and I would like to send the results to a new table.
>Raymond
Probably you can do an workaround and print the report to an ASCII file, import the file in a table, etc. But this is nasty to be done. Also, everybody expects MS to change the report designer in the future versions of VFP. I don't have more info than you on that, but I prefer to not do workarounds in a VFP part that may be changed seriously.
I believe Barbara is right. Use your cursor/table to extract the data in the way you want using a SELECT-SQL. (Or maybe you can rewrite the SQL you already have.) The result of this SQL will be the table you want. Use the new table/cursor to print the report.
This will be much faster, solid code, almost no risk vs. future changes. Using the Report Designer to build a new table is like using a hammer instead of a screwdriver.
Vlad
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only