Home » Developer & Programmer » Reports & Discoverer » Report Triggers in D2K
Report Triggers in D2K [message #89788] Sat, 24 July 2004 21:03 Go to next message
Allan
Messages: 11
Registered: July 2004
Junior Member
Hi,

I realize we've got several triggers in Reports viz.

Before Parameter Form Report, After Parameter Form report,

After Report,Before Report and Between Pages.....

Could anyone mention the sequence in which they fire......

and if possible maybe post in an example for each...

I would appreciate an immediate reply...

Thanx in Advance..
Re: Report Triggers in D2K [message #89790 is a reply to message #89788] Mon, 26 July 2004 00:44 Go to previous messageGo to next message
Himanshu
Messages: 457
Registered: December 2001
Senior Member
Hi,
Sequence of Firing Triggers:
1.Before-Parameter Form -- Just before Parameter Form of the report is called.
2.After-Parameter-Form -- After Display of Parameter form.
3.Before-Report --- Just after the report issues the query & before it fetches record.
4.Between-Pages --- When user scrolls from one page to another.
5.After report -- After closing of the report.

HTH
Regards
Himanshu
Re: Report Triggers in D2K [message #90106 is a reply to message #89790] Thu, 28 October 2004 22:04 Go to previous messageGo to next message
ckverma
Messages: 1
Registered: October 2004
Junior Member
How to Refresh my report without pressing refresh button

regard
ckv
Re: Report Triggers in D2K [message #90174 is a reply to message #89788] Fri, 26 November 2004 19:43 Go to previous messageGo to next message
ramu
Messages: 82
Registered: February 2001
Member
Hi
Tell me am confusing about report triggers What is the and when these triggers are useful.
Re: Report Triggers in D2K [message #109522 is a reply to message #89788] Fri, 25 February 2005 01:52 Go to previous messageGo to next message
balakrishna
Messages: 1
Registered: February 2005
Junior Member
The firing sequence is:
before parameter,
after parameter,
befort report,
between pages,
after report.

I want to know about lexical parameters,summary colums,formula colums.if u know please send mail
with excumples.
Re: Report Triggers in D2K [message #111372 is a reply to message #109522] Tue, 15 March 2005 17:19 Go to previous messageGo to next message
Kalpana Srinivas
Messages: 10
Registered: January 2004
Junior Member
hi

Lexical references are placeholders for text that you embed in a SELECT statement. You can use lexical references to replace the clauses appearing after SELECT, FROM, WHERE, GROUP BY, ORDER BY, HAVING, CONNECT BY, and START WITH.You cannot make lexical references in a PL/SQL statement.

You create a lexical reference by entering an ampersand (&) followed immediately by the column or parameter name. A default definition is not provided for lexical references. Therefore, you must do the following:

1. Before you create your query, define a column or parameter in the data model for each lexical reference in the query. For columns, you must enter Value if Null, and, for parameters, you must enter Initial Value. Report Builder uses these values to validate a query with a lexical reference.

2. Create your query containing lexical references.

SELECT Clause:
SELECT &P_ENAME NAME, &P_EMPNO ENO, &P_JOB ROLE FROM EMP

P_ENAME, P_EMPNO, and P_JOB can be used to change the columns selected at runtime.

FROM Clause:
SELECT ORDID, TOTAL FROM &ATABLE

summary columns:
A summary column performs a computation on another column's data. Using the Report Wizard or Data Wizard, you can create the following summaries: sum, average, count, minimum, maximum, % total. You can also create a summary column manually in the Data Model view, and use the Property Palette to create the following additional summaries: first, last, standard deviation, variance.

Formula columns:
A formula column performs a user-defined computation on another column(s) data, including placeholder columns.
ex: create dept report based on dept table.
in data model, place one formula column in group (after loc field). in properties of that formula column, click on pl/sql formula and write as

function CF_1Formula return Number is
x number;
begin
select count(empno) into x from emp
where deptno = :deptno1;
return(x);
end;

in layout editor place a text item in repating frame (next to loc field). in properties of that field select 'source' as 'cf_1' (whatever your formla column name is).

run the report. you can see no. of employyes in the report.

------------

let me know if you clear about your doubts.





Re: Report Triggers in D2K [message #222936 is a reply to message #89788] Wed, 07 March 2007 00:29 Go to previous message
yasjpkn
Messages: 2
Registered: March 2007
Location: Pakistan
Junior Member

Sir !


i want to pass parameter from report on trigger of
(Befor Report) as following


:DEPT:='WHERE DEPTNO IN('||':DEPT'||')';
return (TRUE);

but there is error and report does,nt accept parameter.
please solve my problem thanks.
Previous Topic: Totaling a Time Column
Next Topic: Report dosent work when we format the date in Query ???
Goto Forum:
  


Current Time: Tue Dec 03 15:11:08 CST 2024