>
>You could put code in the OpenTables method of the report to create a second cursor with all the extra fields you need. Set a relation to the main cursor so that the new cursor is always on the appropriate record. In your report, you can just reference the data in the new cursor. Here's an example of the code in OpenTables.
>
>
>NODEFAULT
>SELECT **** FROM *** INTO CURSOR tmpExtraStuff
>INDEX ON *** TAG ***
>DODEFAULT()
>SELECT This.InitialSelectedAlias
>SET RELATION TO ** IN tmpExtraStuff
>
>
>If you don't open tables in the DE, you could do something like this:
>
>
>lcAlias = ALIAS()
>NODEFAULT
>SELECT **** FROM *** INTO CURSOR tmpExtraStuff
>INDEX ON *** TAG ***
>DODEFAULT()
>SELECT (m.lcAlias)
>SET RELATION TO ** IN tmpExtraStuff
>
>
>Now in your report add objects with expressions such as tmpExtraStuff.Field1, tmpExtraStuff.Field2, etc.
This is very interesting approach. I didn't know of method OpenTables in the report. I will try this approach. Thank you very much.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham