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

Adagio Action Team

Registered: 03/09/99
Posts: 11616
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: 11616
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:  Christa_Meissner 
Who's Online
0 registered (), 80 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1872 Members
5 Forums
14527 Topics
70937 Posts

Max Online: 432 @ 01/20/25 10:17 PM
August
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