all i want is to let me know about hiding the username and password of the report 9i( at address bar ) so, please answer me quickly...
thanks alot.

There are 2 ways

1- using form builder to call report

*Create new form
*on_logon

logon (‘scott’,’tiger’||’@’||’service name’);

* use a button
When button pressed

run_report;

Create PROCEDURE*

/* Formatted on 2005/04/12 15:20 (Formatter Plus v4.8.5) */

PROCEDURE run_report
IS
  pl_id     paramlist;
  pl_name   VARCHAR2 (500) := 'tempdata';
BEGIN pl_id := GET_PARAMETER_LIST (pl_name);

  IF ID_NULL (pl_id)
  THEN
     pl_id := CREATE_PARAMETER_LIST (pl_name);

     IF ID_NULL (pl_id)
     THEN
        MESSAGE ('Error creating parameter list ' || pl_name);
        RAISE form_trigger_failure;
     ELSE
        RUN_PRODUCT (reports,
                     'Report_name.rep',
                     synchronous,
                     runtime,
                     filesystem,
                     pl_id,
                     NULL
                    );
        DESTROY_PARAMETER_LIST (pl_id);
     END IF;
  ELSE
     MESSAGE ('Parameter list ' || pl_name || ' already exists!');
     RAISE form_trigger_failure;
  END IF;
END;

2- using shortcut for report

C:\orant\BIN\RWRUN60.EXE c:\report_name.rep scott/tiger@servicename