Hi Mike,

You are correct that there seems to be a limitation in Crystal Reports 4.0 (the engine that drives Quik Reports for Windows) as to the number of elements in an array. 24 is that limitation. There are two things you can do:

- You can combine multiple 24 element array statements separated by OR. For example:
If customer number in ["1","2",...,"24"] OR customer number in ["25","26",...,"45"] then...

This will allow you to be able to select from more than 24 choices.

- There is a newer version of this report writer available, now known as Crystal Reports for Adagio, It is based on the Crystal Reports 8.5 print engine (which is current technology as compare to 4.0 which is 7 years old). There is no restriction as to the number of elements you can put into a single array with this program.

In addition, you can use features such as Runtime Parameters, Subreports, Report Alerts, and lots of other neat stuff.

Regards,

Hello Mike Fluckiger,

It is not clear from your post what records you are trying to select, but ACCPAC and/or Adagio allow you to assign Item numbers, customers and vendors to "Report Groups". Have you considered setting all the specific items/customers/vendors that you're trying to select to a specific Report Group, and then selecting on that? It will be much faster than multiple comparisons.

Hello Mike Fluckiger:

If the set of invoice numbers completely arbitrary? or is there some way that you could identify the invoice numbers you are interested in? (For example, by prefixing the invoice numbers witha specific letter or letter combination, or by using the territory or salesman or tax ID fields in the Invoice Header to identify them.) Or are you trying to isolate those invoices that have been paid in A/R for calculating sales commissions (something that is handled automatically by Softrak's Sales Analysis module)?

Pricing for the upgrade to Crystal Reports for Adagio is available from your Business Partner (there was a special running till the end of June that we faxed all our registered end users about.)

Another option might be to check out Adagio GridView to place a display of all the invoices on the person's desk with from the Order Entry Header with the Invoice amount as one of the columns. Gridview lets you select an arbitrary set of numeric cells and right-mouse click to see the total of the selected cells.

Regards

Hello Ad?le,

The basic question is "what is unique about those invoices? Are they from a specific Bill of Lading? Purchase order number? They are not being chosen at random, or you wouldn't be selecting them.

Hello Ad?le,

Your answer contains a clue. "An invoice can be quickly added to or deleted from a shipment."

So these are all invoices that make up a single "shipment"?

I'm not looking for you to change your method of invoicing, I'm trying to determine how you know which invoice numbers to choose. If I knew that, then I might be able to figure out a simple way for the computer to be able to make the same decision.

I cannot check this out, but is it possible to edit the header of a posted invoice? If so, then it would be far easier to choose an unused field in the header, and enter a shipment number in that field, then select all documents with that shipment number. (Sorry I can't check this out for you.)

An alternative method, which is likely to be quite slow, is to change the selection formula slightly to:

{OE61B Orders and Invoices Headers.Document type (order, invoice, cr note)} = "Invoice" and
({OE61B Orders and Invoices Headers.Invoice number} = " 91037" or
{OE61B Orders and Invoices Headers.Invoice number} = " 90991" or
{OE61B Orders and Invoices Headers.Invoice number} = " 90969" or
{OE61B Orders and Invoices Headers.Invoice number} = " 91023" or
{OE61B Orders and Invoices Headers.Invoice number} = " 91022" or
{OE61B Orders and Invoices Headers.Invoice number} = " 91015" or
{OE61B Orders and Invoices Headers.Invoice number} = " 91012" or
{OE61B Orders and Invoices Headers.Invoice number} = " 91011" or
{OE61B Orders and Invoices Headers.Invoice number} = " 91003" or
{OE61B Orders and Invoices Headers.Invoice number} = " 91002" or
{OE61B Orders and Invoices Headers.Invoice number} = " 91001" or
{OE61B Orders and Invoices Headers.Invoice number} = " 91000" or
{OE61B Orders and Invoices Headers.Invoice number} = " 90999" or
{OE61B Orders and Invoices Headers.Invoice number} = " 90983" or
{OE61B Orders and Invoices Headers.Invoice number} = " 90980" or
{OE61B Orders and Invoices Headers.Invoice number} = " 90975" or
{OE61B Orders and Invoices Headers.Invoice number} = " 90968" or
{OE61B Orders and Invoices Headers.Invoice number} = " 90965" or
{OE61B Orders and Invoices Headers.Invoice number} = " 90962" or
{OE61B Orders and Invoices Headers.Invoice number} = " 90958" or
{OE61B Orders and Invoices Headers.Invoice number} = " 91045") and
not ("FRT" in {OE61B Orders and Invoices Details.Description}) and
not ("FREIGHT" in {OE61B Orders and Invoices Details.Description}) and
not ("DISCOUNT" in {OE61B Orders and Invoices Details.Description})

When you run the report, you will edit the selection formula each time (no change there). Add or delete lines to select the invoice number you're looking for. Use the Windows cut-and-paste keyboard shortcuts (ctrl-x to cut, ctrl-c to copy, ctrl-v to paste, shift-arrow to select) to quickly copy and paste lines. (Place the cursor at the beginning of a line, type shift-downarrow to select the line, press ctrl-c to copy the line, press ctrl-v twice to make a copy of the line - the first replaces the highlighted text with itself, the next ctrl-v inserts a new copy).

Hello Adele,

This would have to be done in the designer, not when the report is being run. That is, you'd have to edit the selection formula before printing the report, you could not structure this as a run time parameter.

If nothing was selected, then that means the structure of the record selection rule is not selecting any records. Cut and paste the selection formula you tried here.