OraFAQ Forum: Reports & Discoverer » How do we customize the records of Tabular report?

Home » Developer & Programmer » Reports & Discoverer » How do we customize the records of Tabular report?

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

How do we customize the records of Tabular report? [message #137306]

Wed, 14 September 2005 08:16

sharma.radha
Messages: 59
Registered: August 2005
Location: mumbai

Member

Hi to every ones

I have tabular report named as Bud_PRE_F, it has 4 columns say a,b,c,d.
Like-

a b c d
1 x y z
2 e t i
3 h k l

But i want to insert different values for b,c,d where a=2,
from other group.
Is this possible to change the records of tabular report, if it is
then please write solution for this.

Thanks in advance.

Radha.

Report message to a moderator

Re: How do we customize the records of Tabular report? [message #137451 is a reply to message #137306]

Thu, 15 September 2005 05:16

skooman
Messages: 913
Registered: March 2005
Location: Netherlands

Senior Member

Hi Radha,

What do you mean? Do you mean altering the data in the report and saving the new values in the database? If so, no way you can achieve that with a reporting tool...
But I assume you mean something else, so could please explain it (preferably with an example).

Regards,
Sabine

Report message to a moderator

Re: How do we customize the records of Tabular report? [message #137959 is a reply to message #137451]

Mon, 19 September 2005 02:18

sharma.radha
Messages: 59
Registered: August 2005
Location: mumbai

Member

Hi Sabine,
Lets take an simple example-
emp_id Dept_id Name Acct_id
1 12 x 1-f
2 23 y 2-f
3 26 z 3-f
4 23 n 4-f

This report is based on tables A,B,C,D.
____________________________________________________
Now i want alteration in display of this report that
The record based on emp_id=2 ie.
"2 23 y 2-f"
will display the values taking from other group and that group
based on tables A,B,C,E..
_______________________________________________________________

I hope this example works to solve my query.

waiting for reply
Bye.

Radha.

Report message to a moderator

Re: How do we customize the records of Tabular report? [message #138003 is a reply to message #137306]

Mon, 19 September 2005 06:15

kiran
Messages: 503
Registered: July 2000

Senior Member

If my understanding is correct , you just need to add a where condition to your query (report source) as emp_id=2.

--Kiran.

Report message to a moderator

Re: How do we customize the records of Tabular report? [message #138155 is a reply to message #138003]

Tue, 20 September 2005 08:23

sharma.radha
Messages: 59
Registered: August 2005
Location: mumbai

Member

Hi Kiran,
Kiran you are correct that i have to add where clause for id=2 in the source query.
But how can i achieve this?

Suppose this is the source query-

Select a.x,b.y,c.z from a,b,c
where c.m like 'DRN%'
/
But i want the different record where a=2 from the other query.
Can it be achieved by writing pl/sql coding?
Now in what manner i write my condition as a=2 in the sorce query.

Are you talking about the use of subquery?
I think i make my question quite confusing.

waiting for your response

Radha.

Report message to a moderator

Re: How do we customize the records of Tabular report? [message #138192 is a reply to message #137306]

Tue, 20 September 2005 12:27

kiran
Messages: 503
Registered: July 2000

Senior Member

Can you be bit clear.I did not get your question.
Please do post your table structures.That will be helpful.

--Kiran.

Report message to a moderator

Re: How do we customize the records of Tabular report? [message #138440 is a reply to message #138155]

Thu, 22 September 2005 00:59

justchakri
Messages: 27
Registered: September 2005
Location: Bangalore

Junior Member

Hi Radha,
Did gou get the logic for your question?
If yes plz post it here!

Smile

Thanks,
Chakri

Report message to a moderator

Previous Topic:	Passing Parameters from Oracle Apps to Reports 6i
Next Topic:	display message in no data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 13 04:19:27 CDT 2024