none
MSPS 2007: How can I get the Project Name as a filter for SSRS reports RRS feed

  • Question

  • I am adding reports in the project workspaces in PWA.

    I wish to pass the current project's name as a parameter to the reports. How can I do that?


    Does that helps? -------------------------------------------------------- If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Kangkan Goswami |Technical Architect| Blog: http://www.geekays.net/ http://in.linkedin.com/in/kangkan Kangkan http://www.geekays.net/

    Monday, October 1, 2012 11:37 AM

All replies

  • Hi Kangkan,

    Please see this article, hope it suffice your requirement: http://www.mssqltips.com/sqlservertip/1336/pass-parameters-and-options-with-a-url-in-sql-reporting-services/

    Your report should take Project name parameter, and that project name can be taken from the URL directly following the instuctions explained in above mentioned article.

    hope this helps.


    Khurram Jamshed - MBA, PMP, MCTS, MCITP ( Blog, Twitter, Linkedin )

    Monday, October 1, 2012 12:35 PM
  • to relate the report with a project info in RDB you can use project site url in RDB and built-in report variable with report location. it works in a case where the report is at the corresponding project site. in other case guess you will need some js work - have not tested the variant yet

    Sergey Vdovin

    Monday, October 1, 2012 12:46 PM
  • @KhurramJamshed: The topic that you are pointing to uses querystring. TFS comes with a built in querystring filter as well. But this need the parameter to be passed as a parameter like &ProjectName=MyProject and the querystring filter can catch and pass on the value. In my case, the Project name is coming as part of the URL and not as a paramenter like http://servername:port/pwa/myproject/default.aspx

    So this is not available if I use the built in filter.


    Does that helps? -------------------------------------------------------- If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Kangkan Goswami |Technical Architect| Blog: http://www.geekays.net/ http://in.linkedin.com/in/kangkan Kangkan http://www.geekays.net/

    Wednesday, October 3, 2012 10:44 AM
  • Sergey,

    I am a beginner and could not follow what you are suggesting. Can you please elaborate?


    Does that helps? -------------------------------------------------------- If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Kangkan Goswami |Technical Architect| Blog: http://www.geekays.net/ http://in.linkedin.com/in/kangkan Kangkan http://www.geekays.net/

    Wednesday, October 3, 2012 10:45 AM
  • Hi there--

    Just to clarify that project site may not have the necessarily projectname followed by PWA instance. A project manager can modify the site url on first time project site creation. You may need to go with the ProjectUID & ProjectWorkspaceInternalHRef.

    Please see below thread that might help.
    http://social.technet.microsoft.com/Forums/pl-PL/projectserver2010general/thread/2dfd0c39-0c5b-4fc9-8bbf-6e876b91de79

    http://social.technet.microsoft.com/Forums/da-DK/projserv2010setup/thread/655f9859-5cb3-44f0-85be-cee65cd7e5b8


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    Wednesday, October 3, 2012 12:20 PM
  • Amit gave some of the the details.

    Sergey Vdovin


    Wednesday, October 3, 2012 12:43 PM
  • @Amit: I am not talking about finding ways of using the QueryString Filter. I wrote about it because I was being suggested to use this and that I explored this filter a bit. What my simple requirement is being able to pass the current ProjectName or the ProjectId so that I can pass it to the underlying SQL query. I think there must be some way to do it without opening and writing code in Visual Studio.

    Does that helps?
    --------------------------------------------------------
    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”.
    Thanks,
    Kangkan Goswami |Technical Architect| Blog: http://www.geekays.net/
    http://in.linkedin.com/in/kangkan

    Wednesday, October 10, 2012 4:50 AM
  • Ok, When the Workspace home page is loaded, It shows only the workspace URL which might be different than the Project Name. So you will need to have the URL as a parameter in SQl query in "MSP_EpmProject table " to get the project UID. Once you have the Project UID, You can load data in report as per your logic.

    Hope that helps.


    If you found this post helpful, please “Vote as Helpful”. If it answered your question, please “Mark as Answer”. Thanks, Amit Khare |EPM Consultant| Blog: http://amitkhare82.blogspot.com http://www.linkedin.com/in/amitkhare82

    • Proposed as answer by Jack-EPM Monday, December 3, 2012 3:04 PM
    Wednesday, October 10, 2012 5:16 AM