 | | From: | sylvia | | Subject: | total Calculated | | Date: | Fri, 14 Jan 2005 19:55:57 -0500 |
|
|
 | i have this 2 totals on my report and my trouble is that i want to make a 3 total field with this 2 making this the resul of TEX_SUR_MTTO*100 / TEXT_PED_MTTO.
do i have to create a calculated field ??
im begginer and im tring to do this for 2 days and i cant find the way, in some tries, i just can read object , nothing printing, and many error.
Please guys give me a idea. or somthing to read ....... and lern
Sylvia
this.STREAMSOURCE1.GROUP1.footerBand.TEXT_PED_MTTO = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXT_PED_MTTO)
height = 3.78
left = 30.66
top = 0.47
width = 17.81
wrap = false
prefixEnable = false
colorNormal = "0xFF0000"
marginHorizontal = 1.4288
alignHorizontal = 2 // Derecha
picture = "999999999.99"
transparent = true
fontName = "Arial Narrow"
fontSize = 7.56
fontBold = true
text = {||this.parent.parent.agSum({||this.parent.rowset.fields["PED_MTTO"].value})}
endwith
this.STREAMSOURCE1.GROUP1.footerBand.TEXT_SUR_MTTO = new TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TEXT_SUR_MTTO)
height = 3.78
left = 48.47
top = 0.47
width = 17.81
wrap = false
prefixEnable = false
colorNormal = "0xFF0000"
marginHorizontal = 1.4288
alignHorizontal = 2 // Derecha
picture = "999999999.99"
transparent = true
fontName = "Arial Narrow"
fontSize = 7.56
fontBold = true
text = {||this.parent.parent.agSum({||this.parent.rowset.fields["SUR_MTTO"].value})}
endwith
|
|
| | From: | Todd Kreuter [dBVIPS] | | Subject: | Re: total Calculated | | Date: | Sat, 15 Jan 2005 09:31:19 -0500 |
|
|
| sylvia wrote:
>
> i have this 2 totals on my report and my trouble is that i want to make a 3 total field with this 2 making this the resul of TEX_SUR_MTTO*100 / TEXT_PED_MTTO.
Are you wanting this 3rd field to print in the detailBand or the group
band or both? It may be easier to use a calculated field if the field is
to appear with the detail band.
--
Todd Kreuter [dBVIPS]
|
|
| | From: | sylvia | | Subject: | Re: total Calculated | | Date: | Mon, 17 Jan 2005 14:01:08 -0500 |
|
|
| i put a screen shoot on teh binares and also the rep and the table
that is more explained about the calculated field on the group and total
plase take a look
sylvia
Todd Kreuter [dBVIPS] Wrote:
> sylvia wrote:
> >
> > i have this 2 totals on my report and my trouble is that i want to make a 3 total field with this 2 making this the resul of TEX_SUR_MTTO*100 / TEXT_PED_MTTO.
>
> Are you wanting this 3rd field to print in the detailBand or the group
> band or both? It may be easier to use a calculated field if the field is
> to appear with the detail band.
>
> --
> Todd Kreuter [dBVIPS]
|
|
| | From: | Todd Kreuter [dBVIPS] | | Subject: | Re: total Calculated | | Date: | Fri, 21 Jan 2005 15:12:46 -0500 |
|
|
| sylvia wrote:
>
> i put a screen shoot on teh binares and also the rep and the table
> that is more explained about the calculated field on the group and total
> plase take a look
looks like you need to take the values of the two text controls and just
use them to calculate the result for the third. Use the third text
control's canRender:
function Text1_canRender
local n1, n2
n1 = this.parent.text1.text()
n2 = this.parent.text2.text()
this.text = n1/n2 * 100
--
Todd Kreuter [dBVIPS]
|
|
