Print Page | Close Window

Help with Next(Next(fld))

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=10137
Printed Date: 22 May 2024 at 12:35am


Topic: Help with Next(Next(fld))
Posted By: Chinho
Subject: Help with Next(Next(fld))
Date 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


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

-------------
|< /\ '][' ( )


Print Page | Close Window