Skip to Content
Former Member
May 11, 2011 at 08:32 AM

Variable or Subreport Conundrum


I currently have a very simple report setout as follows:-

Category (Group A)

Consultant A (Group B) 1st £X,XXX

Consultant B (Group B) 2nd £X,XXX

Consultant C (Group B) 3rd £X,XXX

The position of the consultant is based on the value (using group sorting expert). So in theory this shows who has sold the most revenue for that category. The report is fixed to show a 9 month period from the currentdate the report is ran.

I have now been asked to show the information in a different way. I need to show each Consultant (as Group A), with a grouping of the categories showing revenue, and also showing the position they are in for that category (i.e. 1st, 5th etc).

Consultant A (Group A)

Category A 1st £X,XXX

Category B 5th £X,XXX

Is this possible with either a sub-report or a global variable that records the position in the first report for the particular consultant and category and then is able to re-sort/re-group it in another report?

Hope you can assist.