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.