Reporting Problems

[Mark Appleby]

I have a multiple file report that should give me an easy to view and interperit report. It isa stock report basically divided up into Supplier of item,which may relate to many departments of Item which can in turn lead to many catagories of item which has many styles of Item which finally shows all the items for this style. The report is based in the items file.

When I am in browse mode I see everything as I would expect it to be. But when I go to preview or print in leaves out all my previuos headings eg Supplier, Department, Catagory, style and just gives me the items. Believe me this is not what I want to produce, as all I get is the stock reference and number information but none of the descriptive stuff that is in the other summaries. What am I doning wrong? I am lost.

[LiveOak]

In a report with a lot of nested subsummaries, if they don't appear correctly in Preview or when printed, the problem is almost always sort order. You must sort by every field for which there is a subsummary and in the correct order.

If your nested subsummaries are by Supplier, Department, and Category, you must sort by:

Supplier

Department

Category

-bd

[Mark Appleby]

Brent,

I am still having the same problem. I have checked that I had the same sort order and it is still happening?!? I can not figure out why.

The Design is:

Supplier

Department

Catagory

SubCatagory

Style

Items

Everything is coming up blank as far as items. Not in browse just in preview and print? I am thaking my fields from the style file which are in many cases calculated could this be the problem? Is there anything else that I may have forgotten?

[Mark Appleby]

I think that I found the problem. It worked once I told it to include summaries!