Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports .NET 2003 : Report Design
Message Icon Topic: Need to merger to rows columns Post Reply Post New Topic
Author Message
aarti
Newbie
Newbie


Joined: 25 Aug 2011
Online Status: Offline
Posts: 17
Quote aarti Replybullet Topic: Need to merger to rows columns
    Posted: 08 Apr 2013 at 8:27pm
Hi,
 
I am using crystal report 10, I want to merge two rows in the report on conditions
 
I have following column:
 
Date              AccountNo  BillingCCY   BillingAmount     CCY      Amount
-----------------------------------------------------------------------------------------
22/01/2013   12345         EUR             100                 
22/01/2013   12345                                                     USD      200
03/05/2013   33333         USD             50
03/05/2013   33333                                                     USD      100
 
 
I want to merge the rows on the basis of Date and AccountNo column. If date and AccountNo is similar then merge rows as follows:
 
Date              AccountNo  BillingCCY   BillingAmount     CCY      Amount
-----------------------------------------------------------------------------------------
22/01/2013   12345         EUR             100                   USD     300      
03/05/2013   33333         USD             50                     USD     150
 
 
Thanks in Advance.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 15 Apr 2013 at 7:59am
tIf there is only ever one value in a column for a given date/accountno you could try this:
 
1.  Group on Date and AccountNo.
2.  Suppress the details section.
3.  Put the data in the group header or footer.
4.  Instead of using the fields for BillingCCY, BillingAmount, CCY, and Amount, use the Max() of each of the fields.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.