This sounds like a matter of scripting a process to:
- perform a find on the catagory you want reported, assuming you really mean one category. (You could also do reports summarized by category on All or a Date Range of records; also doable with scripting.)
- Sort the records into the order you need for the report.
- Switch to a layout which contains the fields you want reported,
- Print, Preview, or Save as PDF file.
There is also an option under the New Layout dialog to create a report layout, though the result is generally a good starting point only -- not really a final report. During the New Layout creation, you can also specify to make a script to run it, though you will need to edit the script if you want it to include any specific searches, as the default generally acts on the found set of records.
Take a look at the built-in FM Help sections on New Layouts, Report layouts, and sorting sub-summary parts for more ideas.
Thank you Stephen for the reply. I'll try what you mentioned.