Hi all,

A while already im trying to find a formula for an export.
Im not entirely new, but i am pretty unexperienced with this.
I know and learned how to make my reorts and exports.
Most of the time i make exports of added data, simply in .xls or .csv. Often there is no need to create a graphical, as the data is the important thing.
Unfortunatly one of my exports doesnt seem to work in any way.
I've searched the internet some time, to figure out how to do this, but i just cant seem to find the answer.
From a GUI someone fills in customer personal data. This data is then connected through 1 resultcode, to two products.
This 1 resultcode, is needed to generate 2 identical records (customerdata) with 3 differences in the values per record (total 6 for 2 records per customer)
Yet i can't get the second record to be created, let alone fill in the correct data. Right now i create the second record by hand, but it is getting more and more difficult as the number of records are increasing.
Therefore my question is:
How can i create a second record, containing the same data as the first record, but with 3 different values per record.
For instance:
name;street;number;city;product;delivery;price
mw. jackson; mainstreet;2567;Essex;Product X;2 weeks;$20,78
mw. jackson; mainstreet;2567;Essex;Product Y;1 weeks;$26,92

The product, delivery and price are triggert bij a resultcode like "06"

Does anybody know how to get CR to do this?

Unfortunatly the value is in 1 table. We register only ones the customer data. We only offer a couple of products were the customer picks 1 or 2 products from.


Edited by Alwin1973 - 25 Jul 2011 at 10:35am