Group on Range

[mintman]

Hello friends ,
I have a report like shwoing details in which one field in displaying no of hours.
For example
Group: 24hrs
abc 234 USER 24hrs
SSD 765 GUI 24hrs

Group:48 hrs
GFD 990 TMD 48hrs

Group:72hrs
BCC 754 CCM 72hrs

I like to show in this way
Group:24 - 48 hrs
abc 234 USER 24hrs
SSD 765 GUI 24hrs
GFD 990 TMD 48hrs

Any ideas on this?.
Thanks a lot.
M

 

[mintman]

Sorry guys i figured it out just wrote a formula
if TONUMBER (GroupName ({@Hour Bucket})) in [0 to 24] then "0-24"
else if TONUMBER (GroupName ({@Hour Bucket})) in [24 to 48] then "24-48".

Thanks.
M

 

[mintman]

Sorry guys , I am not able to show detaisl under group tough
Any suggestions?.

Thanks all
M

 

[mintman]

Sorry again, I figured it out.
Sorry for the trouble.
M

 

[mintman]

Hello
I did this on my report...Created formaula G1=(
if ({@Hour Bucket}) in [0 to 24] then "0-24"
else if ({@Hour Bucket}) in [24 to 48] then "24-48"
else if ({@Hour Bucket}) in [48 to 72] then "48-72"
else if ({@Hour Bucket}) > 72 then ">72")
This works fine.. but else if ({@Hour Bucket}) in [48 to 72] then "48-72" has no records. But it dosed not show up on report.

I did group on G1.
So I want to show 48-72 = 0(im counting records for each Case).
Thank You so much.

 

[lbass]

If there are no records, no group will show up. You'll have to use conditional formulas or running totals with an evaluation formula set to one of your intervals, and then create text boxes identifying the intervals to match the running totals/summaries in the report footer.

Also, please note that your intervals are overlapping. A better formula would be:

if {@Hour Bucket}) < 25 then "0-24"
else if ({@Hour Bucket}) < 49 then "25-48"
else if ({@Hour Bucket}) < 73 then "49-72"
else if ({@Hour Bucket}) >= 73 then ">72"

-LB

 

[mintman]

Thank you LB, probelme here is I have no hours between 48-72, that is the reason its not showing up. In future it may not have any records of hours between 0 to 24 too. So how to still show up the group name even thought it does not contain any recors , so that i can show Zero?. One more thing is Right now i am supressing the details and my output is like

Group:0-24
F1 F2 F3
12 Ab DC1
34 CD DC2
Group footer(Count of F3) = 2

Group: 24-48
F1 F2 F3
45 FG DC6
Groupfooter(Count of F3) = 1

So I wan to show like
Group:0-24 = 1 Group: 24-48 =1 -----In single line.
Is this possible.
And please suggest how to display group on field which in not present in report.


Thanks a Ton.
M

 

[lbass]

I already did in the first paragraph of my post--use running totals in the report footer.

You could use a crosstab in the report footer and use your bucket formula as a column field and the count as your summary, but this will not address the missing groups issue.

-LB

 

[mintman]

Probelm is we cant use a running total on TIME, the hpur bucket is a time difference between two dates. Any way to do this?. Thanks a lot LB.
M

 

[lbass]

If you leave the time difference as a number, instead of converting it to a string, you can certainly do running totals on it.

-LB