Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

I have created a Sql Reporting Services Report from a SharePoint list. I am creating this report in Microsoft SQL Server Report Builder.

When I hit "run query" on my dataset in the query designer, I get a full table of my expected results. However, when I set up a table or list and run the report, no data is shown as if it were an empty dataset.

To make things more confusing, this is a report that was actually working a few months ago, and neither the SharePoint list columns nor the report were changed in the time since the report was created. It was displaying the data correctly using a list control a few months ago, but now displays an empty page.

Has anybody seen an issue like this before? Thanks.

share|improve this question
add comment

2 Answers

I experienced a similar issue when my list items were located in folders..the items appeared correctly on my query, but when I ran the report nothing displayed (I eventually had to create an XML data source instead of using the default SharePoint List data source). Not sure if you're list items were moved into folders, but wanted to provide the KM article in case this was the issue you faced: http://support.microsoft.com/kb/2826162

share|improve this answer
add comment

If you are passing parameters check size of parameters

share|improve this answer
    
Where do User check the size of parameters, and how does user overcome this potential parameter size issue? Please expand your answer. Thanks. –  Benny Skogberg Mar 6 at 2:44
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.