Report Design: Need to merger to rows columns

Need to merger to rows columns

Printed From: Crystal Reports Book
Category: Crystal Reports .NET 2003
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=19377
Printed Date: 05 May 2024 at 9:02pm

Topic: Need to merger to rows columns

Posted By: aarti
Subject: Need to merger to rows columns
Date 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.

Replies:

Posted By: hilfy
Date 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
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics