Running a Report(6i) from a Menu in Forms and publishing on the Web

if i have a report which has the following query
select empno,ename,deptno
from emp
where ename like :p_ename

and from my form in a button i have the following proc

PROCEDURE PRINTRPT IS
BEGIN
    IF GET_APPLICATION_PROPERTY(USER_INTERFACE) = 'WEB' THEN
                
 WEB.SHOW_DOCUMENT(:GLOBAL.REP_URL|| '&report=' ||'FM07D10'||'.rep','_BLANK');
         WEB.SHOW_DOCUMENT(:GLOBAL.REP_URL|| '&report=' ||'FM07D10'||'.rep&userid=' || :GLOBAL.CONNECT|| '&mode=bitmap&destype=cache&paramform=no&desformat=PDF&P_ename='||TO_CHAR(:CTRL01.ename);

         
      ELSE
         RUN_PRODUCT(REPORTS,'FM07D10',ASYNCHRONOUS,
              RUNTIME,FILESYSTEM,PL_ID,NULL);
          END IF;

END;

Now when i try to run the report using the application server i dnt get any output..if i remove the where condition in the report im getting output...i think its bcoz of the like.is there any solution for this

What is the value of :CTRL01.ename ?

:CTR01.ename = JOHN SMITH

Maybe you can try this:

... desformat=PDF&P_ename=%'||:CTRL01.ename||'%';

so the report query will look like:
select empno,ename,deptno
from emp
where ename like '%JOHN SMITH%';

Assumed: unix app server (I use Solaris 8 & 9)
You need to first configure a printer at the OS level.  Once you have the OS recognizing a printer, you reference the printer with the variables TK_PRINT & TK6_PRINT.
Also have your REPORTS60_PATH set.  And your 6iserver.conf file should have the proper aliases set (if you're using the CGI-BIN).

Best type of destype is 'pdf' - portable and users can print out at will.

And...the app server must have an X server (Xvfb, Xsun whatever) with security disabled for documents to come up - otherwise REP-3000 errors occur.

This is just a snapshot of all the config. needed to get reports to print, display whatever from a 9iAS.


From my (limited) understanding of the programming portion, you should be using the RUN_REPORT_OBJECT which also requires using FIND_REPORT_OBJECT if you want to call a report from within a form.  You might be able to get away with using RUN_OBJECT but that's all we've ever used here.

hth,
bp

OK - just an update here. We're actually trying the WEB.SHOW_DOCUMENT now with some limited success.  So plese disregard what I said about the RUN_REPORT_OBJECT; turns out that's quite a bit more difficult to implement.

Other things to verify - what's your URL look like to generate the report?