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) ?
gosi75Business Intelligence ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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>
  <ViewFields>
    <FieldRef Name="Field" />
    <FieldRef Name="MoreField" />
  </ViewFields>
  <Query>
    <Where>
      <Lt>
        <FieldRef Name="SomeDateField" />
        <Value Type="DateTime">2013-09-30T00:00:00</Value>
      </Lt>
    </Where>
  </Query>
</RSSharePointList>

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...
0
Yagya ShreeCommented:
Hi,

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

http://sergioblogs.blog.co.uk/2013/09/18/as-per-this-technet-request-here-is-a-guide-on-16414417/
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Yagya ShreeCommented:
Did you manage to get this issue fixed? Please let us know.
0
gosi75Business Intelligence ConsultantAuthor Commented:
Thanks for those comments, this was really helpful. cheers
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Query Syntax

From novice to tech pro — start learning today.