ReportServer Forum

abhijitMehta

Member

Registered: 2015-09-28

insert into oracle table

How can I insert rows to an oracle table from Reportserver ?

Arno Mittelbach

datenwerke

Registered: 2012-02-14

Re: insert into oracle table

Hi,

ReportServer comes with an experimental feature for data entry called the "Grid Editor". You can create a grid editor similarly to any other report and it is meant to provide a spreadsheet like view of a database table with edit features. The grid editor is configured via a small script. A very basic script simply defines the name of the database table that the editor should work with

import net.datenwerke.rs.grideditor.service.grideditor.definition.db.* 

def definition = GLOBALS.getRsService(DbGridEditorDefinition.class)

def adapter = definition.getAdapter() 
adapter.setTableName("SOME_TABLE")

return definition;

Have a look at the Administration Guide for further details.

I hope this helps.

Cheers
-Arno