Topic Options
#580 - 05/25/00 11:15 AM Re: Selection Criteria
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11670
Loc: Vancouver, BC Canada
Hi, CarlAlsafe

1. There is no way to include this in the report in QRWIN. QRDOS can do this, though.
2. To exlude the user from modifying the selection criteria in other compiled reports, use a formula for these fields & insert them into the report rather than creating a selection formula. There is no other way, other than unchecking the "Modify selection formula" checkbox in the report's dialogue window after executing the compiled report.

Hope this helps!


Top
#581 - 05/26/00 01:33 PM Re: Selection Criteria
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11670
Loc: Vancouver, BC Canada
Hi again.

Actually, although there is no way to actually insert the selection criteria into your report, there is a way to get the range of dates to print on your report.

You must create 2 formulas, 1 using the Minimum & 1 that uses the Maximum function. To do this:

1. Insert two Grand Totals for the field, one using Minimum and one using Maximum.
2. Create a formula with the desired text. For example, for a date field:
"This report contains transactions dated from " + ToText (Minimum({AR65A Current Customer Transactions.Documentdate})) + " to " + ToText (Maximum ({AR65A Current Customer Transactions.Documentdate})).

The only catch to this is that it will only report the highest and lowest values it encounters. If the selection formula specifies a date that does not actually appear on the report, the date range may appear to be inaccurate.

Sorry I had forgotten about this earlier.


Top


Moderator:  Softrak Support 
Who's Online
0 registered (), 137 Guests and 10 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1868 Members
5 Forums
14583 Topics
71186 Posts

Max Online: 1408 @ 12/09/25 01:48 AM
January
Su M Tu W Th F Sa
1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31