Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | 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
 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  
 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.04 seconds. Powered By: Snitz Forums 2000