treport and tsqlquery
Publicado: Jue Feb 05, 2009 9:49 pm
Hi,
What should I put in the DATA definition of a treport column definition if
the data comes from a tsqlquery?
I hope my question is clear enough.
See the code example below.
Ronald.
<code>
with object ::oSQLQuery1
IF :lOpen
:Close()
ENDIF
:cSelect :="SELECT BillingTimeDurationEntries.durationDescription, "+
;
"billingTimeDurationEntries.hoursTotal " + ;
"FROM "
etcetera....
:Open()
:GoTop()
END WITH
REPORT oReport ;
TITLE "Maandoverzicht uren en hardware" ;
PREVIEW MODAL
// first column of sql query
COLUMN OF oReport ;
TITLE "Description" ;
DATA ??????????????????????????????????
// second column of sql query
COLUMN OF oReport ;
TITLE "Hours" ;
DATA ??????????????????????????????????
RUN REPORT oReport
</code>
What should I put in the DATA definition of a treport column definition if
the data comes from a tsqlquery?
I hope my question is clear enough.
See the code example below.
Ronald.
<code>
with object ::oSQLQuery1
IF :lOpen
:Close()
ENDIF
:cSelect :="SELECT BillingTimeDurationEntries.durationDescription, "+
;
"billingTimeDurationEntries.hoursTotal " + ;
"FROM "
etcetera....
:Open()
:GoTop()
END WITH
REPORT oReport ;
TITLE "Maandoverzicht uren en hardware" ;
PREVIEW MODAL
// first column of sql query
COLUMN OF oReport ;
TITLE "Description" ;
DATA ??????????????????????????????????
// second column of sql query
COLUMN OF oReport ;
TITLE "Hours" ;
DATA ??????????????????????????????????
RUN REPORT oReport
</code>