OraFAQ Forum: Reports & Discoverer » use one group column in another group in report

Home » Developer & Programmer » Reports & Discoverer » use one group column in another group in report (Oracle Reports version 10.1.2.3.0)

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

use one group column in another group in report [message #651573]

Fri, 20 May 2016 03:18

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Hi all,

We need to use one group column in another group, need to use if condition but we will get incompatibility issues.

can we have another approach please.

I am doing EBS xml report.

Report message to a moderator

Re: use one group column in another group in report [message #651575 is a reply to message #651573]

Fri, 20 May 2016 03:45

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

Select the same column twice, put one in each group.

Report message to a moderator

Re: use one group column in another group in report [message #651580 is a reply to message #651575]

Fri, 20 May 2016 06:30

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Quote:

Select the same column twice, put one in each group.

But cannot create duplicate column in each group right

Report message to a moderator

Re: use one group column in another group in report [message #651585 is a reply to message #651580]

Fri, 20 May 2016 08:12

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

And as per usual you've not given us enough information to help.
So post the full query.
Explain what groups you have.
Explain what you want in both groups.

Report message to a moderator

Re: use one group column in another group in report [message #651588 is a reply to message #651585]

Fri, 20 May 2016 08:42

mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad

Senior Member

Quote:

So post the full query.
Explain what groups you have.
Explain what you want in both groups.

Let say I have 2 groups G_INVOICE and G_LINES,i am going to writing below code in the G_INVOICE group and using G_LINES SHIP_COUNTRY column

Code: [Select all] [Show/ hide]

function CF_MSGFormula return Char is
v_msg varchar2(240);
Begin
if :BILL_COUNTRY!='DE' and :SHIP_COUNTRY!='DE' then
 'Please do not print invoice'
end if;
end;

My Requirement is i want to use G_LINES group SHIP_COUNTRY column in the G_INVOICE Group.

Thanks

Report message to a moderator

Re: use one group column in another group in report [message #651589 is a reply to message #651588]

Fri, 20 May 2016 09:02

cookiemonster
Messages: 13967
Registered: September 2008
Location: Rainy Manchester

Senior Member

Do you take some form of perverse pleasure in not answering all the questions you've been asked?
Answer all the questions.

Report message to a moderator

Previous Topic:	Customized report error out after upgraded
Next Topic:	Report Builder has stopped working

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 30 01:14:02 CDT 2025