1 Reply Latest reply on Jul 20, 2011 8:08 AM by NaturSalus

    Sub-summary field not shown on Report in Preview mode

    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