SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Writing report metadata into a oracle table
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

tash4206
Starting Member

7 Posts

Posted - 03/26/2008 :  17:16:35  Show Profile  Reply with Quote
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),
'Wells',
'WELLID',
'I_PPDM UWI of wells in I_PPDM not found in R_Master', count(*), 'Wells QC Report - Integration Layer And Summary Layer.rdl',
sysdate);


-------------> DDLof the oracle table where the row is inserted.

CREATE TABLE ktran.QC_EXCEPTION_REPORTING
(
ROW_ID NUMBER(10),
SUBJECT_AREA VARCHAR2(80 BYTE),
CATEGORY VARCHAR2(80 BYTE),
REPORT_RULE VARCHAR2(400 BYTE),
Number_of_Rows NUMBER(10),
REPORT_NAME VARCHAR2(180 BYTE),
ROW_CREATED_DATE DATE
)

Thanks in advance for any help.

Regards,

Sarod

Edited by - tash4206 on 03/26/2008 17:34:45
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000