AnsweredAssumed Answered

Reporting and Grouping Data

Question asked by ricklhamilton_1 on Aug 20, 2009
Latest reply on Aug 20, 2009 by ricklhamilton_1

Title

Reporting and Grouping Data

Post

Newbie Question

Trying FM Pro 10.0. I am curiuos how deep I can get with creating reports. Already hit my first wall.  :)

 

I have a very simple data set and I want to Group the detail under the Category "SubSummary" The dataset looks like:

 

categoryID(Number) 

subCategoryID(Number)

Category (Text)

SubCat(Text)

DetailItem1 (Text)

DetailItem2 (Text)

 

I have used the report wizzard -Selected these field - told it to use "Group", sort by CategoryID and then by subCatID blah blah

 

In the layout I have

 

Header

 

subSummary  [categoryID]

 

Body  [subCat] [DetailItem1]   [DetailItem2]

 

The issue is 2 fold.

1) The report view is not breaking at the Category

2) Becasue of this I cannot put a subSummary description on the report

 

I'm trying to get the report to look like:

 

MY REPORT

 

CATEGORY 1

____________________________________________

    SubCAT1    Item 1        Item1more detail

    SubCAT1    Item 2        Item2more detail

    SubCAT2    Item 1        Item1more detail

 

CATEGORY 2

____________________________________________

    SubCAT1    Item 1        Item1more detail

    SubCAT1    Item 2        Item2more detail

    SubCAT2    Item 1        Item1more detail

 

 

I cannot get it to break and when I place the field   [Category]  (text) in the SubSummary it does not appear... at all.

I imagine there is something hacky I need to do becasue it feels like (and all the documentation covers) is using the Subsummary to calculate sub totals. I don't have that requirement.....

 

 

Outcomes