AnsweredAssumed Answered

Self Join

Question asked by rwalsh on Apr 28, 2010

Title

Self Join & Display Unique Records in Portal

Post

Hi There,

 

I am currently working on a report where there are several parts.

 

Region (leading sub-summary on "repRegion")

Sales Rep (leading sub-summary on "_salesRep")

Body

Sales Rep Summary (trailing sub-summary on "_salesRep")

Region Summary (trailing sub-summary on "repRegion")

 

Now I have the basis of the report working, all the way up until I need to add some extra detail to the Region Summary part.

Within this section I need to list all the sales reps that are in that region within the found set, some counts and some sum values. Now I can't add another part to do this (or can I?), so I was trying to use a portal. But because I am using a self join,  I am getting duplicated values for the Sales Reps (all the counts, and sums work and are the same accross the board) but I just want to omit the duplicates from the portal? How can I achieve this?

 

 

Outcomes