- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic to the Top
- Bookmark
- Subscribe
- Printer Friendly Page
Modifying selection formula on standard MAS 90 report
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-26-2012 11:22 AM
Is it possible to modify the selection formula on a standard MAS 90 report? For example, my client ran the Customer Sales Analysis out of the Accounts Receivable module with the following criteria: YTD Sales > $1.00, PYTD Sales > $1.00. The report returned only those customers for which both of these criteria were true. What my client really wanted was YTD Sales > $1.00 OR PYTD Sales > $1.00. Can that be done with the standard Customer Sales Analysis report? If so, how?
BTW, my client is using MAS 90 4.4 so the report is written in Crystal Reports.
DWD Technology Group
"You've got to stand for something or you'll fall for anything."
Re: Modifying selection formula on standard MAS 90 report
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Highlight
- Email to a Friend
- Report Inappropriate Content
01-26-2012 11:37 AM
Instead of using the main screen to select the greater than $1, edit the crystal report and make the record selection criteria be:
{AR_CustomerSalesAnalysisWrk.DollarsSoldYTD}>1 or {AR_CustomerSalesAnalysisWrk.DollarsSoldPY}>1
If the dollar amount needs to be variable, then make parameters for the amounts for the user to input.


