I have a simple classic ASP website using SQL Server 200, with busy visitors hits on site. The admin has reporting section from which by giving date range as parameters he/she can view users activity.
we have logic on these reporting pages that he can generate report based on date dange as parameter and it will be displayed on browser first, there there is an option to generate its HTML (printable version) and export to Export to EXCEL. The problem is when user generate report, with same parameters lets say it shows 500 users hits, but when user click printable version or export to excel same query runs and it gives 509 hits. That is geneuine issue because 9 users hits site later. Now that is issue, we want to maintain state based on admin user. we were thinking to use temp table logic, but would it be helpful? I need suggestions if someone already faced this issue and fixed this via some logic, Please share.