>Hi.
>I have a report which only displays certian records from a table. the table contains items and their prices. I am able to display only certian items from the table, but at the bottom I have a output field which is supposed to sum the displayed items prices. However, it displays the total of all prices in the whole database of items. Is there a way to total them in the report, or do I have to somehow figure that out before I generate the report?
> TIA,
Hi Jason,
Go into the report writer of Fox; select variables from the Report menu. Add a variable, count a field on your report and have it reset at the end of the report. Print this field in a summary band at the end of the report. If this is what you are doing already, then I suggest you use a SQL query to pull out the info you need to report on, since you will only receive those select records the count at the end of your report will be correct. Hope this helps. Monica
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