OraFAQ Forum: Reports & Discoverer » Format Trigger To change item value

Home » Developer & Programmer » Reports & Discoverer » Format Trigger To change item value

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Format Trigger To change item value [message #131748]

Tue, 09 August 2005 05:04

karan.shandilya
Messages: 64
Registered: July 2005
Location: mumbai

Member

Hi every ones

My report is based on 6 tables.
Names of employees only is in "emp" table only.
Employee_id is in 3 tables include "emp".
BUT here one record is deleted from "emp" and that went to "emp's replica table "emp1" (for HISTORY).

Now the problem occured in report is that it is not showing tht record and due to this expenditure relevant to this also not coming in tht report. this is natural as the record is deleted .
But now, i have to show all the records in the emp table as well as which are in the emp1;

EXAMPLE- REPORT

NAME employee_id AMOUNT
Venny M-1 74555
M-2
Asurs M-3 45155
M-6
Mac M-7 1452465
Jack M-4 354545

NOW THIS IS MY CURRENT REPORT AND I WANT TO IT COMPLETE, BUT HOW .....

Waiting For Reply
KARAN.

Report message to a moderator

Previous Topic:	need (Beginners)
Next Topic:	Discoverer Privileges - where in the DB?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 19:28:43 CST 2024