Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Preserving data-set for later use in printable version (keep resultset same) Expand / Collapse
Posted Friday, December 5, 2008 7:05 AM

Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, September 6, 2013 5:54 AM
Points: 526, Visits: 590
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.


Shamshad Ali.

Post #614496
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse