Home » Developer & Programmer » Reports & Discoverer » Customize Report (Windows XP Oracle Forms 6i,)
Customize Report [message #314564] Thu, 17 April 2008 03:08 Go to next message
*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 637 times)
Re: Customize Report [message #314572 is a reply to message #314564] Thu, 17 April 2008 03:34 Go to previous message
Littlefoot
Messages: 20891
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.
Previous Topic: Report is running very slowly
Next Topic: Status Infos during long reports
Goto Forum:
  


Current Time: Sun Dec 04 12:46:02 CST 2016

Total time taken to generate the page: 0.07471 seconds