Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 ASP.NET
 Conversion to Hashtable or other

Author  Topic 

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2005-09-22 : 17:35:13
Here's my code:

Shared offset As Integer

Public Function GetPN(reset As Boolean, pagenumber As Integer) As Integer
If reset
offset = pagenumber - 1
End If
Return pagenumber - offset
End Function

This is for a report page number reset on a new grouping value. Since the offset must be shared (so that this will work across multiple callbacks to the server), if more than one person runs the report at the same time they’ll smash each other. I need to modify the offset to be a hashtable, and am not sure how I would.....or if there's another possible route.

Thanks!

chadmat
The Chadinator

1974 Posts

Posted - 2005-09-27 : 22:37:06
How about using Session or Cache?

-Chad

http://www.phxpoker.com

Phoenix's largest online poker community
Go to Top of Page

bubberz
Constraint Violating Yak Guru

289 Posts

Posted - 2005-09-28 : 13:15:44
I'll need to figure out how to do a Session object with SQL Server Reporting Services.
Thanks!
Go to Top of Page
   

- Advertisement -