| Customize Report [message #314564] |
Thu, 17 April 2008 03:08  |
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
|
Senior Member |
|
|
Hi guyz,
Hope all r keeping well.....
guyz i have some problem i wanna to make one customize report let me explain you in details.
below are the two tables
1)ASSET_MASTER_NEW
ID_NO VARCHAR2(15)
USERNAME VARCHAR2(40)
BOOK# NUMBER(6)
ARN_NO NOT NULL VARCHAR2(15)
DATE_OF_DELIVERY NOT NULL DATE
REMARKS VARCHAR2(200)
2)ASSET_DETAILS_NEW
ARN_NO VARCHAR2(15)
ITEM_DESCRIPTION VARCHAR2(100)
MANUFACTURER VARCHAR2(60)
PART# VARCHAR2(30)
SERIAL# VARCHAR2(60)
DEPT VARCHAR2(20)
PROCURED_BY VARCHAR2(30)
CATEGORY VARCHAR2(15)
OPERATIONS VARCHAR2(20)
QTY NUMBER(3)
UNIT_PRICE NUMBER(9,2)
DATE_OF_RETURN DATE
REMARKS VARCHAR2(200)
ASSET_STATUS VARCHAR2(15)
acutally i wanna to printout all the record belongs to ID_No
but i need some field from table 1 and some from table 2
the group item should be
ID_NO
NAME
DEPT
OPERATION
------------------------------------------------------------
ID_NO = XXXXXXX
NAME = XXXXXXX
DEPT = XXXXXXX
OPERATION = XXXXXXX
------------------------------------------------------------
ITEM_DESCP|MANFACTURER|PART#|SERIAL#|DELIVERYDATE|RETURNDATE|ETC
------------------------------------------------------------
XXXXXXXX XXXXXXXXXX XXX XXXX XXXXX XXXX XXX
XXXXXXXX XXXXXXXXXX XXX XXXX XXXXX XXXX XXX
XXXXXXXX XXXXXXXXXX XXX XXXX XXXXX XXXX XXX
XXXXXXXX XXXXXXXXXX XXX XXXX XXXXX XXXX XXX
the rest should display in tubular format as above how can i solve this problem.
can anyone explain how to make this kind of report. and for example i attach two snap shots also
-
Attachment: Sample.pdf
(Size: 131.80KB, Downloaded 1641 times)
|
|
|
|
| Re: Customize Report [message #314572 is a reply to message #314564] |
Thu, 17 April 2008 03:34  |
 |
Littlefoot
Messages: 21809
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
When do you plan to act accordingly to suggestions given in OraFAQ Forum Guide? I'm not talking about IM speak (although it bothers me), but formatting which doesn't exist.
Although these are just suggestions (you don't have to follow them if you don't want to, but - equally - I don't have to answer such a question if I don't want to), they enormously help forum members who would like to help you to understand what you are trying to say. Every time I see such a mess, I got a headache and some little worm in my head says "move on" (in other words, close this topic and move on to another, properly formatted one).
So, tell me, how much does it cost to type [code] at the beginning and [/code] at the end of message part which should be formatted?
Can you write a query which will fetch information you need? Looking at this (unformatted mess, sorry), it seems that the solution requires a simple JOIN.
Once you do that (using SQL*Plus or, possibly, one of the GUI tools), copy/paste this query into the Reports Builder. It will create its own (default) group.
Now grab ID_NO, NAME, DEPT and OPERATION and move them out, into a new group.
Use Report Wizard to create a "Group Above" report; wizard will already suggest the rest and create a default layout which will probably have to be adjusted, but - basically - that's all.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
