Crystal Subreport Time Grouping

[aloux]

thread767-1578872

I'm in the same boat as this previous thread, but I couldn't get the answer from the posts. I have main and subreport, I have the parameter dates set up, and a parameter for employee. The goal of the report is to get activity totals for employees. It works great when just grouped by employee.

Name TotalAct1 TotalAct2 [TotalAct3(Subreport)]

So I can get monthly, weekly, and daily totals. Now I'm trying to get a daily report where I can see activities by time. I'm pulling different types of datetimes for the different activities (created on/closed on), So I have a formula that grabs the correct datetime per activity, and I am grouping by it (per hour) as well as an employee grouping.

JSmith
9am 1 0 2
10am 2 1 2
11am 0 3 2

The "2" should only show at 10am for that 3rd column (The subreport). I just can't get the group time to carry over. I'm wondering If I need Time parameters now.

Thanks in advance, I'm using crystal 11

Adam

 

[aloux]

I figured it out, so for anyone with the same issue...

My subreport links are on employee and activity date.

I then made a formula in both the main and sub report for time where

If Time(activity date) in Time(00,00,00) to Time(00,59,59)
Then "1 am"

and did this for all hours, then I just linked them. You also have to painstakingly order the group because it is text.

 

[lbass]

Did you try an inner group on your datetime formula that is set to print on change of hour? Then you could link on that in addition to your other two links (employee, date).

-LB