| Report Format 'Delimited (Tab)' showing duplicates [message #500997] |
Fri, 25 March 2011 00:01  |
mmuralikrishnase
Messages: 4
Registered: April 2008
|
Junior Member |
|
|
Hi,
When I am printing a report in Delimited report format using the default delimiter "Tab", the heading lables is getting printed for all rows( which is fine ) and extra rows of heading labels is getting printed.
Ex:
If I have a heading labels Deptno, Dname and Loc and related data
which I print in delimited format, the output will be as follows:
Deptno Dname Loc 10 Accounting NewYork
Deptno Dname Loc 20 Research Dallas
Deptno Dname Loc 30 Sales Chicago
Deptno Dname Loc 40 Operations Boston
Deptno Dname Loc Deptno Dname Loc
Other report formats are working fine.
The same report in different application server environment is working fine.
Any solution for this
|
|
|
|
|
|
|
|
|
|
| Re: Report Format 'Delimited (Tab)' showing duplicates [message #501034 is a reply to message #501029] |
Fri, 25 March 2011 04:11  |
mmuralikrishnase
Messages: 4
Registered: April 2008
|
Junior Member |
|
|
JInitiator was removed because it has some compatibility issues with the newer versions.
This issue might work, but other issues will come.
The issue is coming only when the records are printed in more than one page.
If report is printed in single page in PDF format then in Delimited format also no problem.
Is there any way to supress the header labels when there is no data for that row?
|
|
|
|
| Re: Report Format 'Delimited (Tab)' showing duplicates [message #501036 is a reply to message #501034] |
Fri, 25 March 2011 04:25 |
 |
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Perhaps you might create a format trigger (on a frame that contains those labels). It would do something like this:
l_cnt number;
begin
select count(*)
into l_cnt
from emp
where deptno = :deptno;
return (l_cnt > 0);
end;
If there are no records that belong to that DEPTNO, format trigger would return FALSE and header labels wouldn't be displayed.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
