Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle
|
Oracle General Oracle database discussions.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old April 7th, 2004, 04:38 AM
Authorized User
 
Join Date: Jun 2003
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default Rows into columns

Hi,

I have two table customer_master and payment

customer_master
customer_cd char(5)
customer_name varchar2(50)

payment
customer_cd char(5),
transaction_number number,
transaction_date date

Now my client wants an quarterly ageing report in the format shown below (This is for the first quarter)

          <----Jan----> <----Feb----> <----Mar---->
Code Name Day Amt Tran# Day Amt Tran# Day Amt Tran#
1 A 02 100 22 13 200 34 07 500 158
2 B 08 150 555 01 600 118 25 150 333

code -> customer code, Day-> day of transaction date
tran# -> transaction no.

Please note, it is possible that a customer pays more than once in a month. so in this case that record will be below the first record of that customer and its data aligned with the month of the payment.

I am using Forms 6 and will create this report through Report Builder.

Could anyone help me out.

Thanks





Similar Threads
Thread Thread Starter Forum Replies Last Post
Refer to Rows and Columns RayL Access VBA 3 May 23rd, 2007 09:13 AM
Rows 2 Columns kilika Oracle 0 October 14th, 2005 01:16 PM
Columns To Rows alyeng2000 SQL Language 2 March 11th, 2005 03:08 PM
showing columns as rows zee_ahmed2002 SQL Server 2000 2 October 28th, 2004 04:58 AM
Rows into columns shamsad SQL Language 0 April 7th, 2004 04:39 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.