Jim, you got me a lot closer. Different names appeared for the first time but the 'ifeq' approach requires a response when it isn't equal so it creates in your example a 0. Since you are evaluating one line of detail at a time then the last name for the date is correctly placed but the others are 0. If you could say "do nothing" instead of "0" it would work. That I don't know how to do. Thanks. Jay
From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Sunday, February 14, 2010 8:54 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Report Issue Jay, You may have found the answer to your problem but if not, maybe this will help. I have been reading the list on this subject. I do not usually give my 2 cents because I am a novice compared to those on the list. If I understand your table structure, I would think three IFEQ variables should do the trick. I have a similar report I use for the type of sales our company makes. If your table column names are DATE, NAME, & DUTY then set your variables as such: Vmchair = (IFEQ(duty,'Meeting Chairman',name,'0')) Vdlead = (IFEQ(duty,'Discussion Leade'r,name,'0')) Vessay = (IFEQ(duty,'Essayist',name,'0')) Your four columns on the report would be as such: Date Chairman Leader Essayist Col var Vmchair vdlead vessay You would have one line per date with each col filled in with the proper name. That should do the trick. I still use 7.6 so Version 9 may be different. Jim _____ From: [email protected] [mailto:[email protected]] On Behalf Of Jay Ward Sent: Friday, February 12, 2010 2:36 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Report Issue I am trying to print a report from a file. File basically has three columns: date, name and duty. Duty can be one of three. I am attempting to print a report with four columns. Date and then the individual's name who performed the duty in the appropriate column. I have set up three variables. One for each of the duties. I have attempted to set the variables with the name of the person who performed the duty. In the file all three duties are described in the single column. The report is set to break on the date. I have no lines in the detail section, only in the break follower since I believe the variables will be propagated by the three rows that are read. I have the clear variable setting to clear after each break. I get the appropriate break on date but the three "duty" columns show the same name throughout the report. I get the correct dates shown for the years covered by the report. I've got to be doing something dumb but I can't figure it out so I would appreciate direction from an expert. I am on the current release of eXtreme9-64. Thanks. Jay Ward
