group on range

[Guest]

I have these fields: sales date, salesprice, days on market
I have created groups for sales price using a range as the group break:
100,000-200,000
200,000-300,000
etc.
I have created a group for sales date using the year as the group break
I want the report to group and sort like this:
sales price 100,000-200,000

ave days on mkt 2005 120
ave days on mkt 2006 90

sales price 200,000-300,000
ave days on mkt 2005 150
ave days on mkt 2006 75
etc
I just can't get the years to group under the price ranges
And I can't get the price range to format as currency

 

[Marshall Barton]

I have these fields: sales date, salesprice, days on market
I have created groups for sales price using a range as the group break:
100,000-200,000
200,000-300,000
etc.
I have created a group for sales date using the year as the group break
I want the report to group and sort like this:
sales price 100,000-200,000

ave days on mkt 2005 120
ave days on mkt 2006 90

sales price 200,000-300,000
ave days on mkt 2005 150
ave days on mkt 2006 75
etc
I just can't get the years to group under the price ranges
And I can't get the price range to format as currency

To group on the year, just add a group level under the price
group using the expressionL =Year([Sales Date])

To get the group header to format the prices, use a single
text box with an expression like:
="sales price " & Format([lower range value], "Currrency")
& "-" & Format([upper range value], "Currrency")

But I have no idea where/how you have calculated and stored
the range values.