Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: grouping records ? Post Reply Post New Topic
Author Message
AdamField
Groupie
Groupie


Joined: 04 Jun 2009
Online Status: Offline
Posts: 88
Quote AdamField Replybullet Topic: grouping records ?
    Posted: 29 Jun 2011 at 4:27am
Hi all,
I'm trying to combine multiple records into 1 but i'm not even sure if what i want is possible.
First what i have to work with comes from my ERP pack and as you can see they split the order info over 2 records
first record has the info of the article (aka the number / discription / amount ordered  and price and line info)
This last one gives info about what kind of record is it. article info = 0  / reservation info = 48 / blank line or general info = 31 (always on the bottom of the dbf).
 
Here is a example
 
ArticleDiscriptionOrdered

Price

 Total Price

 record info

4687MS windows 7 Home Premium 64bit SP1190900
Reserved : 148
6832Samsung SyncMaster 21.5 S22A300B 11581580
Reserved : 148
4872Samsung SH-S222AB DVDRW Black420800
Reserved : 048
31
Totaal Recupel40131
Totaal Bebat10031
 
 
Now in the print towards the customer this means it's split over diferent lines on there paper and i would like to make it into 1 line.
It happens more then ones that becouse of this 2 lines per article i have to print 2 pages in stead of 1 and more important it happens A LOT that customers come into the shop and didn't read it very well and come pick up there goods when there not in stock yet ...
 
So i'm trying to make somthing that combines line 1 and line 2 into 1 line in the Crystal report itself and make somthing like this
 
Article |  Discription | ordered |  reserved |  price | total price
4687       windows        1                 1         90            90
6832        22A300         1                1          159       159
4872        dvdrw           4                0           20           80
 
is there a easy way to combine the lines as long as the record info is 0 and 48.
I know i could try to work with variables on record info and copy then to record info 48 and then block the printing of record info 0 but i'm hoping there is another way.
 
Tnx for the feedback already
 
Adam
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Jun 2011 at 4:42am
not exactly sure I understand what you want but inital thought would be use a Detail A and B and underlay A
IP IP Logged
AdamField
Groupie
Groupie


Joined: 04 Jun 2009
Online Status: Offline
Posts: 88
Quote AdamField Replybullet Posted: 29 Jun 2011 at 4:57am
Hi DBlank,

what i mean is that for crystal report the first record the one is with the windows information
the second record is the one with the reserved information

now i want to combine those 2 records into 1 line on the crystal report in stead of the 2 lines i get now

the layout what i get now is almost identical as what i posted in the example.
a combination of those 2 would save me a lot of room and would make it more clear to the customers.

what do you mean with the underlay A ?

Greetings
Adam
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Jun 2011 at 5:05am
I got the design but wa a little unclear of the raw data set up but try this...
create details a with the lay out you want leaving the reserved section empty
create details b with only the reserve information in the space that is blank from details a
in the section expert select details a and mark 'Underly following sections' as true
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Jun 2011 at 5:06am
also in the section expert select Details and make sure keep together is TRUE
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.029 seconds.