"jj" wrote:

>
> Have not accessed this forum in a while but to answer the question, I
> created a custom assembly. The custom assembly basically implemented a hash
> table. Each row in the dataset was codified to have a unique value. To the
> unique value I would concatenate a unique column identifier. Together these
> made up a unique key that I could use to store a value in the hash table.
> Later then I could retrieve any value by using the desired key. (vb.net code
> below; UGH; I hate vb anything but the customer didn't know c# so didn't have
> a choice)
>
> Option Strict On
>
> Imports System
> Imports System.Collections
>
>
>
> Public Class GlobalStorage
>
> Shared GlobalCollection As New Hashtable
>
> Public Shared Function Save(ByVal keyType As String, ByVal fieldCode As
> String, ByVal keyIntValue As Integer) As Integer
> Dim keyName As String
>
> keyName = keyType + fieldCode
>
> If GlobalCollection.ContainsKey(keyName) Then
> ' the key already exists, just update the value
> GlobalCollection.Item(keyName) = keyIntValue
> Else
> ' the key does NOT exist, add both the key and the value to the
> collection
> GlobalCollection.Add(keyName, keyIntValue)
> End If
>
> Return (keyIntValue)
> End Function
>
>
> Public Shared Function Retrieve(ByVal keyName As String) As Integer
> If GlobalCollection.ContainsKey(keyName) Then
> ' the key exists return the value
> Return CType(GlobalCollection.Item(keyName), Integer)
> Else
> ' return 0 so the formating of the report will show blank space
> Return (0)
> End If
> End Function
>
> End Class
>
> There are a bunch of other things that you have to implement like the code
> in the field expressions, and configuring RS to be able to use the assy. All
> in all, a real pain. I sure miss ActiveReports. What took a couple of hours
> in ActiveReports may take days in Reporting Services, and this is of course,