Hi,
I am trying to execute two queries and save them into two table file's.Of which one i am using to populate a combo box and the other to display a variable.But i am not able to display either of the values.I am pasting the code below-

Kindly help me in solving this issue.

This message has been edited. Last edited by: Aditya,

Both of your TABLE FILE s/b

TABLE FILE SQLOUT, not 1,2

Aditya,

1) Ensure you are getting data:

TABLE FILE SQLOUT
PRINT MTCH_CNT
-* ON TABLE HOLD AS REPORT_1
END
-EXIT


If you are getting data, replace the -EXIT with a -RUN and uncomment the HOLD files.


Should work...Tom

P.S. May want to ON TABLE HOLD AS REPORT_1 FORMAT ALPHA

quote:

COMPUTE OPTION1/A100 =
'' || PREPORTNO || '' ;

aditya,
can you show us please what gets actually made for Report 2? We can't tell from your example.
the option statement needs to be

<option name="FRED">pick fred</option>

which you get with something like this:

OUTPUT/A110 = 
'<OPTION VALUE="' | GUYSNAME | '"> pick' | GUYSNAME |   '</OPTION>';