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
Article |
Discription |
Ordered |
Price |
Total Price |
record info |
4687 |
MS windows 7 Home Premium 64bit SP1 |
1 |
90 |
90 |
0 |
|
Reserved : 1 |
|
|
|
48 |
6832 |
Samsung SyncMaster 21.5 S22A300B |
1 |
158 |
158 |
0 |
|
Reserved : 1 |
|
|
|
48 |
4872 |
Samsung SH-S222AB DVDRW Black |
4 |
20 |
80 |
0 |
|
Reserved : 0 |
|
|
|
48 |
|
|
|
|
|
31 |
|
Totaal Recupel |
4 |
0 |
1 |
31 |
|
Totaal Bebat |
1 |
0 |
0 |
31 |
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