>"Report Title" + CreateReportCursor(ALIAS()) >>And this is the procedure:
>**************************************************************************************************** >* JJ - For generic reporting, currently for maintenance Lookup tables. >**************************************************************************************************** >* Call: m.TempVariable = 'My Report Title' + CreateReportCursor(ALIAS()) >PROCEDURE CreateReportCursor( m.AliasToConvert ) > IF !EMPTY(m.AliasToConvert) > LOCAL ; > lcTable, ; > lcFields > lcTable = ALLTRIM(UPPER(JUSTSTEM(m.AliasToConvert))) > lcFields = '' > lnColumnCount = FCOUNT(m.AliasToConvert ) > FOR ix =1 TO lnColumnCount > lcFields = m.lcFields + IIF(m.ix > 1, ', ','') + FIELD(ix) + ' AS Fld'+TRANSFORM(ix) > ENDFOR > RunSQL = 'SELECT ' + lcFields + ' FROM ' + m.AliasToConvert + ' INTO CURSOR ReportCursor' > &RunSQL > ENDIF > RETURN '' >**************************************************************************************************** >I would do this instead in Report's DE Init method.