Run

How to return the total value of a text box that have "SummaryGroup" and "SummaryType".
when I use this method: ReportUtilities.ReturnTextBoxValue(rpt, "grpLaborDetail", "txtMgmtLabor")
it returns only The first value not the total.

For Example: I use in my report the field (../../../dtr:Project/dtr:Items/dtr:Item /dtr:MgtLaborPrice)
SummaryGroup: grpLaborDetail
SummaryType: SubTotal

I want to add this field’s value to the field “dtr:LaborPrice” which in the “grpLaborDetail”

nkarthick

Hi,

If you want to retrieve the bound value which is summarized, then get the value in BeforePrint event procedure instead of Format event procedure.

In your case -

Use the ReturnTextBoxValue method in grpLaborDetail_BeforePrint procedure

Sub grpLaborDetailr_BeforePrint

Dim mgtValue as Double = Double.Parse(ReportUtilities.ReturnTextBoxValue(rp t, "grpLaborDetail", "txtMgmtLabor"))

End Sub

Add mgtValue to the LaborPrice(get as like as mgmtlabor) and assign it to the corresponding TextBox using ReportUtilities.SetTextBoxValue method.

Hope it helps.

__________________
Narayana Karthik

Run

Hi nkarthick,

Thanks for your reply, but it always return 0
Here is my code:

Private designPrice As Double

Sub grpDesignLabor_BeforePrint

designPrice = ReportUtilities.ReturnTextBoxValue(rpt, "grpDesignLabor", "txtDesignLabor2")

End Sub


Sub grpDesignLabor_Format

ReportUtilities.SetTextBoxValue(rpt, "grpDesignLabor", "TextBox1", designPrice )

End Sub

nkarthick

Hi,

Your code should be -

Sub grpDesignLabor_BeforePrint

designPrice = Double.Parse(ReportUtilities.ReturnTextBoxValue(rp t, "grpDesignLabor", "txtDesignLabor2"))

ReportUtilities.SetTextBoxValue(rpt, "grpDesignLabor", "TextBox1", designPrice )


End Sub


Don't assign the textbox value (summarized bound value) in format event procedure, do it in the BeforePrint event procedure itself.

FYI- Format event procedure fire/run first then only BeforePrint event procedure will be fired.


Hope it helps.

__________________
Narayana Karthik