>I have all the basics of all my reports for this inv. program done I am doing the newest reports the Nursery now wants and they are based on strain "or name if you will" what they is asking me to do is create reports on all of their fastest moving plants and flowers in all appx 20 or so reports but she wants the reports based to only show 1 strain or name per report how would I go about this I have tried creating a couple of expressions in the report properties this did not work (Alias not found)and totals and all are ok but I get all records.
>
>Any ideas??

Sure. Set up a report group based on the field name that is used to record the strain of the plant being sold. Establish subtotal fields in the group footer band, and you should have sales numbers for each strain. If you need a separate 'report' for each strain, you can check the box that tells the report writer to start each group on a new page, and to reset the page number to 1 for each group. Oh, and the data should be indexed, first by strain, and then by, well, whatever order they want to see the data.

Even better, do a SELECT statement into a cursor, and use the cursor for the report. Powerful stuff - the sooner you start to use it, the more valuable you'll be to your client.

>Thanks,

You're welcome.