| Reseting Counter [message #121198] |
Thu, 26 May 2005 16:07  |
Prince
Messages: 32
Registered: December 2001
|
Member |
|
|
For a report with the following sample query:
Select supervisor, emp_name
from employee;
There is a 1 to Many relationship for column supervisor. Now I want to be able to reset my counter on emp_name when the value for supervisor changes. How can I do this, any advise would be greatly appreciated.
Prince.
|
|
|
|
| Re: Reseting Counter [message #121373 is a reply to message #121198] |
Fri, 27 May 2005 16:54  |
danosw
Messages: 20
Registered: May 2005
Location: California
|
Junior Member |
|
|
Based on your query... and I assume you dont want to repeat the supervise name.
------------
Groups:
G_1
col: supervisor
col: CS_1 : Function=Count, Source=emp_name, Reset At=G_1
G_2
col: emp_name
Layout:
R_1 : Source=G_1
field: F_SUPERVIOR
field: F_CS_1
-> R_2 : Source=G_2
field: F_EMP_NAME
-------------
I assume you want to count the number of employee for each supervisor. The key is setting two parameters in your Column_Summary 1) Source to emp_name and 2) Reset At to G_1.
I hope this is clear to everyone.
-
Attachment: 1.jpg
(Size: 27.91KB, Downloaded 1178 times)
[Updated on: Fri, 27 May 2005 17:06] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
