SSRS does not work with multiple dataset on report server
I have a report which uses four dataset. The report works fine on BIDS but when I deploy it on report server it is giving below error "An error has occurred during report processing. (rsProcessingAborted) Query execution failed for dataset 'DS_PMCFeeDetail'. (rsErrorExecutingCommand) For more information about this error navigate to the report server on the local server machine, or enable remote errors " Any help???
October 13th, 2011 8:47pm
Arun, Try, just to isolate the problem, to remove this dataset, and add another one, a simples and that execute SELECT GETDATE(), and print the result on the report. I don´t think theres some "strange" problem with multiple DataSets, maybe some thing with permission, or the query....Fabrizzio A. Caputo Certificaes: Oracle OCA 11g MCITP SQL Server 2008 Implementation and Maintenance MCITP SQL Server 2008 Developer Blog Pessoal: www.fabrizziocaputo.wordpress.com Blog Empresa: www.tripletech.com.br/blog Twitter: @FabrizzioCaputo Email: firstname.lastname@example.org
October 13th, 2011 9:26pm
I was creating index in all dataset which was having same name. But I am not sure why it worked in BIDS.
October 13th, 2011 11:12pm