if you are talking about customSSRS reports then you can always, create the K2 database as a datasource and query the databae directly. There was a link to the ERD diagram of the database somewhere which doesnt seem to be accessiable anymore. Someone could please post the link if they have a valid one.

Sam

You can use the Activity Instance Destination smartobject as the data source for a SSRS report to give you each activity instance status for a given process instance id.

This smartobject is found under Workflow Reports -> Workflow General and there is one method "List". You can pass in the Process Instance ID to this method and use the "Status" field in the returned data.

You will need to do some config changes to get SSRS to use SmartObjects (will be listed as SOURCECODE in SSRS) as a data source  - you will need to add a sourecode dll to the report server and your report dev machine and register it in the web config. Check the KB for instructions (I cant find it now as it seems to be offline...).

Hi all,

thank you for your contributions.

Connecting directly to the database is a good approach but I was hoping that there would be a SmartObject to achieve this.

How is the worklist in Sharepoint being populated with the Status?

 The Activity Instance Destination SmartObject only seems to return whether an Instance is Active or Completed. It does not tell whether it is Open, Allocated or Available.

Thanks,

Sam

I believe those statuses are propeties of a worklist.  As such perhaps the Market > worklist broker service and/or the management worklist service broker can surface service objects that you can create into Smartobject and use where needed:

http://community.k2.com/t5/forums/searchpage/tab/message?filter=labels&q=worklist&tab=market

Please know that project from the market are community based and not out-of-the-box.