Caching Reports on Server and Attaching the reporting database on the desktop machine.
Hi, I want to cache some of my reports for faster viewing but the problem is when I run them on the desktop machine it takes more than half an hour whereas on server it takes 10 mins.Can it be possible to cache the reports on the server and then attach the server reporting database to the desktop machine's reporting database? That would save me a lot of time.Is there any way around for this? Thanks in Advance.Thanks and Regards, Franco Lopes. Ask a Question and you are fool for a second but if don't ask a question you are fool forever.
January 25th, 2010 11:48am

Hi,Please refer to this article: http://msdn.microsoft.com/en-us/library/ms157447.aspxThanks.Yao Jie Tang -Microsoft Online Community
Free Windows Admin Tool Kit Click here and download it now
January 26th, 2010 1:05pm

Hi Yao Jie Tang, Thank you for your reply.But it doesn't answer my question.Let me elaborate on the same.The problem is though I know how to cache the reports I don't know if it is possible to cache the reports on one high end machine(server) and use the report server database of that machine(server) on some other low end end machine (like desktops,laptops etc..) to save the caching time on the low end machines.Is it possible to achieve this by any way?Please let me know. Thanks in advance. Thanks and Regards, Franco Lopes. Ask a Question and you are fool for a second but if don't ask a question you are fool forever.
February 23rd, 2010 2:35pm

Hi All, Well this cant be possible as the reportserver database is configured according to a particular host name which gets registered in the report server database.So even if you try and attach it from high end to low end machine it wont work.Let me know if there is any work around for this.Thanks and Regards, Franco Lopes. Ask a Question and you are fool for a second but if don't ask a question you are fool forever.
Free Windows Admin Tool Kit Click here and download it now
February 2nd, 2011 1:59am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics