Pre-render or something like it...

[Coleen]

Hi all :-)

I've had this problem before, and thought I solved it, but it turns out that
it is not working...

I need to get the grand total of a column of numbers to use BEFORE the loop
which does the calculation completes. I tried pre-render, I tried compute.
Neither seems be working for me. I have to have the grand-total of the
column to use to divide the amount for each row of the SAME column in order
to get a percentage rate. Here's the code I had for the Compute:

Dim sum2 As Double =
CDbl(dt_stat_report_3b.Compute("Sum(ld_fy_hh_125_a vg_gtr_act)", ""))

where ld_fy_hh_125_avg_gtr_act is the name of the column that I need the
grand total for. This does not work! ARGH!

I tried prerender:

Private Sub uwg_stat_rpt_3b2_PreRender(ByVal sender As Object, ByVal e As
System.EventArgs) Handles uwg_stat_rpt_3b2.PreRender
Dim sum As Double =
CDbl(dt_stat_report_3b.Compute("Sum(ld_act_125_gtr _fy_hh_avg)", ""))
End Sub

This does not work either! Any suggestions would be GREATLY
appreciated...TIA,

Coleen