display in browse - problem! help

Yohn

Member
Hy!
My problem is:
I have a browse witch is temp table. One row of that browse is sum of two other rows.

Under sum row i draw browse witch is temp table too. In him I want to display the sum of sum row.

thx.

code example:



DEFINE BROWSE brwTT
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS brwTT C-Win _STRUCTURED
QUERY brwTT NO-LOCK DISPLAY
tt.vr-fakture FORMAT "99":U
tt.br-fakture FORMAT ">>>>>>>>>>>,999":U
tt.izn-policrano COLUMN-LABEL "Policirano" FORMAT "->>>,>>>,>>9.99":U
tt.sts-stavke COLUMN-LABEL "Status" FORMAT ">>":U
tt.dat-dospjeca COLUMN-LABEL "Dospjeće" FORMAT "99.99.9999":U
tt.dug-val-obracuna COLUMN-LABEL "Fakturirano" FORMAT "->>>,>>>,>>9.99":U
tt.potr-val-obracuna COLUMN-LABEL "Naplaćeno" FORMAT "->>>,>>>,>>9.99":U
tt.potr-val-obracuna - tt.dug-val-obracuna COLUMN-LABEL "Saldo" FORMAT "->>,>>>,>>9.99":U
WIDTH 18 COLUMN-FGCOLOR 1
tt.sif-val-obracuna COLUMN-LABEL "VOB" FORMAT "999":U
tt.dat-zaduzenja FORMAT "99.99.9999":U WIDTH 14.8
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
WITH NO-ASSIGN NO-ROW-MARKERS SEPARATORS NO-VALIDATE SIZE 139 BY 15.95 FIT-LAST-COLUMN.

DEFINE BROWSE brwTTsumFak
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS brwTTsumFak C-Win _STRUCTURED
QUERY brwTTsumFak NO-LOCK DISPLAY


/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
WITH NO-ROW-MARKERS SEPARATORS SIZE 22 BY 2.52 FIT-LAST-COLUMN.


What i need is to count total of tt.dug-val-obracuna in browse brwTTsumFak.
Can someone help me with this?
thx.
 
Back
Top