Oct 24, 2005 #1 jorg32 Programmer Joined Jul 10, 2003 Messages 57 Location BE Hi, Is it possible to let Crystel do showing on each page a maximum of eg. 25 records in the details? So yes, how to do this. thanks for helping me. J
Hi, Is it possible to let Crystel do showing on each page a maximum of eg. 25 records in the details? So yes, how to do this. thanks for helping me. J
Oct 24, 2005 #2 Naith Programmer Joined May 14, 2002 Messages 2,530 Location GB Hey there Jorg, First up, create a formula something like the following and place it, suppressed, in your details section. Code: //{@Counter} WhilePrintingRecords; NumberVar Counter := Counter + 1 In the section expert, apply a condition on the New Page After area of your Details section like: Code: Remainder({@Counter},25) = 0 Naith Upvote 0 Downvote
Hey there Jorg, First up, create a formula something like the following and place it, suppressed, in your details section. Code: //{@Counter} WhilePrintingRecords; NumberVar Counter := Counter + 1 In the section expert, apply a condition on the New Page After area of your Details section like: Code: Remainder({@Counter},25) = 0 Naith
Oct 24, 2005 #3 Madawc Programmer Joined Sep 5, 2002 Messages 7,628 Location GB You'd need a page count, and then set the detail line to begin a new page when the count is more than 25. Page counts work as follows: //In the page header, add a formula field with the following. Code: WhilePrintingRecords; NumberVar LineCount :=0; In the detail setion Code: WhilePrintingRecords; NumberVar LineCount := LineCount + 1; Right-click on a section and choose Section Expert. Then choose the formula icon (x+2 and a pencil) for New Page After. Check the count. Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10 Upvote 0 Downvote
You'd need a page count, and then set the detail line to begin a new page when the count is more than 25. Page counts work as follows: //In the page header, add a formula field with the following. Code: WhilePrintingRecords; NumberVar LineCount :=0; In the detail setion Code: WhilePrintingRecords; NumberVar LineCount := LineCount + 1; Right-click on a section and choose Section Expert. Then choose the formula icon (x+2 and a pencil) for New Page After. Check the count. Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10
Oct 24, 2005 #4 dgillz Instructor Joined Mar 2, 2001 Messages 10,059 Location US Actually no variables are needed. Format the detail section, and click on the X-2 button for new page after and enter a formula: Remainder(RecordNumber,25)=0 Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports http://www.gainfocus.biz Upvote 0 Downvote
Actually no variables are needed. Format the detail section, and click on the X-2 button for new page after and enter a formula: Remainder(RecordNumber,25)=0 Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports http://www.gainfocus.biz
Oct 24, 2005 #5 Naith Programmer Joined May 14, 2002 Messages 2,530 Location GB Of course, you're right dgillz. I clean forgot about RecordNumber. Wow, it HAS been a long time. Upvote 0 Downvote