Crystal Reports Need multi lines to list out on one line

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Need multi lines to list out on one line

Author	Message
Paula J Groupie Joined: 22 Aug 2011 Location: United States Online Status: Offline Posts: 51	Topic: Need multi lines to list out on one line Posted: 25 Feb 2013 at 5:21pm
	I have a report that list account number (ch_pno), insurance code (carrier_cd) and insuranc name (carrier_name) and the report current looks like this. 113 AA1 Blue Cross 113 BB1 Aetna 113 CC1 Coventry 113 DD1 Butler I want the report to look like this 113 AA1 Blue Cross BB1 Aetna CC1 Coventry DD1 Buler How can I accomplish this?
	Paula J
	IP Logged


Sastry Moderator Joined: 16 Jul 2012 Online Status: Offline Posts: 537	Posted: 25 Feb 2013 at 11:58pm
	HI Follow these steps : --Insert a group on your account number (ch_pno) Now create following formulas and place in appropriate sections. 1st formula // Place this on your group header (ch_pno) Whileprintingrecords; Stringvar str:=' '; 2nd formula //Place this in your detail section Whileprintingrecords; Stringvar str:=str+' ' +carrier_cd+carrier_name; 3rd formula // Place this on your group footer Whileprintingrecords; Stringvar str; {Group Name}+str; Suppress group header and detail, your report will have only group footer where you will be placing the 3rd formula.
	Thanks, Sastry
	IP Logged

Paula J Groupie Joined: 22 Aug 2011 Location: United States Online Status: Offline Posts: 51	Posted: 27 Feb 2013 at 5:53am
	The above is not working for me. It is just giving me... 113 DD1 Butler vs all 4 carrier codes and carrier names I'm confused with the 3rd formula with the {group name}. Do I use ch_pno as the group name?
	Paula J
	IP Logged

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