Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: 1 value input, two records output Post Reply Post New Topic
Author Message
Alwin1973
Newbie
Newbie


Joined: 13 Jul 2011
Online Status: Offline
Posts: 4
Quote Alwin1973 Replybullet Topic: 1 value input, two records output
    Posted: 24 Jul 2011 at 11:14am
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?
IP IP Logged
sharona
Senior Member
Senior Member
Avatar

Joined: 16 Oct 2008
Location: United States
Online Status: Offline
Posts: 255
Quote sharona Replybullet Posted: 25 Jul 2011 at 2:56am

are the in seperate tables?

make sure you have a left outer join between the tables
create a group by result code
then place the product field in the details. it should display the 2 values
sharona
IP IP Logged
Alwin1973
Newbie
Newbie


Joined: 13 Jul 2011
Online Status: Offline
Posts: 4
Quote Alwin1973 Replybullet Posted: 25 Jul 2011 at 10:34am
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
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.031 seconds.