Does sales logix have the capability to automatically count number of activities without downloading it in excel?

The question is vague.  Where are you expecting this automatic count to be displayed?

There is no function or anything I know of that would provide this count.  It's not a hard thing to do.  A simple "SELECT COUNT(*) FROM activity WHERE [conditions]" would return the number.

John

Indeed there are many ways to count the number of Activities, and the method to use depends on what you are trying to Count.

One Method mentioned is to write your own SQL query to figure out the Count (based on your Criteria).

Also, if you want to get a Count based on the Contents of the Panel, there are Methods on the Panel object that return the Data, or there are ways to get directly to the Panels Reader and query the data directly:

e.g.

<strong>        var panel = Sage.SalesLogix.Controls.ListPanel.find("MainList");
        if (panel) {          
            selectionInfo = panel.getSelectionInfo();
        }

Or

<p>  var recordCount = this.views.list.store.reader.jsonData.count;
 

By using this approach, you don't have to try to figure out the Selected Criteria and build a matching SQL statement, as you would be getting the count (or the data) based on the Criterias already set on the Screen (including filters).

And these mentioned counting methods don't address repeated activities with skipped dates....

This potentially is a very difficult question to answer....