SharePoint 2010 creating SSRS report of a SharePoint List.
So I have SharePoint 2010 Foundation and SQL Server 2008 with reporting services setup. I have created a report using the built in connector to SharePoint Lists. However its only reporting based on my "Default View", which also limits the amount of items returned. Is there a way to force the query to pull all items? Or is there something im missing on this? The list has all the data i need to report off of, i just need SSRS to pull it all in.