I can not offer account picklist. I think you are missing the requirement that the user select where in the account group the group break is to occur.
>Hi Perry,
>
>Regarding selection of accounts in this case I wld offer him
>account picklist (Form with grid/chkbox over a tmp cursor) with possibility to mass-select entire groups of accounts instead of chk/unchk them one by one. Add some ranges on that picklist in another words.
>No range can outdo this.
>
>Then use that acc-picklist cursor as driving alias for the report.
>
>As for break, that shoud be actually easy - It is ordinary report grouping
>or I am missing something here ?
>
>
>
>
>
>>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
(On an infant's shirt): Already smarter than Bush