I created some reports using SQL Server Business Intelligence Development Studio. They all use the same datasource. In preview mode all reports work well and show data. After publishing them to Report Services some of the reports show no data. Any ideas ? It could be that it has to do with the SQL query, because if I simply use the SQL query and copy and paste it to a new report using the default layout, then I get the same result after publishing.

Some ideas that come to mind when I read this are: * Are you sure it's the same datasource on the server you are deploying to? Is it set to overwrite from your BIDS project properties? * Are you by chance using localhost in your datasource and the machine where your BIDS is different than where you are deploying to? Another words does localhost mean the same machine where you have BIDS and where you are deploying to? That's just a couple ideas you may want to check. Good luck!