12-20-2012 08:12 AM
I'm using Act! 2010 and am attepting to pull some data out of ACT relating to activities. I need Activity Create Date and Scheduled for only. From this, I can see how many activities each user has been set during a given period.
I am using the report designer and only using these 2 fields from the Contact Activity table. For a 1 month reporting period it has generated a 308 page report with approx 300 blank pages, and the pages that do have something on only have 1 or 2 lines.
I have also ticked the included cleared activities box in the filter screen.
Any ideas wehat is happening?
12-20-2012 08:36 AM
Yes, it's most likely a report design problem. Regardless of the date range selected for the activities, it will run for all contact records. The activity information needs to be in a sub-report and then you can use the hide for empty sub-reports.
There is a third party book with comprehensive training information on the ACT! reports, here is the link.
Full disclusure I wrote the reports chapters of the book. The report chapters work for all version of the ACT! program since ACT! 2007.