Textlines from Document Row

Winfried Tiemessen

Hi,

I am struggling with this thing:

I have a quotation, with textlines and items. I want to report back just the textlines from that quotation. I suppose it must be done with three advanced databands, Document.DocEntry, Document.DocumentRow and Document.DocumentDocumentFirstTexlines? I can't get it to work...Any ideas?

Thanks

Winfried Tiemessen

Philipp Knecht

Hi Winfried

You can workaround that by cutting the whole FirstTextLines DataBand out of DocumentRow and put it into the Document DataBand.

hth

Winfried Tiemessen

I just tried what you suggested, no result from databand. Maybe I am missing something. Attached a screenshot.

Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/wtiemessen/textlines.bmp]textlines.bmp[/url]

Philipp Knecht

Hi Winfried

ah ok. I've just read your question again. In this case you need two databands (not nested)

bind the first to the datasource B1_Data.DocumentFirstTextLines
And the second one to B1_Data.RowSubtotalText

reason:
b1 saves texts and subtotals in rdr10 and they are not all related to rows.


Or you can make an extra query upon rdr10 and use only that in one databand.

hth