There's nothing in your variable defintions that said "look at this row". Unless you put a lookup variable there in the definition, or a where clause in the expression, the report expression is always going to go out there and grab the first row in the table it finds. The variables that I list force the expression to look up that table based on a value in the current row. That's the part you were missing. Yes, the report is always reading your table (I'm assuming that's what you mean by "file"?) in sequence, but the report expressions are evaluated independently and don't necessarily look at the current row of data unless you construct your expression to tell it to. By setting the vDuty variable below, you're pulling in a piece of information from that row of data, now the expression can use that value.
Karen > Thanks, Karen. I will try it. I had in my mind that when you sequence a > file it will be read in that sequence and, if you did that between two > breaks, there would be three things to look at and each would go to one slot. > > I'm too far back in the punched card world in my mind still. Jay > > > > From: [email protected] [mailto:[email protected]] On Behalf Of > [email protected] > Sent: Sunday, February 14, 2010 2:35 PM > To: RBASE-L Mailing List > Subject: [RBASE-L] - Re: Report Issue > > > > > I see from the other emails that you found a solution. But I hope you > understand why the 3 variables you have below will ALWAYS give you the same > value for every row in your report. Your first variable basically says > "give me the FullN value in Try2 for the first row you find with a dutyname > that contains 'chair". That will always return the first row it finds where > dutyname contains 'chair'. Your variation definition doesn't look at > anything in the current row at all. > > If you're looking at the duty in the current row, determining what it is, > and then looking it up, I would think this would work: > > vDuty Duty > vChairman fulln in try2 where dutyname contains 'chair' > chair (IFEQ(.vDuty,'Chair',.vChairman, ' ')) > > > > Karen > > >
