Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: layout detailsection Post Reply Post New Topic
Author Message
Thio23
Newbie
Newbie


Joined: 23 Jul 2007
Online Status: Offline
Posts: 4
Quote Thio23 Replybullet Topic: layout detailsection
    Posted: 23 Jul 2007 at 4:50am
Hello,
 
I've got one more question at the moment.Embarrassed
 
I have a detailsection which looks, for example, like this
 
customer                                 city
 
It can now happen that on customer is in differetn cities, so the printout looks like this
 
customer 1                            city 1
                                              city 2
                                              city 3
Customer 2                            city 1
                                              city 2 
 
I need a layout which looks like this:
 
customer 1                            city 1, city 2, city 3
customer 2                             city 1, city 2
 
How can I achieve this.
 
This whole thing is in a subreport.
 
Please Help!
 
Thanks
 
Thio23


Edited by Thio23 - 23 Jul 2007 at 4:50am
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 23 Jul 2007 at 10:29am
This might work.
 
Create a formula that looks something like this:
 
StringVar Cities;
if previousIsNull({table.Customer}) or ({table.Customer} <> previous({table.Customer} then Cities := {table.City}
else Cities := Cities + {table.City};
Cities
 
Put the customer information and this formula  in the customer group footer.
 
-Dell
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.016 seconds.