I HAVE A REPORT LAYOUT LIKE THIS
RUNDATE -FIELD DEPTNO-FIELD
------------------------------------------------------------
-------------------
EMPNO-----ENAME------SAL-----COMM----MGR-----
------------------------------------------------------------
------------------
------- ------------ -------- -------- --------
MY REQUIREMENT IS I WANT DEPTNO 10 VALUES IN ONE
PAGE,DEPTNO 20 VALUES IN ONE PAGE,AND 30 IN ONE PAGE.
I WANT LIKE THIS ....
BY SELECT * FROM EMP QUERY ,I GENERATED ONE REPORT.AND
SUPPOSE THAT I HAVE 10 PAGES OF OUTPUT.
WHAT I WANT IS ,I WANT TOTAL PER EACH PAGE.OK I GOT THAT
AND THAT SHOULD BE FORWARDED TO NEXT PAGE AND NEXT PAGES
TOTAL SHOULD BE DISPLAYED
Hi......
I created a report which is geneated in .txt format.
What I do for this is
1.First I change the system parameter mode to character in
the report.
2.Then I place a button in my form to call the report.
code in the button is as follows..
DECLARE
rePid REPORT_OBJECT;
rep_hndl VARCHAR2(100);
BEGIN
rePid := Find_Report_Object('reptxt.rdf');
Set_Report_Object_Property(rePid,Report_deStype,FILE);
Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf');
Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt');
rep_hndl := Run_Report_Object(rePid);
END;
and it is working..
Now the problam is that when I preview the report from the
report builder, it is in the format I needed.
But when I run the form and run the report,Its alligment is
not correct.
Regards
abc
in user parameter property we have list of values.can we
write select query for binding? for example:: select empno
from emp where deptno=:deptnum :deptnum is first parameter
it displays distinct dept nos. if i do like this it is
giving error:: bind variables are not allowed in the select
statement
HI in report builder am creating paramters.for that i have
taken emp table from scott user . in deptnum am displaying
distinct deptno.if i select dept 10 ,empnum drop down
should display empno's of deptno 10. .if i select dept
20 ,empnum drop down should display empno's of deptno
20.for this wat i have to do.
in reports 1og.if we enter a query in list of values then
parameter form displays a dropdown.in that if any ething is
selected then that will display in the report.supp if i am
not selected any value then it should display all the
values.how it is possible?can any one help me........
in user parameter property we have list of values.can we
write select query for binding?
for example::
select empno from emp where deptno=:deptnum
:deptnum is first parameter it displays distinct dept nos.
if i do like this it is giving error::
bind variables are not allowed in the select statement
i don't want to give the path of .Dat file in .Ctl file
dynamically i want to give how
74
Hi......
I created a report which is geneated in .txt format.
What I do for this is
1.First I change the system parameter mode to character in
the report.
2.Then I place a button in my form to call the report.
code in the button is as follows..
DECLARE
rePid REPORT_OBJECT;
rep_hndl VARCHAR2(100);
BEGIN
rePid := Find_Report_Object('reptxt.rdf');
Set_Report_Object_Property(rePid,Report_deStype,FILE);
Set_Report_Object_Property(rePid,Report_FileName,'d:\sasi\reports\reptxt.rdf');
Set_Report_Object_Property(rePid,Report_desName,'d:\sasi\output\repprint.txt');
rep_hndl := Run_Report_Object(rePid);
END;
and it is working..
Now the problam is that when I preview the report from the
report builder, it is in the format I needed.
But when I run the form and run the report,Its alligment is
not correct.
Regards
abc
92
difference between global n context sensitive segments?
suppose u have been seven tables based on that u have to
create a report u don't have access to db. then how do u
find the relation between tables
88
a text item is there what r the different types of triggers
associated with it
85
sequence of firing triggers for text-item is:
1)key_next_item,
2)when_validate_item,
3)post_text_item
Now i change sequence of firing triggers like
when_validate_item,key_next_item...
Is it possible to change sequence? How?
140
suppose there are two textfields t1,t2 in form and we have
some value in textfield t1.now the question is that how can
we copy the value of the t1 to textfield t2?
To Refer this Site to Your Friends 
Site Map
