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. >>>>>> >>>>> >>> >
