It may not be an option but I would recommend building reports of such a nature with SQL Server Reporting Services and creating a subscription to automate the delivery of...

I'm not a SSAS expert but can't you create a perspective off the cube that would allow you to expose just the details the user wants to see when browsing...

Why not have all those extra details as attributes in your dimension table?

You can't have both to my knowledge...Basically when you run under Integrated mode all of your configuration is managed by the same database as your sharepoint instance. I would script...

Two hours for 200 files isn't bad I don't think...Are there any possible CPU spikes during this time? It might be difficult to track down exactly...

Here might be a good place to start...

Managing Permissions and Security for Reporting Services

Honestly if they, as a SSRS developer, don't know how/where to set up security, they probably are...

Did the output window reveal anything?

If you install the Printer Delivery Extension you should be able to call the render method and have it automatically print. Check the link below...

http://msdn2.microsoft.com/en-us/library/ms160778.aspx

Hope this helps!

The reason your data sources don't contain their connection information any longer is because you deleted all the encrypted content. After you restore your encryption key you'll need to initialize...

Yeah so if you're data set(s) read directly from the database then you need to make sure the account you're using has db_datareader on whatever DB's it is reading from....

Hey Russ,

Are you using shared data sources? Make sure the connection string has the correct servername and that from the SSRS server you can telnet into the DB server. This...

check your output window, it should have something about the error...

Start here:

http://msdn2.microsoft.com/en-us/library/ms159644.aspx

🙂

I've been working with SSRS for years now and still come across this error from time to time. Generally the issue I find is that there are domain/networking issues that...

Are you declaring your array properly? I'm not an expert C# developer but wouldn't it be...

Microsoft.Reporting.WinForms.ReportParameter[] Param[];