| Author |
Message |
KevV
Senior Member
Joined: 19 May 2011
Online Status: Offline
Posts: 106
|
   Topic: Combine Rows
Posted: 12 Jul 2011 at 7:13am |
I have a report that is grouped by route numbers and have the route number listed in the header. I then have stores listed in the detail section below it that are on that route like:
Route: 33054
store:
101
102
103
104
Route: 33055
105
106
107
What I want is for it to look like:
Route: 33054
101 102 103 104
Route: 33055
105 106 107
Thess fields can all be in the header or detail section it doesn't really matter. The store field is not always the same and can have anywhere from 1 to 18 stores. I tried the "Format with Multiple Columns" in the deatil section expert but it gave me issues if I tried to put any other field in the detail section or if I moved it away from the right side of the page so I really need a formula or something where I can put the store field in the center or left side of the page and do the "Underlay" feature or add other fields in to the same section
Thanks
KevV
33054
|
 IP Logged |
|
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 12 Jul 2011 at 7:30am |
if you can place them in a footer you can use 3 variable formula
GH
whileprintingrecords;
shared stringvar X:=""
Details
whileprintingrecords;
shared stringvar X:= X + {table.field} + " "
G F
whileprintingrecords;
shared stringvar X;
supress the g header formala and details section
Edited by DBlank - 12 Jul 2011 at 7:30am
|
|
IP Logged |
|
KevV
Senior Member
Joined: 19 May 2011
Online Status: Offline
Posts: 106
|
Posted: 12 Jul 2011 at 10:24am |
That worked great. I now found on some of the routes there maybe more than one order per store. I need to have it just show the store once. I tried the "suppress if duplicated" in the format field but it didn't do anything. Is there a way to supprress the duplicates?
Thanks
KevV
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 12 Jul 2011 at 11:25am |
|
whileprintingrecords;
shared stringvar X:= X + (if previous({table.field}) = {table.field} then "" else {table.field} + " ")
|
|
IP Logged |
|
KevV
Senior Member
Joined: 19 May 2011
Online Status: Offline
Posts: 106
|
Posted: 12 Jul 2011 at 11:36am |
Where does that formula go?
Thanks
KevV
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 12 Jul 2011 at 11:37am |
|
replaces the details formula from earlier
|
|
IP Logged |
|
KevV
Senior Member
Joined: 19 May 2011
Online Status: Offline
Posts: 106
|
Posted: 12 Jul 2011 at 11:40am |
Thats what i thought but it didn't do anything. I then tried replcing the footer formula and it took the last one away even if there were three or more.
Thanks
KevV
|
|
IP Logged |
|
KevV
Senior Member
Joined: 19 May 2011
Online Status: Offline
Posts: 106
|
Posted: 12 Jul 2011 at 11:43am |
Not sure what I had in there but I tried it from scratch again and it worked. Thanks for the help.
KevV
|
|
IP Logged |
|
KevV
Senior Member
Joined: 19 May 2011
Online Status: Offline
Posts: 106
|
Posted: 13 Jul 2011 at 9:34am |
Is there any way to sort the stores depending on a value in another field in the database?
Thanks
KevV
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
Posted: 13 Jul 2011 at 9:50am |
maybe but keep in mind that the group sort supercededs other sorts
TOP N might be something...
what is your requirement and what data is needed for it?
|
|
IP Logged |
|
|
|
