I'm using Crystal X with a provideX database as my source. I'm starting to write an inventory sales report and would like to select a specific list of about 300 items. It tried using multiple selection criteria (below) but it doesn't seem to work. Is there a better way to select a large list of items? I would place of of my selections in one array but Crystal appears to max out at a certain number.
Any guidance is greatly appreciated!
Any guidance is greatly appreciated!
Code:
{mytable.itemno} IN ["930-000", "930-002", "930-005", "930-006", "930-010", "930-011", "930-025", "930-013", "930-016", "930-018"]or
{mytable.itemno} IN ["900-130FS", "900-130NC", "900-130TC", "900-131A TC", "900-131FS", "900-131TC", "900-132FS", "950-088", "950-088FP", "950-089", "950-089 BP ATT.", "950-089A", "950-089F", "950-089F FP", "950-089F FPSD", "950-089FP", "950-090", "950-091", "950-092", "950-092TC", "950-093", "950-093F TC", "950-093HD", "950-094", "950-094HD", "950-095", "950-095A", "950-095F", "950-097", "950-098", "950-100", "950-102", "960-030FS", "960-031F FS", "960-032FS", "960-032NC", "960-032TC", "960-033A TC", "960-033F FS", "960-033F TC", "960-033FS", "960-033TC", "960-038FS", "960-039FS"]