Home » Developer & Programmer » Reports & Discoverer » SRW (oracle 10g reports)
SRW [message #585179] Wed, 22 May 2013 14:38 Go to next message
thelearner
Messages: 96
Registered: April 2013
Location: INDIA
Member
Hi,
I have one doubt.
EMPNO  ENAME  SAL  JOB        DEPTNO
7369   SMITH  800  CLERK        20
7521   WARD   1200 SALESMAN     30 

Instead of data in column deptno I want to display like this
EMPNO  ENAME  SAL  JOB        DEPTNO
7369   SMITH  800  CLERK       RESEARCH
7521   WARD   1200 SALESMAN    SALES 


There is any possibility using SRW package in reports to convert into above format.

thanks in advance.

[Updated on: Wed, 22 May 2013 14:40]

Report message to a moderator

Re: SRW [message #585188 is a reply to message #585179] Wed, 22 May 2013 15:38 Go to previous message
Littlefoot
Messages: 18833
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
SRW package? No idea, but an ordinary JOIN is perfectly capable of doing that job.
Previous Topic: pdf tags in Oracle reports
Next Topic: Masking number to word
Goto Forum:
  


Current Time: Sun Apr 20 00:17:19 CDT 2014

Total time taken to generate the page: 0.08698 seconds