Subject |
Re: report canrender |
From |
Mervyn Bick <invalid@invalid.invald> |
Date |
Thu, 6 Dec 2018 07:15:14 +0200 |
Newsgroups |
dbase.getting-started |
On 2018-12-06 5:53 AM, charlie wrote:
> Hi... I am having trouble with this:
>
> function TEXT9_canRender()
> this.text = this.parent.text6.text()+this.parent.textadditamt1.text()
> return true
>
> text6 is basically the total of a row in streamframe I am trying to take it from the text box it is situated in on the footerband. textadditamt is the amount of a field.
>
> I am trying to take a total amount of a field from the streamframe and add it to textadditamt which appears in text on the footerband of the report.
>
> text9 is supposed to represent textadditamt + text6.
>
> This works sometimes, but other times text9 is completely blank. Not sure at all why it is blank sometimes.
>
> I am not that familiar with this part of reports. Think I need some help. Thanks much!!!
>
Your code will only work if text6, text9 and textadditamt1 are all on
the same band. Your code also implies that codeblocks provide the
values to the text properties of text6 and textadditammt1.
If this is correct then the blank values are probably caused by a null
value in a field. Try the following. (It's untested so your mileage may
vary.)
function TEXT9_canRender()
this.text = 0
if not empty(this.parent.text6.text())
this.text += this.parent.text6.text()
endif
if not empty(this.parent.textadditamt1.text())
this.text += this.parent.textadditamt1.text()
endif
return
If text6, text9 and textadditamt1 are not all on the same band please
give details of where each one is placed and exactly how the text value
for each text object is derived.
Mervyn.
|
|