Solved

After parameter form trigger in report builder executes twice

Posted on 2003-10-23
10
2,005 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 47

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 47

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 47

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

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.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Oracle - SQL Where clause causing Invalid Number Error 4 35
Oracle Listener Not Starting 11 44
run sql script from putty 4 36
error in my cursor 5 34
This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

821 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