How do you merge cells in crosstab

Silverfox

I have created a report that uses a csv file as a datasource format as below:
sitename,date_time,risk,rain_expected,rain_maximum
GENEVA,05-DEC-2011 03:00,Low,.014,1.559
GENEVA,05-DEC-2011 04:00,,.014,
GENEVA,05-DEC-2011 05:00,,.055,
GENEVA,06-DEC-2011 06:00,High,.069,2.038
GENEVA,06-DEC-2011 07:00,,.288,
GENEVA,06-DEC-2011 08:00,,.929,
LONDON,06-DEC-2011 03:00,Medium,1.016,1.559
LONDON,06-DEC-2011 04:00,,1.016,
LONDON,06-DEC-2011 05:00,,.673,
LONDON,06-DEC-2011 06:00,Low,.082,1.199
LONDON,06-DEC-2011 07:00,,1.016,
LONDON,06-DEC-2011 08:00,,.673,

This produces a Cross Tab report that looks like this:

LONDON | GENEVA

---

RISK | EXPECTED | MAXIMUM | RISK | EXPECTED | MAXIMUM

---

05-DEC-2011 | 03:00 | Low | 0.014 | 1.559 |Medium| 1.016 | 1.559

---

05-DEC-2011 | 04:00 | | 0.014 | | | 1.016 |

---

05-DEC-2011 | 05:00 | | 0.055 | | | 0.673 |

---

05-DEC-2011 | 06:00 | High | 0.069 | 2.038 | Low | 0.082 | 1.199

---

05-DEC-2011 | 07:00 | | 0.288 | | | 1.016 |

---

05-DEC-2011 | 08:00 | | 0.929 | | | 0.673 |

You will see from the report that the MAXIMUM values are only available every 3 hours, what I would like to do though is merge the three cells such that the report will look like this:


LONDON | GENEVA

---

RISK | EXPECTED | MAXIMUM | RISK | EXPECTED | MAXIMUM

---

05-DEC-2011 | 03:00 | Low | 0.014 | |Medium| 1.016 |

---

---

05-DEC-2011 | 04:00 | | 0.014 | 1.559 | | 1.016 | 1.559

---

---

05-DEC-2011 | 05:00 | | 0.055 | | | 0.673 |

---

05-DEC-2011 | 06:00 | High | 0.069 | | Low | 0.082 |

---

---

05-DEC-2011 | 07:00 | | 0.288 | 2.038 | | 1.016 | 1.199

---

---

05-DEC-2011 | 08:00 | | 0.929 | | | 0.673 |

Is there any way of doing this?
Regrds

mwilliams

I don't think it's possible to merge the cells like you're wanting. I think you'll have to manipulate your data to repeat the value for each row until it changes, so each row has the intended value, then figure out the order in which you need to hide the value in the crosstab to have the "centered" row contain the value. It seems like a lot of scripting, but it's probably possible. Maybe I'm wrong and someone else has an easy way to do this thought up!