Display "Related Items" in SQL Reporting Services

I'm trying to run a report on a workflow task list. I'd like to display the related items as their actual names.

Can anyone point me to an article describing how this would be

May 20th, 2015 4:07pm

Hi David,

Is the SQL Rporting Service integrated with SharePoint?

Could you please elaborate the "Related Items" column in workflow task list? 

If it is a list column (e.g. "Related Content") in workflow task list, the list column should be able to be got in reporting service.

Here are two artielces about how to use SharePoint listas data source in SQL reporting service for your reference.

http://www.mssqltips.com/sqlservertip/2068/using-a-sharepoint-list-as-a-data-source-in-sql-server-reporting-services-2008-r2/

http://aaclage.blogspot.in/2011/11/create-reports-with-sharepoint-2010-and.html

Thanks

Daniel Yang

Free Windows Admin Tool Kit Click here and download it now
May 21st, 2015 10:27pm

Nice.  Lots to read on the second link there.  Thank you.
May 22nd, 2015 11:26am

The 'Related Items' field comes out as a JSON format or something like that.  I know in SQL Reports I can format HTML but I'm not so sure about read JavaScript and format it in a column.

The 'Related Items' column would need to be used to query back to the SharePoint site to retrieve the actual item.  I can think of how to do this in REST but have no clue what I would do in SQL Reports. 

Free Windows Admin Tool Kit Click here and download it now
May 22nd, 2015 4:40pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics