Ghost groups

[Halfcan]

Hello,
I need to create a group that changes 6 times. This group needs to be created without using values in the database.
I use v8.5.
Ideas?
HC

 

[nagornyi]

Just count all records and break them into 6 groups based on which percentile of the total record number the current record count falls into.
So the idea of group-generating formula is:
if the record number in 1...to (16.66% of the total records) then 'Group1' else
if the record number in (16.66% of the total records + 1) to (33.33% of the total records) then 'Group2' else ....etc....else 'Group 6'

 

[Ngolem]

I'm not sure that is possible....Summary operations (count being one of them) cannot be used for grouping purposes.

Aside from that We don't know the reason for this grouping. Let us assume you can break up the records in the manner that you suggest...we are given no reason as to why 6 artificial groups like this are required. further grouping would be meaningless since the first grouping is really meaningless

Jim Broadbent

The quality of the answer is directly proportional to the quality of the problem statement!

 

[nagornyi]

I can imagine reasons for random grouping. For examples, existing invoices are randomly assigned to 6 different people for audition. Of course, something more to be said about the grouping, for example that the groups to be of about the same volume. Otherwise we can do this: first record goes to the first group, the second one goes to the second group, etc, the rest goest to the sixth group. I see no contradictions in this way of grouping with the initial question.
OK, I have anothier idea. Along with every record we select a number from 0 to 5. It can be, for example, the record number modulo 6. Then we just group by this field.

 

[Halfcan]

Thank you both for your responses, I wanted to use this random grouping as part of a bar graph. The "On change Of" area.
I wanted 6 changes to take place.
Basically, I would have wanted all records to be part of each of the 6 groups.
I have since figured out how to do the chart a different way, but am still intrested if anyone knows a way to create artificial these groups.

Thanks alot,
HC

 

[synapsevampire]

All records cannot be part of a group, the word group itself should help you to understand why.

To show all rows in 6 disparate areas you would use a subreports.

Perhaps you would be better served in the future to allow people to help with the architecture of the graph/problem.

-k