Hi all, I am OK with most Crystal function but for the life of me I can't work out how to do the below task.
I have a report that is drawing from two tables from an ODBC connection.
Table 1
Asset No;Desciption;Cost
01;fridge;$1000
02;table;$500
03;chairs;$200
Table 2
Asset No;Line No;Text
01;0.5;fridge bought for employee smoko room
01;1.0;purchased from local supplier
03;1.0;chairs for employee lunch room
03;2.0;wooden back with cloth seats
03;3.0;purchased from interstate distributor
I want the resultant data to be displayed on one line in my report with all lines of text relating to each item (either all text items concatenated in one field or seperate fields)
Report
Asset No;Desciption;Cost;Text;Text;Text
01;Fridge;$1000;fridge bought for employee smoko room;purchased from local supplier
02;table;$500
03;chairs;$200;chairs for employee lunch room;wooden back with cloth seats;purchased from interstate distributor
Does anyone know how I can achieve this goal?
IP Logged
