nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Stored procedure in Birt???

megabri

I want to execute a stored procedure before my report generates, where and how would I do that?

Find more posts tagged with

Comments

bgbaird

If I understand, you want to execute a SP, then have the report initiate?

megabri

<blockquote class='ipsBlockquote' data-author="'bgbaird'" data-cid="107716" data-time="1343764129" data-date="31 July 2012 - 12:48 PM">
If I understand, you want to execute a SP, then have the report initiate? </blockquote>
That's correct

bgbaird

You could approach this all within the report.

I might set up two datasets,
DS1(calling the sp and providing a dummy return value)
and DS2, the dataset you really want to use.

In your design, place a data object(obj1), bound to DS1, at the top of the page, and set it's visibility to 0.
Place whatever table, grid, data (obj2)...bound to DS2 below that.

I think "obj1" will fire DS1 before "obj2" fires ds2.

OR...define DS1 to execute your SP, then bind it to a hidden dynamic parameter that accepts the default return from DS1. (this one is a WAG!)

megabri

<blockquote class='ipsBlockquote' data-author="'bgbaird'" data-cid="107740" data-time="1343828704" data-date="01 August 2012 - 06:45 AM">
You could approach this all within the report. 
 
I might set up two datasets, 
DS1(calling the sp and providing a dummy return value) 
and DS2, the dataset you really want to use. 
 
In your design, place a data object(obj1), bound to DS1, at the top of the page, and set it's visibility to 0. 
Place whatever table, grid, data (obj2)...bound to DS2 below that. 
 
I think "obj1" will fire DS1 before "obj2" fires ds2. 
 
OR...define DS1 to execute your SP, then bind it to a hidden dynamic parameter that accepts the default return from DS1. (this one is a WAG!) </blockquote>
Ok, I'll see what I can do with that. I know in actuate when I wanted to execute the stored procedure I'd just put it in one of the start methods of one of the reporting sections. I don't know if I can do the same thing in Birt or not. This is the start method I use to use in Actuate 
 
 
Sub Start( ) 
Super::Start( ) 
' Insert your code here 
' deptName = getUserSite() 
 
Dim aConnection as AcDBConnection 
Set aConnection = New MROConnection 
aConnection.connect() 
 
 
Dim str as String 
Dim dbStmt as AcDBStatement 
 
str = "DECLARE " 
str = str & " v_wonum workorder.WONUM%TYPE; " 
str = str & " BEGIN " 
str = str & " MAXIMO.lirr_rpt_es_brg_ins_proc(p_wonum => '" 
str = str & wonum 
str = str &"', p_status => ''); " 
str = str & " END; " 
 
Set dbStmt = aConnection.Prepare(str) 
dbStmt.Execute() 
 
End Sub

bgbaird

You might check out Jason's post at:

http://www.eclipse.org/forums/index.php/mv/msg/359682/883126/#msg_883126

megabri

<blockquote class='ipsBlockquote' data-author="'bgbaird'" data-cid="107744" data-time="1343829723" data-date="01 August 2012 - 07:02 AM">
You might check out Jason's post at: 
 
<a class='bbc_url' href='http://www.eclipse.org/forums/index.php/mv/msg/359682/883126/#msg_883126'>http://www.eclipse.org/forums/index.php/mv/msg/359682/883126/#msg_883126</a> </blockquote>
I'll check it out. Thanks Brian.