04-04-2014 12:03 PM
HOW can I export a list of subgroups to Excel?
NOT the contacts...but the subgroup names?
For example, what I want to export is the name of the study, while still knowing what higher subgroup it belongs to. For example…
COMPLETED STUDY (subgroup)
Very Important Research Study (subgroup)
John Q Researcher (contact)
Jane P Researcher (contact)
Ultra Important Program Evaluation (subgroup)
Mary Q Researcher (contact)
Sarah P Researcher (contact)
IN PROGRESS STUDY (subgroup)
Research Study XXXX (subgroup)
Bill Q Researcher (contact)
Bob P Researcher (contact)
Program Evaluation YYYY (subgroup)
Carol Q Researcher (contact)
Grace P Researcher (contact)
04-04-2014 12:53 PM
What you're showing in your post can't be done as a direct export to Excell. You would need to use an ACT! report to get a listing like that.
04-04-2014 02:11 PM
by the way...when I tried running a report using these steps:
the list is out of order & does not show me the correct studies under the correct sub group.
04-04-2014 02:28 PM
A couple of things, the groups list view has nothing to do with the ACT! reports so the first couple of steps has no meaning.
Based on your original post the Group list report wouldn't give you the information you want.
The Group Membership report would more likely be the report you want though the template may require editing to produce the desired result.
A final question based on your following post, what is the specific need to have the results in Excel?
04-04-2014 02:32 PM - edited 04-04-2014 02:39 PM
i want the list of studies/per category so that ultimately I can cound how many i have in each category.
COMPLETED = 40
IN PROGRESS = 25
WRONG ADDRESS = 10
and i'm using ACT! for the web (ACT! by Sage Premium for Web 2010 Version: 18.104.22.168)
it seems crazy that I can't get a report of the subgroups within a specific higher-level subgroup.
04-04-2014 02:47 PM
I just did a custom report for a customer that is very similar to the report you want including the counts. It did require a custom report template that once completed can be used any time you want and Excel wasn't required.
Excel is a flat file and can only work with a single ACT! table at one time. What you're wanting requires data from two different ACT! tables and that can't be done with a simple export to Excel.
04-04-2014 02:53 PM
04-04-2014 03:05 PM
You can't do the export to Excel directly from the ACT! program. It appears that part of the information you want is in the Group table and part of the information is in the Contact table. You can export to Excel from either the Group table or the Contact table but not both at the same time. To extract related data from both the Contact table and the Group table you need to use an ACT! report.
I would need to examine your database to be sure but I believe that I could make a custom report template that would provide the information you want and would include the counts.