<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
<title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Ok, I think I get it now, BUT.....<br>
<br>
I commented out the sort1=un; sort2=jobs[@af]&un; sort3=2 line and
set the first sort in the output processing to J1). That is now the
only sort defined. However, when I run the report using the same
selection I attached earlier (minus the above line), my test record
shows up 4 times (using debugger for employee 123) instead of the 2
times I would expect. The test record is below:<br>
<br>
EMPLOYEE#: 123<br>
<br>
DEPT JOB NO. COMP COST CODE RATE TYPE HOURS
EXTENSION<br>
352D10¦ 352000¦ DE658¦ 5200¦ 000¦ 28.71¦ R¦
8.00¦ 229.68¦<br>
387D10¦ 387000¦ DE658¦ 5200¦ 000¦ 28.71¦
R¦ 8.00¦ 229.68¦<br>
<br>
As you can see, there are 2 instances of job number for this record. I
would therefore expect to hit this record twice not four times using my
index on job number (J1). Any thoughts on what would cause this? I
rebuilt the index... no difference. I deleted and rebuilt the index
with no difference. @af show instance 1 then 2 for the first 2 times
and then 1 and 2 again for the third and fourth times I hit the
record. I should be selecting 196 "records". Since I made the above
change, the process now selects 205 so I think this is happening on a
couple other records but not all. The process also seems to take a
couple seconds longer than it did before.<br>
<br>
Jaime Perry<br>
<br>
<br>
<br>
Kenneth Brody wrote:
<blockquote
cite="mid20060330153910.5stdn0g488kwgcs8@webmail.spamcop.net"
type="cite">
<pre wrap="">Quoting Jaime Perry (Thu, 30 Mar 2006 15:16:11 -0500):
</pre>
<blockquote type="cite">
<pre wrap="">I am still not sure what you mean by using just the first field. I am
obviously missing something and I think you may be on the right track
but I am just missing what you mean. I appreciate everyones help by the
way.
Let me give you as much info as I can:
</pre>
</blockquote>
<pre wrap=""><!---->[...]
::sort1=un; sort2=jobs[@af]&un; sort3=2:
[...]
Here you have told filePro not to sort on an associated field.
--
KenBrody at BestWeb dot net spamtrap: <a class="moz-txt-link-rfc2396E" href="mailto:g8ymh8uf001@sneakemail.com"><g8ymh8uf001@sneakemail.com></a>
<a class="moz-txt-link-freetext" href="http://www.hvcomputer.com">http://www.hvcomputer.com</a>
<a class="moz-txt-link-freetext" href="http://www.fileProPlus.com">http://www.fileProPlus.com</a>
</pre>
</blockquote>
</body>
</html>