Crystal Reports Vertical and horizontal Database field

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: Vertical and horizontal Database field

Post Reply

Post New Topic

Author	Message
BWorn Newbie Joined: 06 May 2011 Online Status: Offline Posts: 2	Topic: Vertical and horizontal Database field Posted: 06 May 2011 at 10:41am
	Hi guys, so when you put a database field on the reports it prints vertically or horizontally, but i want to print them like this. Product1 Product2 Product3 Product4 Product5 how could i do this? Thank You Edited by BWorn - 06 May 2011 at 11:42am
	IP Logged


SDdev Newbie Joined: 02 Mar 2011 Online Status: Offline Posts: 3	Posted: 06 May 2011 at 11:23am
	Hi, a little more information? Are these products related in any way, or are you indicating that you just want product lists to wrap to new columns?
	IP Logged

BWorn Newbie Joined: 06 May 2011 Online Status: Offline Posts: 2	Posted: 06 May 2011 at 11:41am
	Yes, those products are in a column called products in my database. So when i put that database field called product on my report, Crystal Reports will repeat the details section for each product, but i need it to print product1 and product2 without repeat the details secction and then repeat the details section for product 3 and 4. Normally: Product1 Product2 Product3 Product4 Product5 I need: Product1 Product2 Product3 Product4 Product5
	IP Logged

yggdrasil Senior Member Joined: 19 Jun 2007 Location: United Kingdom Online Status: Offline Posts: 150	Posted: 11 May 2011 at 12:33am
	I think I suggested something like this elsewhere recently. I'd use a counter to determine which detail line I was on , and then a variable to store the value I wanted to move down. (ie Product 1 or 3) Which I could then display on a line somewhere below. This is easy when you can put your details in a group and move all the values to the group footer, but may need a bit of manipulation to get the pattern you want. And you have to be careful about resetting variables back to '' in the right place.
	IP Logged

delstar Newbie Joined: 11 Jun 2009 Online Status: Offline Posts: 26	Posted: 17 May 2011 at 11:09am
	In the Section Expert, there is a Format with Multiple Columns option on the Details section. Check that box, then move over to the Layout tab that appears. Set the width for 1/2 of your pagewidth, click OK, and you should be done. There is also a Format Groups with Multiple Columns on the layout tab that you may want to play with.
	IP Logged

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