Showing results for 
Search instead for 
Do you mean 
Reply

Excel Report_Query & Report builder

[ Edited ]

Hi,

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.