<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Jeff Harrison wrote:
<blockquote cite="mid20060330172400.68279.qmail@web50702.mail.yahoo.com"
type="cite">
<pre wrap="">--- Boaz Bezborodko <a class="moz-txt-link-rfc2396E" href="mailto:boaz@mirrotek.com"><boaz@mirrotek.com></a> wrote:
[snip]
</pre>
<blockquote type="cite">
<blockquote type="cite">
<pre wrap="">
</pre>
</blockquote>
<pre wrap="">I have a few questions regarding associated fields
in a report.
What happens if the associated field you're trying
to determine is not
the primary sort?
What if there are two different associated fields in
the sort?
Is there a way to determine which instance is being
dealt with?
Thanks in advance.
Boaz
</pre>
</blockquote>
<pre wrap=""><!---->
Good questions.
#1 I tried a simple test and it appears that the
record is not included multiple times in the output
unless the associated field is the primary sort.
#2 I tried a simple test using two associated fields
a0) and a1) with three instances (rows) in the data
for each record. I used a0 as the primary sort and a1
as the secondary sort. When I ran the report each
record appeared 3 times in the output - which is the
behaviour that I was hoping for - and it was
automatically sorted by the a0) value. For each a0
value that was the same, I could see that the
secondary sort was applied properly.
#3 Yes, @af tells you the proper instance that you
are dealing with.
Jeff Harrison
<a class="moz-txt-link-abbreviated" href="mailto:jeffaharrison@yahoo.com">jeffaharrison@yahoo.com</a>
Author of JHExport and JHImport. The easiest and
fastest ways to generate code for filePro exports and
imports.
</pre>
</blockquote>
In #3 is there a way to tell which instance of the secondary sort is
being dealt with?<br>
<br>
Thanks again,<br>
Boaz<br>
<br>
</body>
</html>