I'd suggest you give the Transactions table a shot when building this report, using this as your master table should make the fields you need available. Keep in mind this is a list of all transactions, so you might want to apply filters while you’re out there.
The Method Report Designer will ask for a master table with the option of adding additional detail tables, these tables set the foundation the report will be built on. Once a report has been created you can modify the tables from the Report Designer by clicking File then Save As. A word of caution, changing the tables might affect previously used fields on the report.
Hope this helps,
Need more help? Ask us about Method consulting services.
Valbon Shabani
Director of Education
Method Integration Inc.
Toll Free: 1.888.925.6238 ext. 715
Local and overseas: 416.847.0400 ext. 715
Fax: 416.640.6027
E-mail: valbon@method.me
Website: http://www.linkedin.com/in/valbon