Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: one column rows to multiple columns Post Reply Post New Topic
Author Message
things_451
Newbie
Newbie
Avatar

Joined: 30 Sep 2015
Online Status: Offline
Posts: 2
Quote things_451 Replybullet Topic: one column rows to multiple columns
    Posted: 02 Oct 2015 at 1:33pm
Thats how my data looks like in the report .Now,I need to change the report  data in one column to split into multiple columns.


Here in my report I have two columns EXPORT and Export_NAME. Export_Name has both NET,FIRM values.

I need to split my EXPORT into 2 columns
1.EXPORT where EXPORT_NAME ='NET'
2.EXPORT where EXPORT_NAME  ='FIRM'

If I do that each row is splitting into 2 rows..one for firm and one for net and creating a duplicate row.How do I avoid that?

Thanks

IP IP Logged
praveeng
Senior Member
Senior Member
Avatar

Joined: 11 Jul 2011
Online Status: Offline
Posts: 165
Quote praveeng Replybullet Posted: 04 Oct 2015 at 10:22pm
Hi,

To avoid creating duplicate rows in columns, create two individual reports for NET and Firm using the above filter condition in Record Selection.
Place above created reports side by side and format it.

Let see someone will give the better solution for this requirement.

--Praveen G
Praveen Guntuka,
praveen_guntuka@yahoo.com
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.