Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2009-03-03 : 19:13:59
|
| Hi Guys,I am using SSRS 2005 (SQL SERVER REPORTING SERVICES 2005) to create a report.Here is my scenario:I am using datasource as SSAS cube which is on SQL SERVER 2000 (i.e cube is on SQL SERVER 2000).Its absolutely running perfectly when I run the report with in the solution i.e when i click preview tab and view , its working fine.But, when I deploy it I am getting the following error : An error has occurred during report processing. Query execution failed for data set 'data set1'. For more information about this error navigate to the report server on the local server machine, or enable remote errors(There is also another report which I created using SSAS cube as datasource which is on SQL SERVER 2005 (i.e. cube is on SQL SERVER 2005), its working fine and after deploying also the report is generating successfully.)Any ideas????Is it a problem using SSAS 2000 cube as a datasource for creating a report in SSRS 2005???Thanks,raaj... |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-03-04 : 09:53:59
|
| nope. the error seems to be in your source MDX. can you try running report in perview tab of visual studio to get more descriptive error msg? |
 |
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2009-03-04 : 17:38:26
|
| Hi visakh,Thanx for your reply.What do you mean by running report in the preview tab of visual studio?Do you mean to run it in the BIDS?If so I have done the same, and when I click the Preview tab, the report is being generated successfully.The problem is occuring only when it is getting deployed.Thanks,Raaj..... |
|
|
|
|
|
|
the following error is occuring when deploying...