How to output two columns from separate data rows
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=5826
Printed Date: 08 May 2024 at 7:49am
Topic: How to output two columns from separate data rows
Posted By: mattlscc
Subject: How to output two columns from separate data rows
Date Posted: 19 Mar 2009 at 10:07am
So, I was wanting to save space and put two columns of data on the same row in Crystal Reports... only problem is the data comes back from the Query on separate rows. This seems to be a problem in and of itself.
The other problem is one column could have more rows of data than they other... so blank would just be in the shorter column where the longer column had more rows....
Anyhow, this report is still just in basic design phase and I'm trying to figure out if it can be done. Thanks!
|
Replies:
Posted By: themessenger
Date Posted: 07 Apr 2009 at 3:17am
If you create a group, then split the group's header (giving you group header A and group header B).
In group header A in the section expert - exclude all of group B items and vice versa.
Now, if you overlay group header B over group header A and providing that you have offset the columns accordingly then you should have the two columns side by side.
Regards,
Hem
-------------
Managing Director
www.allmymenus.com
|
|