Solved

After parameter form trigger in report builder executes twice

Posted on 2003-10-23
10
2,012 Views
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.

Dilshad
0
Comment
Question by:dilshad_ch
10 Comments
 
LVL 48

Expert Comment

by:schwertner
ID: 9606117
Try to fire the trigger in BEFORE REPORT trigger.
0
 
LVL 8

Expert Comment

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

Author Comment

by:dilshad_ch
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?
Thanx
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 48

Expert Comment

by:schwertner
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
0
 

Author Comment

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

Expert Comment

by:joekendall
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;

Joe
0
 

Author Comment

by:dilshad_ch
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

Dilshad
0
 
LVL 48

Accepted Solution

by:
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.
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

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…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

840 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