One thing I do is try to look at the data in table in the order that I want the report to show. If it shows okay then the report should be okay.
Another thing you may want to consider is add an additional break for the name or duty which will group the data. Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 From: [email protected] [mailto:[email protected]] On Behalf Of Jay Ward Sent: Saturday, February 13, 2010 10:07 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Report Issue Yes, I am. It's an order by the date. The variables are being filled randomly as the three names come through in no set order. From: [email protected] [mailto:[email protected]] On Behalf Of Steve Vellella Sent: Saturday, February 13, 2010 11:31 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Report Issue Are you using an "order by" clause in the print command? Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 From: [email protected] [mailto:[email protected]] On Behalf Of Jay Ward Sent: Saturday, February 13, 2010 9:21 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Report Issue Thanks, Steve, but that is set that way. This project should have been a five minute one that has me going for way too long. There's just something simple that I can't comprehend. Jay From: [email protected] [mailto:[email protected]] On Behalf Of Steve Vellella Sent: Saturday, February 13, 2010 10:56 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Report Issue Under Reports, Breaks, Make sure your are using "reset variables" for the break - not the "reset variable" for the "on page break" . There is a "clear variables after printing" checkbox with the variable definitions, but that is not what you need. Steve Steve Vellella Office: 520-498-2256 Cell: 520-250-6498 From: [email protected] [mailto:[email protected]] On Behalf Of Jay Ward Sent: Saturday, February 13, 2010 7:46 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Report Issue Thanks, Dan. The printed line is set for the footer of the break and so are the variables. Still doesn't work. Jay From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Friday, February 12, 2010 5:59 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Report Issue If the duty variables are in the break section of the report make sure the calculate in same break section. Go into variables-add/edit variables and see where they are calculating. Dan Goldberg _____ From: [email protected] [mailto:[email protected]] On Behalf Of Jay Ward Sent: Friday, February 12, 2010 12: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
