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