Problem categorizing a view

Hi All,

I’m having a funny problem trying to categorize a view. Here is the view:

The Personnel Form is the main doc.

The Monthly Form is a response to the main doc.

The Activities Form is a response-to-response doc (a response to the Monthly Form).

In order to show the view as desired, I had to uncheck the “Show responses in a hierarchy” option.

There will be ONLY ONE Personnel document and for each month ONLY Monthly doc, but there can be a lot of activities for a specific month. This part is working fine.

What I’m trying to do is to show the “Monthly Accomplishments” and “Activities” words ONLY ONCE.

That way I would have in the view:

→ Monthly Accomplishments
→ July 2008

 -> March 2008

→ Activities
→ July 2008

 -> March 2008

BUT I"m not managing to do that.

The column formula is:

@If(Form = “formA”; “Personnel Document”; Form = “formB”; “Monthly Accomplishments”; “Activities”)

And this column is also categorized.

What am I missing?

TIA,

Renan

Subject: Problem categorizing a view - SOLVED!

Never mind people!

There was a hidden column in the view that was in the wrong place (this column controls the month descending). I changed its position and it’s working now.

Thanks anyway,

Renan