Aug 27, 2001 #1 stevesd Technical User Dec 26, 2000 74 US Does anyone know how to make line numbers appear before each line of detail for a CR8 report? It seems simple but not obvious how to do it. Thanks.
Does anyone know how to make line numbers appear before each line of detail for a CR8 report? It seems simple but not obvious how to do it. Thanks.
Aug 27, 2001 1 #2 John43 IS-IT--Management Apr 6, 2001 78 US Try recordnumber from special fields Upvote 0 Downvote
Aug 27, 2001 Thread starter #3 stevesd Technical User Dec 26, 2000 74 US Thanks, man. I just slapped my forehead! I will sure try. Upvote 0 Downvote
Aug 27, 2001 #4 Ngolem Programmer Aug 23, 2001 2,724 CA Using Recordnumber will only work if all records are used (ie...there is no further filtering in a record select) Another method is to put a small formula called LineCount in the detail line >********************** start ***************< numbervar linecounter; // remove this if an initializing formula is used. if OnFirstRecord then linecounter := 0; linecounter := linecounter + 1 linecounter; >********************** end ***************< this will increment and display linenumber you can get fancy and set lincounter to zero at the start of each group to get a line count within each group with an initializing formula Jim Upvote 0 Downvote
Using Recordnumber will only work if all records are used (ie...there is no further filtering in a record select) Another method is to put a small formula called LineCount in the detail line >********************** start ***************< numbervar linecounter; // remove this if an initializing formula is used. if OnFirstRecord then linecounter := 0; linecounter := linecounter + 1 linecounter; >********************** end ***************< this will increment and display linenumber you can get fancy and set lincounter to zero at the start of each group to get a line count within each group with an initializing formula Jim