• 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.