Community
Showing results for 
Search instead for 
Do you mean 
Reply

Problems with Basic Activity Report

New Member
Posts: 1
Country: United_Kingdom

Problems with Basic Activity Report

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?

 

Thanks

 

Leigh Simpson

Platinum Elite Contributor
Posts: 6,653
Country: USA

Re: Problems with Basic Activity Report

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.

https://www.packtpub.com/sage-act-2011-dashboard-and-report-cookbook/book

 

Full disclusure I wrote the reports chapters of the book.  The report chapters work for all version of the ACT! program since ACT! 2007.

Roy Laudenslager
ACT! Certified Consultant
ACT! Report Expert
Durkin Impact Report Designer
www.techbenders.com
royel@techbenders.com
541-343-8129