dave
03-22-2006, 06:15 PM
If all you want is to keep track of the number of reducers in any project, here is an easy way. In Data Manager, create a new view called reducers. Open your SQL view and paste this string:
SELECT PID_LNK.TAG_TYPE, PID_LNK.LINK_ID
FROM PID_LNK
WHERE (((PID_LNK.TAG_TYPE) Like "%REDUCER"));
That will give you the reducer and reducer LINK ID. Then you can set up your report to total. There is another longer harder way to do it but if all you want is a running total, this is a good quick way.
SELECT PID_LNK.TAG_TYPE, PID_LNK.LINK_ID
FROM PID_LNK
WHERE (((PID_LNK.TAG_TYPE) Like "%REDUCER"));
That will give you the reducer and reducer LINK ID. Then you can set up your report to total. There is another longer harder way to do it but if all you want is a running total, this is a good quick way.