After parameter form trigger in report builder executes twice

Posted on 2003-10-23
Last Modified: 2007-12-19
Dear All,
Actually what i do is that i call a DB proc in after parameter form trigger to prepare data in a table. but as this trigger fires twice so the proc s called twice and it take double time
Any solution plz so that i can execute the proc just once.

Question by:dilshad_ch
LVL 48

Expert Comment

ID: 9606117
Try to fire the trigger in BEFORE REPORT trigger.

Expert Comment

ID: 9606598
So you need to figure out what events fire your trigger. make sue only one of them working is enough.

Author Comment

ID: 9612789
Thanx for comments but this does not solve my prob.
i cant prepare data in before parameter fprm trigger.
Plz tell is this default behaviour of report builder that it calls after parameter form trigger twice?
or is this a bug of RB?
and how to control it?
SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

LVL 48

Expert Comment

ID: 9613177
It is not usual to execute this trigger twice. Download from OTN the last version of Reports with the latest patchset and try it.

By the way I mean BEFORE REPORT TRIGGER. It is after Parameter Form trigger. If I do not use the right name

Author Comment

ID: 9613199
refference to my last comments
read as
i cant prepare data in before report trigger
LVL 11

Expert Comment

ID: 9613444
You could create a global variable or a parameter and set it in the After Parameter Form trigger. In the After Parameter Form trigger, you will check its value and decide to run the proc based on that value.

If variable/parameter = 1 Then
    Run Proc;
    variable/parameter = 0
End If;


Author Comment

ID: 9613483
Thanx Joe for sparing time,
1-global variables odes not work in report builder
2-We cant use parameter as it initializes the parameter again when called 2nd time so as the case with variables.
so your provided code will not work we have already tested it

LVL 48

Accepted Solution

schwertner earned 200 total points
ID: 9613609
Try to reinstall Reports and download the latest version of Reports. Again - it is the normal functionality of Reports.

Featured Post

Revamp Your Training Process

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Developer 6 75
Field name with special character (Ñ) in Oracle 11 141
make null the repeated levels 2 37
populate value based on what is selected in lov 2 37
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question