Reports Help

[sanders720]

I have some data in a table, including three categories which are HOT, WARM and COLD. I would like to separate the data in my report based on all the items checked HOT, WARM and COLD - with a header.

Currently, I have headers setup for each, but I'm getting duplicate header information.

How is the data supposed to look. Does the data still go into detail? It must, or how would the program know to put multiple data instances in.

I would also like to add a fourth category to my report, but this uses a different table with similar information.

How can I integrate all of this into a report.

Thank you in advance for yor help...

 

[pdldavis]

Hi, If hot, warm, cold are in a Field in your table named Temperature for example, sort first on temperature. Turn Group Header to Yes. The other grouping options commonly used Keep Together - Whole Group. You can also right-click on the new group header and set format to Force New Page - Before Section - which page breaks when the Temperature changes. You would have only one group header under this circumstance - not three.

The rest of thr data would go into the detail section of your report.

The fourth category, which uses similar data can be brought into the report if it can be linked to your other table in the reports underlying query, incorporating the additional field(s). It can also be brought in as a sub-report, whichever is more appropriate.

Hope that helps. If not, if you could be more explicit as to where, hot, warm and cold are - it would be helpful.