Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Tips and Tricks
Message Icon Topic: joining rows with columns Post Reply Post New Topic
Author Message
denhors
Newbie
Newbie
Avatar

Joined: 04 Jan 2011
Online Status: Offline
Posts: 20
Quote denhors Replybullet Topic: joining rows with columns
    Posted: 15 Feb 2011 at 12:22am
I have a problem in making report in CR, I will try to explain by example.
I have 2 tables,  table A containing user information, Table B in the first column contains the user ID and a list with numbers:
Table A
ID, name, address, city, ZIP code
01, John, Wenche, 22 High Street, London, 55000
02, Denis, Leksovich, Nova ulica 20, Zagreb, 10000
03
:
.
Table B
01, 33.30, 4321.44, 55.61, 33.78, 44.68
02, 55.66, 21.78, 3.71, 4.9
03, ...
04
:
.
How do I get into the details of printing forms:
GH
John Wenche
High street 22
 
Details a
  33.30
  4321.44
  55.61
  33.78
  44.68
GF

Thx


Edited by denhors - 15 Feb 2011 at 12:47am
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 18 Mar 2011 at 2:58am
I realize that you have had a month, and have probably figured this out, but here is what I would try...and it is frought with dangers/provisos
 
Join the tables on the ID number, I know pretty obvious, then you can  replace the commas with CRLF and then set the result to the object, which has can grow set on.  You can't do any aggregates on this, and it won't necessarily line up nicely but it would give a report like in the example.
 
HTH
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.