Post reply

Caching Report for all Accounts

  • July 31, 2015 at 2:59 pm

    #320100

    Hi,

    Can we and also is it a good way (is there any other way) to Cache the SSRS report for each and every customer in the company and provide a link to view it for him / her? May be 100,000 customers.

    Thanks for any ideas in advance.

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.

  • August 3, 2015 at 3:09 am

    #1816739

    Hi

    It will be better to do a data driven subscription and send an excel or any other type of file via email

    to your customers

    Mohamed

    :w00t: !!!GOOGLE IS YOUR BEST FRIEND!!! :w00t:

  • August 3, 2015 at 5:25 am

    #1816762

    Thanks Mohamed, but I was thinking about cache only because the user can see a report but not an excel and also we can cache the report for every certain period of time, but there are 100k customers so I was thinking if that's a good idea at all...

    Thank you for your time.

    Good Luck 🙂 .. Visit www.sqlsaga.com for more t-sql code snippets and BI related how to articles.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply