Sage 100

I am trying to export a report, by vendor (or product line), of the quantity of items sold AND issued for the last 12 months. We would like to be able to export it using any custom date range that we want. What is the best way of getting this data? I…

I have a parameter field link to the CI_Item for Value Field, I would like to have only the Type 1 item show up in the drom down, what is the best way to manage the parameter field in crystal reports? or can I do something like this?