Hi, I've created a report using Report Builder with around 6 parameters. When I run the report in Report Builder, and enter all the parameters, data come back successfully. However, when I attempt to view it in SSRS after I publish the report parts and enter all the parameters, no data is returned whatsoever. No error either, just no data. I checked to make sure my user id had access to all the folders on the report server, but that didn't seem to work. Are you able to create a report in Report Builder with parameters and datasets that tie into those parameters and deploy it to the server? If so, what could possible be wrong?

yes i have created many report with RB and it workes fine after the deployment well the possible cause you need to cehck the server name in your connection string adn ake sure its reflecting to right server. also maek sure you dont have any row level security in your cube, which for a particuler user on RS is hiding data.Gaurav Gupta http://sqlservermsbiblog.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

yes i have created many report with RB and it workes fine after the deployment well the possible cause you need to cehck the server name in your connection string adn ake sure its reflecting to right server. also maek sure you dont have any row level security in your cube, which for a particuler user on RS is hiding data.Gaurav Gupta http://sqlservermsbiblog.blogspot.com/ Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.