Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Using SharePoint 2010 Lists in SSRS 2012 Filters / Parameter Questions


Using SharePoint 2010 Lists in SSRS 2012 Filters / Parameter Questions

Author
Message
Staggerlee
Staggerlee
SSC-Addicted
SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)SSC-Addicted (404 reputation)

Group: General Forum Members
Points: 404 Visits: 1119
Hi all,

We are trying to do a report off multiple SP Lists in a single report. im having trouble finding links and info on setting up filters/parameters using SharePoint Lists, though.

In the examples i can find. It is possible to query a SharePoint List and filter the results using the <query> tags. But I cant find anything on how it really works. BOL has some examples but ive not found them very helpful.

i need to be able to do the following type queries.

Create a parameter list in SSRS with distinct values from a SP list.

Do some select col1, col2 from SP List WHERE name = @parameter

Link a subreport via a parameter (ie do a join in SQL tables, i cant see a way to join multiple lists in a single table so im just doing a subreport in a column but dont see how to link the results.)

I could do the report in about 10 mins if the data was in SQL, but we dont have BCS set up and the business has issues with doing anything that breaks the norm of sharepoint (if that makes any sense)

Hope someone can guide me to results or point me in the direction of a web page ive missed or blog that shows how to do this, I cant be the first to want to do this..

thanks for any replies.


I
mysorian
mysorian
Valued Member
Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)Valued Member (50 reputation)

Group: General Forum Members
Points: 50 Visits: 101
First of all it is important to know the following:

Your platform OS and architecture.
What is your SQL Server installation if any?

If I assume Windows 7 (x64) bit then it is possible to install reporting services (2012) in SharePoint integrated mode. With this in place you could generate reports.

Report Builder 3 can be installed stand alone which you can use to generate reports from SharePoint list. I created a custom list and generated a report using Report Builder 3.0.

It is in my recent book on SQL Server Reporting Services 2012, the details of which you can find in my blog:
http://Hodentek.blogspot.com
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search