Home » Developer & Programmer » Reports & Discoverer » Report Format 'Delimited (Tab)' showing duplicates (Oracle Reports Builder, 10.1.2.0.2, Windows XP)
Report Format 'Delimited (Tab)' showing duplicates [message #500997] Fri, 25 March 2011 00:01 Go to next message
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 #501009 is a reply to message #500997] Fri, 25 March 2011 01:36 Go to previous messageGo to next message
Littlefoot
Messages: 19764
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
No idea. Can you find the difference between yours and different application server environment?
Re: Report Format 'Delimited (Tab)' showing duplicates [message #501025 is a reply to message #501009] Fri, 25 March 2011 03:35 Go to previous messageGo to next message
mmuralikrishnase
Messages: 4
Registered: April 2008
Junior Member
Yes, In our product one version database is using JInitiator and is working fine, the other version is using JRE and output in delimited format is not proper.
Re: Report Format 'Delimited (Tab)' showing duplicates [message #501029 is a reply to message #501025] Fri, 25 March 2011 03:54 Go to previous messageGo to next message
Littlefoot
Messages: 19764
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If possible, try to install JInitiator onto that server as well and see what happens.
Re: Report Format 'Delimited (Tab)' showing duplicates [message #501034 is a reply to message #501029] Fri, 25 March 2011 04:11 Go to previous messageGo to next message
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 Go to previous message
Littlefoot
Messages: 19764
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.
Previous Topic: Dynamically displaying current value in following rows
Next Topic: Displaying Image in an Oracle report
Goto Forum:
  


Current Time: Thu Nov 20 20:30:06 CST 2014

Total time taken to generate the page: 0.15769 seconds