Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Help with Next(Next(fld)) Post Reply Post New Topic
Author Message
Chinho
Newbie
Newbie


Joined: 31 Jan 2010
Location: Singapore
Online Status: Offline
Posts: 3
Quote Chinho Replybullet Topic: Help with Next(Next(fld))
    Posted: 30 May 2010 at 4:10pm
I have a query that extracts a list of itemcodes
 
SELECT itemcode FROM tblitem
 
I will like to display my report in a format of
 
itemcode1, itemcode2, itemcode3
itemcode4, itemcode5, itemcode6
.... and so on
 
I have used in formula
{tblitem.itemcode}, Next({tblitem.itemcode), Next(Next(tblitem.itemcode))
 
But this Next(Next(tblitem.itemcode)) throws me an error. How can I achieve to show the thrid item in the details row of the report?
 
Please help!
Much thanks!
Chinho
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 01 Jun 2010 at 2:59am
Next is as far forward as Crystal will let you go when creating formulas. You could however try to format the the rows with Multiple Columns depending on your setup. Just go into the Section Expert on Details and check 'Format with Multiple Columns'. Click the Layout tab and choose your sizes and then check the 'Across then Down' option.
|< /\ '][' ( )
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.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.