By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,708 Members | 2,095 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,708 IT Pros & Developers. It's quick & easy.

Aggregating Data with Word

Brilstern
100+
P: 207
I am looking to create a "roll-up" report in MS Word by aggregating data from tables within 5 other reports. I have looked at a lot of different concepts but would like some input from the bytes community. Considerations include using VBA to import data from the individual reports to combined tables in one report, using PowerShell to aggregate the data and export as an html document, and implementing MS Access in some form or fashion. Some data-sets are below for examples. I am not looking for a direct answer, just need some help putting an idea into action.

Expand|Select|Wrap|Line Numbers
  1. Individual Reports
  2. Tables (4)
  3. Table 1 // 1 Label/Value
  4. Table 2 // 3 Label/Value
  5. Table 3 // 2 Label, Multiple Values
  6. Table 4 // 3 Label, Multiple Values
Expand|Select|Wrap|Line Numbers
  1. Table 1
  2. (Total Host Count, 100)
  3.  
  4. Table 2
  5. {Severity, Count}
  6. (High, 23)
  7. (Med, 67)
  8. (Low, 34)
  9.  
  10. Table 3
  11. {Operating System, Count}
  12. (Windows, 68)
  13. (CISCO IOS, 12)
  14. (VMware, 5)
  15. (Linux, 15)
  16.  
  17. Table 4
  18. {IP Address, Name, Score}
  19. (192.168.1.2, PC1, 100)
  20. (192.168.1.12, PC2, 78)
  21. (192.168.1.23, PC3, 76)
  22. (192.168.1.34, PC4, 58)
  23. (192.168.1.45, PC5, 46)
  24.  
For Tables like 1 and 2 I would be looking to combine the data and create summary tables.

For 3 a Summary table would be ideal but I need to include variables results, as it is not a set table.

For 4 I need to combine all the data and only keep the top 50.

Not really sure where to go/just need some pointers, thanks!

-SB

**Note, all 5 reports have identical formats, I essentially need to iterate through each one and grab the data for one BIG report.
Feb 25 '15 #1
Share this Question
Share on Google+
1 Reply


Brilstern
100+
P: 207
Ok, I have decided on a method and solution.

Import Word doc into MS Access. Manage and aggregate everything through Access. Export into Word for final report. If anyone wants to know more about how I accomplished this please let me know.

-SB
Mar 5 '15 #2

Post your reply

Sign in to post your reply or Sign up for a free account.