• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 801
  • Last Modified:

data driven subscription in SSRS

I have a requirement to make a report based on Sharepoint List.  I was thinking of using the Microsoft Sharepoint List source in SSRS and build a report based on that data. Then I need SSSRS to output a separate pdf for each item in that list, added to the list the day before. Is this something that I can do with Data Driven subscription, where I can send with e-mail one pdf pr. List item that are created the day before (based on f.exs. Created datetime stamp in the list) ?
  • 2
2 Solutions
ValentinoVBI ConsultantCommented:
Something is possible but I'm not 100% sure if what you described will work out as expected.

Just like you can use a SharePoint List as a report data source, you also have that possibility when creating a data-driven subscription.  However, I wouldn't know how to produce a query that fetches the data as expected for a data-driven subscription, from that SP List.  A SP List query is actually XML and looks something like this:

<RSSharePointList xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
  <ListName>The SP List</ListName>
    <FieldRef Name="Field" />
    <FieldRef Name="MoreField" />
        <FieldRef Name="SomeDateField" />
        <Value Type="DateTime">2013-09-30T00:00:00</Value>

Open in new window

This is what I could produce using the graphical query designer in SSRS.  It returns all records with SomeDateField < '2013-09-30'.  But in your case you probably want this to be based on an expression.  How that part can be accomplished, if at all, is beyond my current knowledge...
Yagya ShreeCommented:

Have you considered using a workflow to achieve the above requirement. This could be done using SPD with available actions.

Please find the details for the same here in below link

Yagya ShreeCommented:
Did you manage to get this issue fixed? Please let us know.
gosi75Author Commented:
Thanks for those comments, this was really helpful. cheers
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now