PDA

View Full Version : Compound sort.



Michael Mullan
21-Feb-2010, 09:55 AM
I have a report which summarizes patient visits by month - See attached screen shot.

In the report I want to suppress the detail, and sum up by month "02/2010" etc. unfortunately I can't find a way to do this just using VRW. I did a work-aound by creating an "sMonth" field which shows the month/year as a string.

Is it intended that I should be able to add a function field to the report data, which breaks out the month and year, and then group & sort on this?

If I leave the sMonth as month then year, i get 01/2009, 01/2010, 02/2009,02/2010,03/2009, which is not so good.

so: can I create a a transaction summary report, by month?