Information générale
Catégorie:
Gestionnaire de rapports & Rapports
>>>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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement