	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

06/29/2009 at 11:38AM PDT, ID: 24530968 | Points: 250

	[x] Attachment Details

Reporting Services and "Visual Reports" for Project Server

Asked by MAVSS in MS SQL Reporting, Microsoft Project Project Management Software, Microsoft Excel Spreadsheet Software

Tags: Project Server, Project Professional, SSRS, Reporting Services, Visual Reports

Can Reporting Services be used to create the same reports in "Visual Reports" in Project Server? I am trying to create the "Baseline Work Report" using reporting services however I'm having trouble due to the fact that Visual Reports in Project Pro uses its own cube.

I am trying to create a high level report like the picture attached. I have risks, issues, health, and accomplishments however I can't figure out this last report. Does anyone know how to do this?

View the Solution FREE for 30 Days

Attachments:

example.jpg (69 KB) (File Type Details)

example report.

20091028-EE-VQP-88 - Hierarchy / EE_QW_3_20080625

1. jbfraser 150,226
2. dbase118 70,120
3. defi0 35,886
4. bobsegrest 22,250
5. Digvijayan... 20,400
6. Bembi 17,335
7. lyonst 11,750
8. tedbilly 7,950
9. harisrashid 5,750
10. solutiontiger 4,500
11. Thomas_... 4,000
12. rrjegan17 3,250
13. gova 2,580
14. GreatGerm 2,500
15. peter57r 2,200
16. jcimarron 2,000
16. willman 2,000
16. tbsgadi 2,000
16. thenelson 2,000
16. scott 2,000
16. murphey2 2,000
16. capricorn1 2,000
16. RedKelvin 2,000
16. non_zero 2,000
16. pinaldave 2,000
16. RobWill 2,000
16. leonstryker 2,000
16. peakpeak 2,000
16. GlennaShaw 2,000
16. bhwithun 2,000
16. Snodlander 2,000
16. chilternPC 2,000
16. gamesmei... 2,000
16. papushka 2,000
16. ram_kerala 2,000
16. 65td 2,000
16. itkamaraj 2,000
16. tsmvp 2,000
16. apache09 2,000
16. zomby1 2,000
16. Binarymime 2,000
16. efusion 2,000
16. Fruit_Box 2,000
16. sandypatel 2,000
16. Steve_NJ 2,000
16. cdbosh 2,000
16. Tiggerito 2,000
16. akashj 2,000
16. Ramone_... 2,000
16. melli111 2,000
16. SimWhite 2,000
16. sharepoin... 2,000
16. ahmed-h... 2,000
16. stephen727 2,000
16. WC_TSA 2,000
16. lucidica-... 2,000
16. PriceD 2,000
16. next2per... 2,000
16. ktorok 2,000
16. pinkeyyadav 2,000
16. andavari 2,000

1. bobsegrest 311,552
2. jbfraser 231,151
3. dbase118 230,988
4. harisrashid 162,804
5. winzig 137,363
6. Bembi 88,202
7. lyonst 54,616
8. MSProject... 42,118
9. defi0 35,886
10. gova 34,305
11. RobertoEs... 30,888
12. leslynf 28,153
13. Miles_sty... 25,662
14. Digvijayan... 20,400
15. tedbilly 17,975
16. aflockhart 15,132
17. sinjin 14,552
18. whoajack 14,405
19. Thomas_... 10,600
20. bruintje 9,175
21. Synogistics 8,412
22. KCTS 8,250
23. suprhkr 7,500
24. hectorfierro 7,264
25. redrumkev 7,000