AnsweredAssumed Answered

Sub-summary field not shown on Report in Preview mode

Question asked by NaturSalus on Jul 20, 2011
Latest reply on Jul 20, 2011 by NaturSalus

Title

Sub-summary field not shown on Report in Preview mode

Post

Hello,

I have a simple project for keeping track of foods.

In the attached image the database structure is shown.

The Foods table contains all the fields of the database. The relevant fields to my next questions are:

__kpFoodsID

FoodCategory

FoodSubcategory

FoodName

...

The FoodCategory field values are selected from the Food Category value list.

The FoodSubCategory field values are selected from the Food SubCategory value list.

There is a Conditional value list relationship established between these two value lists.

I have a Record Selection script attached to a button that when activated selects the records based on the preestablished criteria.

The database works fine as well as the script that selects the found set.

I have a Report Layout named Beneficial Foods based on the Foods table that I use to list all the foods that meet the preestablished criteria established in the record selection script. The structure of the Beneficial Foods report layout is the following:

Header:

Beneficials Foods (text)

Food Category (text)

   Food SubCategory (text)

       Food Name (text)

Sub-summary by FoodCategory(Leading)

FoodCategory::FoodCategory (field)

Sub-summary by FoodSubCategory(Leading)

     FoodSubcategory::FoodSubcategory (field)

Body

      Foods::FoodName (field)

Footer

Page Number (text)

After running the Record Selection script and doing a Records -> Sort Records by:

FoodCategory::FoodCategory 

FoodSubcategory::FoodSubcategory

Foods::FoodName

in Browse mode, I can see the found set contents for the three fields: FoodCategory, FoodSubcategory and FoodName

However, when I move to Preview mode I can only see the contents of the FoodSubcategory and FoodName fields.

What I want is to have is a list of all the records that meet the selection criteria. And so far with my current settings that is not occurring.

Any ideas on how to sort this out is much appreciated.

Thanks

food_db_structure.jpg

Outcomes