Print Page | Close Window

joining rows with columns

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12318
Printed Date: 03 May 2025 at 4:34pm


Topic: joining rows with columns
Posted By: denhors
Subject: joining rows with columns
Date 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


Replies:
Posted By: lockwelle
Date 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


Print Page | Close Window