Posted - 03/26/2008 : 17:16:35
| I am developing a report in SSRS 2005. My query is written as command type Text in the data Tab: I am trying to implement Report Execution log to my .rdl file where a row is inserted into an Oracle TABLE Whenever the report is generated. Is there a way to do this without writing a stored proc.
This is what I want to insert into a table----->
INSERT INTO ktran.QC_EXCEPTION_REPORTING VALUES
((Select Nvl(Max(Row_Id),0)+1 From ktran.QC_EXCEPTION_REPORTING),
'I_PPDM UWI of wells in I_PPDM not found in R_Master', count(*), 'Wells QC Report - Integration Layer And Summary Layer.rdl',
-------------> DDLof the oracle table where the row is inserted.
CREATE TABLE ktran.QC_EXCEPTION_REPORTING
SUBJECT_AREA VARCHAR2(80 BYTE),
CATEGORY VARCHAR2(80 BYTE),
REPORT_RULE VARCHAR2(400 BYTE),
REPORT_NAME VARCHAR2(180 BYTE),
Thanks in advance for any help.
Edited by - tash4206 on 03/26/2008 17:34:45