I use a program called Accware which uses Advantage database to store its data. Accware has predefined Crystal reports that pull our data from this database. I'm trying to modify one of the predefined reports. The report is a pick slip that is used pick orders from our warehouse. I want the report to total up the number of items for a given order. This will increase accuracy of the person picking the order by checking the total count of items they picked against this number. I have been successful at having it total but my problem is that the total also has none inventoried items in the total, like shipping, gift wrap. I have not been able to figure out how to have it total only inventoried items. There is a field in the database that indicates if it is inventoried or not but I do not know how to use it in modifying this report. When I asked support which has limited support in modifying Crystal reports they say:
"You will need to add a variable in the report and increment it manually for each inventoried item using a crystal report script. It should be fairly simple."
Can anyone shed light on what that means? I am new to crystal reports but not new to database work. Is it possible to post the Crystal report to this form? I would be interested any help within this form our outside this form. It sounds like for an experience Crystal report writer this would be quick work.
Any thoughts and suggestions are much appreciated.