 | | From: | Larry Kinder | | Subject: | CodeBlock? | | Date: | Wed, 22 Dec 2004 12:06:59 -0600 |
|
|
 | how can I do this?
text =
{||this.parent.parent.agSum({||this.parent.rowset.fields["ChkGross"].value})}
+;
for this.parent.rowset.fields["FutaTax"].value > 0
Thanks
Larry Kinder
this.STREAMSOURCE1.GROUP1.footerBand.TaxableFutaWages = new
TEXT(this.STREAMSOURCE1.GROUP1.footerBand)
with (this.STREAMSOURCE1.GROUP1.footerBand.TaxableFutaWages)
canRender = class::TaxableFutaWages_CANRENDER
height = 0.1674
left = 2.9368
top = 2.7285
width = 0.8438
prefixEnable = false
colorNormal = "b+"
alignHorizontal = 2 // Right
picture = "999,999.99"
text =
{||this.parent.parent.agSum({||this.parent.rowset.fields["ChkGross"].value})}
endwith
|
|
| | From: | Michael Nuwer [dBVIPS] | | Subject: | Re: CodeBlock? | | Date: | Wed, 22 Dec 2004 13:13:21 -0500 |
|
|
| Larry Kinder wrote:
> how can I do this?
> text =
> {||this.parent.parent.agSum({||this.parent.rowset.fields["ChkGross"].value})}
> +;
> for this.parent.rowset.fields["FutaTax"].value > 0
> Thanks
> Larry Kinder
>
All on one line :
text =
{||this.parent.parent.agSum(
{||IIF(this.parent.rowset.fields["FutaTax"].value > 0,
this.parent.rowset.fields["ChkGross"].value, NULL)}
--
Michael Nuwer
http://www.ChelseaData.ca/dLearn/
http://www.nuwermj.potsdam.edu/dSamples/
|
|
| | From: | Larry Kinder | | Subject: | Re: CodeBlock? | | Date: | Wed, 22 Dec 2004 12:59:36 -0600 |
|
|
| Your are pretty sharp! You can make genious status if you help me figure out
why I am only
getting 0.00. The rowset field FutaTax has amts in some rows. I did have to
add another )} Did I put them in the wrong place?
text =
{||this.parent.parent.agSum(
{||IIf(this.parent.rowset.fields["FutaTax"].value > 0,
this.parent.rowset.fields["ChkGross"].value,null)})}
Larry Kinder
> All on one line :
>
> text =
> {||this.parent.parent.agSum(
> {||IIF(this.parent.rowset.fields["FutaTax"].value > 0,
> this.parent.rowset.fields["ChkGross"].value, NULL)}
>
> Michael Nuwer
> http://www.ChelseaData.ca/dLearn/
> http://www.nuwermj.potsdam.edu/dSamples/
|
|
| | From: | Larry Kinder | | Subject: | Re: CodeBlock? | | Date: | Wed, 22 Dec 2004 13:06:30 -0600 |
|
|
| Duh, You are the Man, I misspelled the field in the code. It works great.
Thank You, Thank, Thank You.
Larry
|
|
| | From: | Michael Nuwer [dBVIPS] | | Subject: | Re: CodeBlock? | | Date: | Thu, 23 Dec 2004 16:40:54 -0500 |
|
|
| Larry Kinder wrote:
> Duh, You are the Man, I misspelled the field in the code. It works great.
> Thank You, Thank, Thank You.
Glad to hear it's working.
Happy holidays
--
Michael Nuwer
http://www.ChelseaData.ca/dLearn/
http://www.nuwermj.potsdam.edu/dSamples/
|
|
