Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Having multiple columns in a pivot table
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Having multiple columns in a pivot table
 Login/Join
 
Member
posted
I have a report that I want to display multiple columns in a report like, name, email, room number etc and sum by date field. I get the error message (FOC029) All sort keys are not in a single top-to-bottom segment path.
Does someone know how I could get me display regardless the number of columns.

This message has been edited. Last edited by: FP Mod Chuck,


WebFOCUS 8105
Windows, Excel
 
Posts: 15 | Registered: November 03, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
PO

It sounds like the master file being used has JOIN's in it that are joined using 1 to many. Try changing the joins to be unique and I think this issue will go away.


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1637 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Member
posted Hide Post
That worked.

Thanks


WebFOCUS 8105
Windows, Excel
 
Posts: 15 | Registered: November 03, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Having multiple columns in a pivot table

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.