graphic container representing a summary field

[Pat]

I'm trying to make a graphic representation of the 'n' in a cell of a table, the number which is a summary value. I created a repeating container field (r = 10) with a graphic representing one, up to ten in the 10th repeating field.

Let me call the cell of the table in this example 'A'

The summary field for the number represented in cell 'A' is 'A_summary'

The field with the container is 'A_graph' and sits in the A cell

The graphic comes from a related table (Xjoin) called N_Graphics(repeating, 10 repeats).

I tried to define the container field, 'A_graph" like this:

Case(

A_summary = 1;

GetRepetition(N_Graphics::10pics; 1);

A_summary = 2;

GetRepitition(N_Graphics::10pics; 2);

etc through value of 10.

This was intended to show, for example, three little boxes if the N for Cell A was 3. However, it didn't work.

Any ideas? Thanks for your help!

[Fitch]

"It didn't work," meaning what? Your computer exploded? The "A_Graph" field is blank? What happened?

[Pat]

Computer is fine, but the field is blank when it should have a number of graphic squares.

[Fitch]

I think I see what's missing: the GetSummary() function. This is the only way to use the result of a Summary field in a calculation, and it only works when your found set is sorted by the breakField specified in the calculation.

I also find it more readable to write: field[1]

rather than: GetRepetition(field; 1)

So, your calc can be simplified:

N_Graphics::10pics[GetSummary(A_summary;breakField)]

Sorry for the delayed response.