Creatingn a dynamic table?

[alwayslrN]

I am using Crystal XI.

What I would look to do is display data as follows

Year Value Year Value Year Value
2007 100000 2012 53000 2017 0
2008 150000 2013 0 2018 155000
2009 106000 2014 53000 2019 0
2010 200000 2015 55000 2020 154000
2011 100000 2016 53000 2021 165000

Please note the following:
(1) the maximum and minimum year is not none so would have to be built dynamically based on the data - so far I have seen the maximum year as 2066

(2) the above made up data is based on the grouping by the year of the maturity date and value is the sum of quantity for each year

(3) I is possible not to actually have a year populated for data the year would not exist in the grouping, but I need to display the year and the value would have to default to zero

What would be the best way to accomplish the table, keeping the notes above in mind?

Would I have to use 3 arrays (assuming I extend the number of items in each row) with the lower and upper bound values being the minimum and maximum years?

Thanks

 

[IdoMillet]

Outer join from a year table to the transaction/value table. Then, insert a CrossTab.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com