Home » Developer & Programmer » Reports & Discoverer » use one group column in another group in report (Oracle Reports version 10.1.2.3.0)
use one group column in another group in report [message #651573] Fri, 20 May 2016 03:18 Go to next message
mist598
Messages: 1191
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.
Re: use one group column in another group in report [message #651575 is a reply to message #651573] Fri, 20 May 2016 03:45 Go to previous messageGo to next message
cookiemonster
Messages: 13895
Registered: September 2008
Location: Rainy Manchester
Senior Member
Select the same column twice, put one in each group.
Re: use one group column in another group in report [message #651580 is a reply to message #651575] Fri, 20 May 2016 06:30 Go to previous messageGo to next message
mist598
Messages: 1191
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
Re: use one group column in another group in report [message #651585 is a reply to message #651580] Fri, 20 May 2016 08:12 Go to previous messageGo to next message
cookiemonster
Messages: 13895
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.
Re: use one group column in another group in report [message #651588 is a reply to message #651585] Fri, 20 May 2016 08:42 Go to previous messageGo to next message
mist598
Messages: 1191
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
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
Re: use one group column in another group in report [message #651589 is a reply to message #651588] Fri, 20 May 2016 09:02 Go to previous message
cookiemonster
Messages: 13895
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.
Previous Topic: Customized report error out after upgraded
Next Topic: Report Builder has stopped working
Goto Forum:
  


Current Time: Mon Oct 19 17:47:50 CDT 2020