Specific report questions

I'm trying to create a report that shows all information regarding transactions for a particular time period. I don't want them detailed by transaction #, just transaction number, date, taxes & total (and each one having a sum & the top). This way I can manually generate journal entries into quickbooks. I have 2 taxes, PST & GST (I'm in Canada), but I cannot make a column for each one? Trans#, date & total are easy from the transaction table, but if I report taxentry.tax it gives and line item for each tax group and throws off the sums.

import the info into QB, just not using the auto posting routine. You must use the iif file method.

Could a trigger be created to save the GST & PST amounts into a separate table? I really don't know what sql is used to post a transaction...