Cross Tabs and Drill Down

[Crystalyzer]

CR 11

I have created a cross tab report that queries a table (actually a stored procedure to which I pass a date) and summarizes (counts) activities (rows) based on the activity type and beneath that the activity person (person who entered the activity. Both activity type and person are columns.

What I would like to do is make each square of the grid (or at least some) clickable. Let's say an activity type is Phone Call and a activity person is Fred. If Fred has 5 activities listed of type phone call, the report currently has a 5 in the Phone call -> Fred column. Ideally, a click of the 5 gridbox would launch a subreport that would show all information from the table for those 5 Activities in rows.

I am just not familiar enough with Crystal to code this, especially as there could be variations, for example what if we wanted the user to be able to click fred and return all activities for fred.

Any hints, or direction appreciated!

thanks


Thanks and best regards,
-Lloyd

 

[Crystalyzer]

Please disregard this question. Thanks to all who considered answering. I should have done my search BEFORE posting.

My apologies.

Thanks and best regards,
-Lloyd