It would be possible to use Data Export Profiles to export this information from the database. While it's not as straightforward as using the built-in reports, it should certainly give you the data you are after. You can specify a date range for the data you wish to export and the resulting data file can be imported into Excel or similar for manipulation as you wish. It would, unfortunately, give you all transactions (for the specified period) regardless of the bank, but you can use Excel to sort on the desired bank and then remove any transactions which are not relevant.
Data Export Profiles can be defined under the System context in Administrator. Add a Data Export Profile there - you can define which columns you wish to include in your resulting data file (and the order of those columns). Click the 'help' option in the Actions panel in that context - at the bottom of this help page is the 'related links' option which will provide information on how to use the ExpTrans.exe tool to run the profile - this is where you specify your date range.
When creating the export profile, select the 'Print Transactions' option in the 'Export Records' setting (the default is 'Transactions', which gives different column options)
When creating the export profile don't specify any Groupings (as this will give you summarized results rather than individual transactions).
The ExpTrans.exe tool will produce a txt file in the Pharos\Bin folder. If you select the 'comma' as the separator in the export profile, then you can rename this file to .csv - and it can be imported into Excel
The ExpTrans/data export profile method is a great way to collect data for monthly metrics. It allows for a scripted solution on a schedule or by dates selected by a user. It also gives you as much or as little data as you need. One thing I have never liked is how it drops files in my pharos/bin folder since I'd prefer not mess with that folder unless upgrading, etc.
This is the portion of the script that runs exptrans.exe
::change disc so you can be local to the bin folder when making these file moves
cd c:\<YOUR PHAROS SITE INSTALL PATH>\pharos\bin
::Run ExpTrans.exe with profile in Uniprint. I designate variables that I select with the start and end date so I can automate it like a rolodex.
.\ExpTrans.exe -profile printsbymonth -start %var1% -end %var2% >nul
:: allows user to specify file name
set /P _metricsfile=Please enter a name for your file(example, My Metrics File):
:: moves file from pharos\bin according to the export profile name you chose in uniprint
move "E:\Program Files (x86)\Pharos\Bin\printsbymonth[%var1%,%var2%].txt" "%userprofile%\desktop\"%_metricsfile%".txt >nul
Loyd - you are right - a good improvement would be to allow the specification of the path for the output file. However, as a workaround you can get the file to create in whichever directory you wish by running the command prompt from the desired directory and calling the exptrans tool using the full path to the ExpTrans exe in the Pharos\bin folder. Eg, if you would like it to output the file in the c:\temp folder, have the command run from the c:\temp folder and run the full command:
C:\Temp>"c:\program files (x86)\pharos\bin\exptrans.exe" -profile printsbymonth
Any way to see transactions by Purse?
Unfortunately there is not a way to see this. When a Debit is done against a User the funds are taken from the first Purse, if this is empty then it moves to the next Purse that has money.
Credit Transaction however are recorded in the database with the Purse that was credited.
Actually he already is aware of this feature request since I spoke to him about it in New Orleans. But please do prompt him again. What we are looking for is the ability to report on transactions from a purse so that we can have a free allocation for the student paid for by their department or other funding source. But we need to be able to list the transactions from the purse to charge back the cost to the department.
Not sure if this is helpful for your original question but have a look at the below query and the results it produces.
SELECT Bank, [Transaction Type], COUNT(bank) AS Total
GROUP BY bank,[Transaction Type]
ORDER BY bank, total DESC
Bank Transaction Type Total aCanonBank Copy 19 aDirectBank 3 aHP-Bank 17 aKioskBank Credit 4 aKioskBank Custom 1 aKMBank 11 aKMBank Copy 7 aPPC-Bank 11 aRicohBank Copy 4 aXeroxBank Copy 19 aXeroxBank 2 Default Bank 162 Default Bank Computer 30 Default Bank Copy 8 Default Bank Credit 5 Default Bank Custom 2 Pharos Remote Bank 19