>I had a somewhat similar problem in that I wanted to print a report with
>the color of each row controlled by the data in the report. To the best
>of my knowledge this cannot be done with a Paradox report.
>What I did instead was to create a form with a table frame of calculated
>fields. In general the fields just pulled the data in from the query.
>However, one of the fields tested to see if the sales for that part were
> 15% above or below the previous years sales and set the color of the
>row to green or red respectively.
>While it would be quite a bit more work, you could do something similar
>with your report. You would have calculated fields that initially
>printed the summaries and then printed the details based on a global
Having been burned, I always do report totals outside of reports using
separate query-sequences that culminate in running the report itself. In
fact, it is not uncommon for one of our reports to involve thirty or forty
steps before the report runs. That's why we developed the Paradox Report
Sequencer as an internal tool, and since released it to the public as our
ReportRabbit product. There was simply too much balderdash over the months
and years about report-subtotals and page-breaks and you-can-do-this-but-not-
that... Anyway it works, and the customers are none the wiser. Otherwise
you're doing too much work for every report, for just too many reports.