<p>Hello,</p>
<p> </p>
<p>I am in the process of designing a line graph that will graph out the amount of participants that are in a conference call at a given time. To accomplish this I am pulling data from a data base. This data consists of "Connect Times" which are times that a participant entered a call, and "Disconnect Times", which are the times that the participant left a call. I am using a Scripted Data Set to set up my graph and all is fine so far except for getting access to these "Connect" and "Disconnect" times. </p>
<p> </p>
<p>Here comes my problem:</p>
<p> </p>
<p>I have a table set up like the following:</p>
<p> </p>
<p><strong>*see attached connectTable.png</strong></p>
<p>ColumnValue9 are connect times, and ColumnValue10 are disconnect times</p>
<p> </p>
<p>I have a query set up to populate this table and when I display this table in the report engine I get the following:</p>
<p> </p>
<p><strong>*see attached dataTable.png</strong></p>
<p> </p>
<p>You can see that there are 5 connect times and 5 disconnect times that get displayed when I display my table.</p>
<p> </p>
<p>The problem that I am having is that I can only access the last connect time, and the last disconnect time. You can see that in the connectTable.png there is only one row for each, but when it is displayed in dataTable.png there are 5 (based on the number of participants in a call). It is like each time it populates, it overwrites the previous value until all I have left in ColumnValue9 is the last value. Although when it displays, it displays them all. Hopefully I am making sense.</p>
<p> </p>
<p><strong>My question is:</strong> Is there a way that I can get all of the connect times displayed in the above dataTable.png, into an array? I need to be able to place all 5 of the above connect times in an array, so that I can loop over them within my scripted data set to see if a participant was in the call or not at a given time. I am stumped at this as every way I have tried to do it I can only get access to the last value.</p>
<p> </p>
<p>I greatly appreciate any help that anyone can offer as I have been trying to accomplish this for quite some time with no luck. Thank you very much!</p>
<p> </p>
<p>Best,</p>
<p> </p>
<p>Dave</p>
