I'm looking for some ideas on report design, if a reporting tool would help, etc.

We have an accounting system that allows you to specify a range of GL accounts when printing reports. However, a user is pointing to the competition that has a much more flexible front end to their report.

The other report UI allows for selecting multiple ranges of accounts. I've seen dropdowns used for this type of thing that allow for single or multiple selections. However, a dropdown wouldn't completely work due to the requirement of flagging the range to indicate how to subtotal it. In the other UI the screen looks like:

Range From: 010-00-00
To: 010-99-99
Break: x


The "x" in Break indicates to subtotal whenever the 2nd part of the account no. changes. There are a couple other properties that could be used to modify the range on the report, but the "Break" property is the most difficult part, I think.

Does anyone have any suggestions for creating a UI that can be translated into a report that would easily allow users to specify multiple ranges, along with breaks.

PF