Glad I was able to help. Looked like an interesting idea so I had to play with it.
-----Original Message----- From: James Bentley <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 4 Nov 2010 10:02:11 -0700 (PDT) Subject: [RBASE-L] - Re: Report Breaks in v9.x Thanks to Jan I have resolved my problems with this. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 From: "Wills, Steve" <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Thu, November 4, 2010 8:47:38 AM Subject: [RBASE-L] - Re: Report Breaks in v9.x Jim, you've probably already checked on this and I think someone mentioned it, but, is the variable associated with the appropriate Header/Footer (Hn/Fn)? I know I've stymied myself more than once when I've made changes to a report and failed to check in which section a break variable was being evaluated. Steve in Memphis From: [email protected] [mailto:[email protected]] On Behalf Of James Bentley Sent: Wednesday, November 03, 2010 10:10pm 22:10 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Breaks in v9.x Jan, Thanks. I received the report and will try it out on Thursday morning. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 From: jan johansen <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, November 3, 2010 1:45:09 PM Subject: [RBASE-L] - Re: Report Breaks in v9.x Ok, I will send you a private email with a report to run in the sample database. Should give you some help in setting up your report. Jan -----Original Message----- From: James Bentley <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 3 Nov 2010 11:34:49 -0700 (PDT) Subject: [RBASE-L] - Re: Report Breaks in v9.x Jan, Yes I do. Any help you can give will be appreciated. Note. I will be unavailable for the next five hours as I am off to class and won't return until after six. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 From: jan johansen <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, November 3, 2010 12:42:44 PM Subject: [RBASE-L] - Re: Report Breaks in v9.x James, I was able to create a report that does what you want. Do you have access to the sample RRBYW16? Jan -----Original Message----- From: James Bentley <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 3 Nov 2010 08:51:47 -0700 (PDT) Subject: [RBASE-L] - Re: Report Breaks in v9.x Karen, The first column is the member number (integer) which is a Primary Key for that table. As printed that value is actually a TEXT value as later on in the printout I have items with a suffix attached to a number. There is no way using primary to determine a break. You have to use a counter hence the vCount variable and the vBreak variable. the vbreak variable will contain either a 0 or 1 with the 1 indicating a break. Jim Bentley American Celiac Society [email protected] tel: 1-504-737-3293 From: "[email protected]" <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, November 3, 2010 10:44:51 AM Subject: [RBASE-L] - Re: Report Breaks in v9.x Jim: What is printed in the first column? Is that vCount? Locate vBreak on there too to see if it gives you any idea. Also make sure you are not printing the report with an "order by" clause or else that will totally trump your vBreak break column. Perhaps older versions were more forgiving of that. Karen You will notice it prints six names, skips a line, one name, skips a line, six names skips a line, one name, skips a line etc.
