This is a blog post that is worth checking out! My colleague Jan Kalis just announced the release of the Project Server 2007 Report Pack II (recorded webcast and demo here). Why is it the best thing since slice bread? Well check out the following list of SQL Server Reporting Services it contains (and to make it easier to use in your environment it all contains full documentation as well as separate Visual Studio packages and directories of ALL T-SQL queries). I’m sure you will find few key nuggets in there that will help you with your day to day activities as well as surface key information from your Project Server 2007 Project Portfolio Management gold mine of information!
I would like to replace the Resource Custom fields in the demo with our own - if their is any guidance, resources to help do that, would appreciate. I am bit of a novice with SSRS Reports. Thanks in advance.
Dinesh
copy the underlying query in SQL Server Query analyzer and make all necessary syntax updates until it runs successfully.
In the "Task Update Compliance" Report what is the meaning of "Submitted and Failed to Process"?
Thanks in advance
Gustavo
Hi,
I'm having problem with running Resource Allocation report of Report Pack II in Governance Reports. I'm receiving a bunch of error and all of them are saying "Report item expressions can only refer to fields within the current data set scope or, if inside an aggregate, the specified data set scope." I think there is something wrong with expressions, such as this one(this comes with Report Pack II, I didn't change anything):
=iif(Parameters!RP_GroupBy.Value="RBS",Fields!RBS.Value,
iif(Parameters!RP_GroupBy.Value="Resource",Fields!Resource_Name.Value,
iif(Parameters!RP_GroupBy.Value="Project",Fields!Project_Name.Value,
Fields!Team_Name.Value)))
+ " ( "
+ cstr(count(Fields!Overallocated_for_day.Value)) + " Overallocations , "
+ cstr(count(Fields!Underallocated_for_day.Value)) + " Underallocations )"
Can anyone help me to resolve it? Any ideas are greatly appreciated.
thanks,
rdm