Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tash4206
Starting Member
7 Posts |
 Posted - 2008-03-26 : 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), '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 |
|
|
|
|
|
|
|
Writing report metadata into a oracle table