Impromptu Counts

[cogdev]

I am using Impromptu 7

Here is my Data

ID Action
12 go
12 stop
13 go
14 go
.

I have grouped by ID
So I get
ID Action
12 go
stop
13 go
14 go


What I would like to do is count the number of ID's per grouping. I am actually trying to implement something similar to 'having count greater than X', how can i do this?

 

[DoubleD]

The easy way is:
Click on the ID field in your Page View, click the Count Icon on your toolbar. It will generate a footer for each of your groupings, and put the count in those footers. Now in the Filter tab of your Query window, switch to the Summary filter and put in the summary filter.

Pain is stress leaving the body.

DoubleD

 

[cogdev]

I tried that, it puts the footer at the bottom of the report. I tried editing the data defination and changing the association from 'for report' to ID, still nothing happens.

 

[DoubleD]

Right click in the white space to the right of the report data, select Properties.
Go to the Layout Tab and check the ID Footer. This will cause it to show in your report. The ID field must be grouped for this to work.

Pain is stress leaving the body.

DoubleD