Project server workflow tasks and SSRS Report RRS feed

  • Question

  • Hello all,

    I am trying to calculate the count of approval workflows per user and trying to display on the SSRS report.

    But when I create the data set using "Project Server Workflow Tasks" task list in SSRS report, and try to query the contents of the Task list, it is showing empty, although the task list has so many approval workflow tasks. 

    Is there a limitation that the Task List can not be queried from SSRS reports? Because I am able to query the normal Sharepoint lists, but not this Workflow Task List.

    Please let me know if anybody has idea on this.



    Thursday, March 26, 2015 9:20 AM

All replies

  • Hello Guys,

    Any input on this ?

    Wednesday, April 1, 2015 7:23 AM
  • How are you querying the list? Odata?

    Treb Gatte, Project MVP | Blog | Twitter | YouTube Channel

    Wednesday, April 1, 2015 4:01 PM
  • Hello Treb Gatte,

    I ma creating Data Connection from SSRS Report, and then creating Data Set for "Project Server Workflow Tasks".

    And then when I pull data from the database, it is returning empty. For any other sharepoint list this is working absolutely fine. I am facing issue only wrt "Project Server Workflow Tasks" list.



    Friday, April 10, 2015 9:06 AM