Setup: Reports: Dropping Reports

This page guides you through the process of removing a report from your Report Tree.

Requirements:

• Administrative access to IB Console
• knowledge of how to use IB Console's ISQL to ...
  • load a script (procedure)
  • execute a script/statement/command (procedure)

Procedure:

1. Download this DropReport.sql script to your Desktop.
   1. Right-click on the link above.
   2. Choose Save Target As ...
   3. Save the file to your Desktop.
       
2. Get ISQL ready to run your commands.
   • If you don't know how, click here to learn, and then return.
      
3. Install the DropReport procedure into your database:
    
   1. (Note that you are about to open a separate window.) Click this link and then copy and paste the entire text from that window into the top window of the ISQL panel.
      • You may then close that extra browser window.
         
        
   2. Click the Lightning Bolt icon to execute.
      • The text should simply disappear.
      • If you get an error message indicating ...
          Unsuccessful metadata update
          Procedure DROPREPORT already exists
        then remove the procedure by executing the following:
          drop procedure DropReport;
          commit;
        and then try installing the DropReport procedure again.
         
4. Remove the report(s). (Do the following for each report you wish to remove.)
    
   1. Place an 'execute procedure DropReport ...' statement into ISQL:
      
      • If a statement was provided for you, copy and paste that statement into ISQL.
      • Otherwise, copy the following statement ...
            execute procedure DropReport 'FileName.rpt';  
        ... and change 'FileName.rpt' to the report's actual file name.
          
   2. Click the Lightning Bolt icon to execute, and note the result.
      • If the result is anything but 'Successful', expand the result message box so you can read the whole message, and take appropriate action.
         
   3. Commit by executing the following command in ISQL:
      • commit;
         
   4. Confirm success:
      1. In Bundle-Track, open the reports list to confirm that the report is no longer listed.
      2. If necessary, troubleshoot.
      3. Close the reports list.
          
5. Drop the DropReport procedure:
   
   • Execute the following commands in ISQL:
     • drop procedure DropReport;
     • commit;
        
6. Exit ISQL and IB Console.

We welcome your comments at support@bundle-track.com.

If you would like our live assistance, you may hire us at our professional services rate.