Format a field in a crosstab

[ready4data]

First off let me say that I'm new to CR9 so be easy on me.
I've been using MS Access for about 10 years and I want to try something different for reports.
I created a crosstab report with a field that sums up minutes. I want to show that field as HH:MM. I have a formula to do that but don't know where to put it. When I place the formula in the Summarized area It won't give me the option to Sum. If I place the actual field(duration) I can sum it but it isn't in the format I want HH:MM
Here is the formula:
Int(Sum({history.duration})/60) & " hr " & Sum({history.duration}) Mod 60 & " min"
thanks for the help
Scott

 

[synapsevampire]

With almost every language, a Sum works on numbers, and the HH:MM is a string.

I fear that you'll either have to create a manual crosstab, or live with a numeric display.

-k