I've got a program I'm redoing to run under the CDMM framework. In the original program, I started with approx. 10 different tables that have a Insurance co, a $ amount, a start date, and end date. My old program merged all the tables into a new table, then assigned a range value to the new table. The new table had a field called "Range" and I did something like

REPLACE range WITH "A. $0-$200" FOR amt <= 200
REPLACE range WITH "B. $201-$500" FOR amt > 200 AND amt <= 500
etc...

Then, I created a view off of this table that grouped all the entries by the insurance co, then the "Range" field created a couple calculated entries (a few SUM's, AVG, etc) and created a report from it.

In the CBMM program I am now working with "live" data, so I don't need to group the 10 different tables anymore. The table I'm using now has all the above information (except my "range" field) plus a bunch of other entries I don't need. I'm thinking I can create a view/DE that selects out the insurance, $ amount,start,end date. What I'm wondering is how do I assign the range values like I previously did? This "Range" field is only needed temporarily and I don't want it in my main table so I can't make the view updatable.

My first idea is to just create an array out of the view and make the changes there. But then I'm left with the problem of trying to pass the array to the report instead of a DE. I guess I could just put the code in the report itself and open the view in my report instead of my form.