Showing results for 
Search instead for 
Did you mean: 

Excel Report_Query & Report builder



We have few item types which are in different workflow. Few workflow names have common words in it.

Ex: PR_Part_Release, EN_Part_Release,Part_release which applies to different item type revisions. In this Part is a common word in all workflows

I have a query to get Item ID and Rev belonging to workflow which has word "Part" or any other word in it.{Query attached}. Query is working.


But I need to generate a report which gives

Item ID | Item Rev | Item type | workflow name | Current Task Name | Workflow owner | Task owner |


Is it posible to get it using Report builder or Excel Template export?

I could get Item ID | Item Rev | Item type | using Report builder but I tried summary report using closure rule but couldnt generate workflow values.


Can you please suggest on it.