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
|
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
|