Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create Temp table in Reports 6i

Status
Not open for further replies.
hanna123

hanna123

Programmer
Jun 25, 2003
1
US
I am trying to to convert a SQL*Plus script to Reports 6i with a temp table. Any one have any suggestion, please help. The report has 4 column as display below:

LNAME FNAME ID# DIV
Hanna Lee 1 123456 2 IS

ID# has a concatenate of 1 and 2... which I am unable to get this number. This number somehow called from the temp table.

Ay suggetion is very welcome. Please help...


 
Status
Not open for further replies.

Similar threads

thatgirl100
  • Locked
  • Question
Reports 6i - Multiple Pages in Report Header?
Replies
0
Views
394
thatgirl100
thatgirl100
blobby36
  • Locked
  • Question
crystal reports command and oracle tables
Replies
1
Views
212
oradba101
oradba101
OrangeMonkey
  • Locked
  • Question
Reports Builder Novice
Replies
0
Views
243
OrangeMonkey
OrangeMonkey
aalishan
  • Locked
  • Question
Reports 6i shows duplicate lines (rows)
Replies
0
Views
187
aalishan
aalishan
soushi01
  • Locked
  • Question
Oracle reports bulider cannot use CASE WHEN statement 1
Replies
4
Views
331
soushi01
soushi01

Part and Inventory Search

Sponsor

Back
Top