I am fairly new to HTML composer but when I import a report (report works fine in report painter) everything seems to work OK. Data is showing in the composer screen, parm box appear, etc

When I run it in composer everything opens as expected, parm boxes are populated but no data is returned to the report.

What am I missing?

This message has been edited. Last edited by: <Kathryn Henning>,

Did you check how the values are passing into the FEX. For example when no value is entered or selected then how you are treating those null values in your FEX. IF your report is based on SQL then I have noticed issues with _FOC_NULL but FOC_NONE works.

Try using -TYPE command and print all your parameters and see how the values are passed into FEX.

I have tried entering that -TYPE just about everywhere and it does seem to do anything. What am I doing wrong?

You need to put the amper after -TYPE,i.e., -TYPE &VAR1
It's easier to look at all at once. Put this at the top of the called FOCEXEC:
-? &
-EXIT

This will show you all your global(&&) and local(&) variables and values...

Ok, so that worked perfectly. Thanks!

When I run thru dev studio for my FEX it displays the variables but when I try and run the HTML page it doesnt do anything.

This ia a very simple report that I just imported thru HTML composer and everything looks good in the composer i.e. brings back data and drop down is populated. Once it is ran it does nothing.

I should say to clarify it does run....the parm boxes are populated but the report is blank

When you say your report is blank, do you mean the actual report window is empty or you are getting the 0 lines message? If it is truly blank, I would check to see if your report is set in HTML composer to display in that report frame. It depends on how you set up your page. If you created a hyperlink in a submit button then you have to tell it where to display it. If you put the report frame on the page and referenced an existing procedure then it should have worked.

I did the latter. I agree it should work. it is displaying data in the HTML Composer window for previewing but it shows a blank report at run time.

Do you have "Auto Execute" property in the report frame set to True?