Home » Developer & Programmer » Reports & Discoverer » merging two columns
merging two columns [message #343714] Wed, 27 August 2008 22:04 Go to next message
radhavijay
Messages: 29
Registered: July 2008
Junior Member
hi all,
i had got an issue,
im developing a report in financial module.
i want to get invoice number and payment number in only one column in report.
in database they both are stored in diffent tables.
so how to get both values in same column in report.

please help me

thanks in advance,
radha
Re: merging two columns [message #343791 is a reply to message #343714] Thu, 28 August 2008 03:16 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

Hi,

show Your work or any query If anything

kanish

Re: merging two columns [message #343801 is a reply to message #343791] Thu, 28 August 2008 03:42 Go to previous messageGo to next message
radhavijay
Messages: 29
Registered: July 2008
Junior Member
hi
my query is
select a.invoie_num,b.check_number,a.invoice_date,b.check_date from ap_invoices_payments_all a,b.ap_checks_all where a.check_id=b.check_id

my report o/p is

pjno date
invoie no invoice date
check no check date

my report o/p must be in the above shown way.
im not getting how to merge tht two column values into one column in report.
please help me.
its urgent
thanks in advance
radha
Re: merging two columns [message #344149 is a reply to message #343714] Thu, 28 August 2008 22:17 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

use the concatenation simple

kanish
Re: merging two columns [message #344151 is a reply to message #343714] Thu, 28 August 2008 22:31 Go to previous messageGo to next message
radhavijay
Messages: 29
Registered: July 2008
Junior Member
hi
my issue is not tht.
i must get invoice details under tht row i must get payment details corresponding invoice detils

example

invoice number=101
then payment numbers are 1001,10002,10003
output must be

number
----------
101-invoiceno
1001-payment
10002-payment
10003-payment
group by customer name

this is my issue.
i had wrriten query
select col1 as "sorta",
col2 as "sortb",
null paynum
from table1 a,table 2 b
where a.col1=b.col2
union all
select col1 as "sorta",
col2 as "sortb",
null invnum
from table1 a,table3 c
where a.col1=c.col1
order by sorta

i had wrriten query like this
im getting all invocie detils first and then im getting payment detils.
but im must get invoice detils and its corresponding payment details group by customer name.

please help me.its urgent
thanks,
radha
Re: merging two columns [message #344467 is a reply to message #343714] Fri, 29 August 2008 22:28 Go to previous messageGo to next message
mm_kanish05
Messages: 487
Registered: January 2007
Location: Chennai
Senior Member

what is the link between invoice table and payment table.
better you can show your structure of invoicetable and payment table.


wbr
kanish.

Re: merging two columns [message #345308 is a reply to message #344467] Tue, 02 September 2008 22:52 Go to previous message
radhavijay
Messages: 29
Registered: July 2008
Junior Member
link between invoice table an payment table is invoice_id

thanks,
radha
Previous Topic: Trying to find out the % sal for total sal
Next Topic: drill down reports
Goto Forum:
  


Current Time: Tue Dec 06 12:30:53 CST 2016

Total time taken to generate the page: 0.09117 seconds