Attaching Documents to Data Grids

In addition to or instead of entering cell text, you can attach one or more documents to cells for additional detail. For example, you can attach a Microsoft Word document, Microsoft Excel spreadsheet, XSL, or RPT file. To attach or extract any custom documents to or from the server, you must be assigned the Manage Custom Documents security role. You must also have previously loaded custom documents in the Document Manager.

You can set a size limit for document attachments and a maximum number of document attachments by user when you create an application. You set the limits in the AppSettings attribute for the application metadata.

You can attach multiple documents, but Oracle recommends that you attach no more than three documents to a cell. Each document should be smaller than 100K to limit the performance effect on the database.

To attach a document to a cell:

1. From a data grid, select the cell to which to attach a document.
2. Right-click and select Cell Text.
3. Do one of these steps:

   • To include one document attachment for the cell, click the cell with the [Default] cell text label.

   • To include multiple document attachments for the cell text label entry, click the icon to the right of each cell text row to open the Document Attachment dialog, then attach the document to that cell text row.

4. From your list of custom documents, select one or more documents to associate with the cell, and click Attach.
5. Click OK.

   The attachment is displayed in the Attachments section of the Cell Text dialog box.

   Tip:

   To detach a document from a cell, select the document to detach, and click Detach.