SHOW ALL *not* showing all ????

[ron G]

Here is a weird anomoly:

This report is sub-summarized on Company and then on OptionSymbol. It works well.

At the top of the report is a global field g.LowerTransactionDate. I have a script trigger on this field that runs this script:

When I enter Apr-11-2009 I don't get Expiration Dates GREATER than that date for both WellsFargo and Apple. I just get the values for Apple.

What am I doing wrong?

Edited July 18, 2009 by Guest

[LaRetta]

Why are you constraining your found set? If you have another portion of the find script that we are not seeing (prior to this) that produces a found set (and you are only showing the constrain portion) then your problem probably exists there (in the prior script portion. If this *IS* your find script then you should be using Perform Find [] and not constrain. :wink2:

[ron G]

Thank you for the reply.

There is no script in the production of the original sub-summary layout.

The problem is as follows:

There are 2 global date fields at the top.

g.lowerTransactionDate -

g.uppertransactiondate.

Originally I wanted FM to dynamically change the displayed records as the lower date was selected and then again when the upperdate was selected. But, since I can't tell if the user starts with the lower or starts with the upperdate the attached script to each could not reliably use Perform Find vs Constrain Found set.

So, I decided to collect both dates and then use a single button to execute a FIND on the combined dates. That script is in the .jpg above.

I am not sure if the syntax is correct but the affect is it doesn't work. I have fooled around with different syntax combinations and nothing seems to really work.

This script is:

Enter Find Mode[]

Set Field [OptionTransactions::expdate; ">" & Global::g.lowerTransactionDate & "and" & "<" & Global::g.upperTransactionDate]

Peform Find[]

Sort Records [Restore;No Dialog]

When I run debug, nothing is entered in the search field (expdate).

Got any ideas??

Edited July 19, 2009 by Guest