Cross Tab - Summary and Total Fields

[saran26]

Hi All,

I am using the crystal reports designer version 11.0.

I have a cross tab with the following field

Row column group -- date

Horizontal group - Time Ext

Summay fields - Max of time

The result set shows like this

Total Inhours InMinutes
01/04/2009 20 20 30


How to do that ?. Please help me out

I tried with the following formulat

if {clearquest.timeext}="Inhours" then {clearquest.time} else ({clearquest.time } * 60)

But it didn't work.

Thanks

Saran

 

[Madawc]

it didn't work

Please expand on that. Did you get nothing, or the wrong figure?

I'd advise first getting it working for detail lines, then do the crosstab. See what is happening and where.

If you get blanks, then you probably need to test for nulls, if not isnull({clearquest.timeext}) and

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[saran26]

Hi ,

When I use the above at the display string field, I am getting an error that the result of a formula field should be a string.

Thanks

saran

 

[Madawc]

Is {clearquest.time} numeric? If not, ToNUmber should fix it.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10