>I want to know if a program or a report is the way to go on this.
>I have a transaction file: stock#, itemname, price, qty. If I want to see a listing(or report) of each different stock# with the number sold and the dollar amt sold, would a prg have to be the way to accomplish this?

Tim;

I do not know which version of FoxPro you are using. I will presume VFP. You could do this many different ways including calling a prg from a menu item. Another way is to create a report class and one of your selections would be a form which would allow the user to enter nothing (to obtain the entire record set if desired), or enter specific information like date ranges, and any other desired information. The point of this is to obtain a data set. You would use a SQL Select statement which would be a method of the form.

I use such a report class and have a menu selection which brings up a form with two list boxes. The upper list box is the title of the report and if you click on it once it gives a description of that report in a list box below the first one. Dougle clicking on a report title brings you to the report form, where the user can select the type of result desired (screen/file/report) and enter a range of dates, etc. The form has a grid so the data set can be viewed before the user takes action.

This is just one way to do it.

Tom