Thanks for the input, Steve. The way I have been attempting to create the report doesn't show the first name for each date, it shows the same name for all dates and in all columns. I have created a table that has only three columns in it. Date, name and duty. That's it. There are generally, but not always, three data lines for each date. Sometimes there are only two. That's the entire table. Jay.
From: [email protected] [mailto:[email protected]] On Behalf Of Steve Vellella Sent: Saturday, February 13, 2010 10:56 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Issue Jay, Assuming that the date is repeated multiple times - thus the break setting - the report is only going to show you the first records data for that date. Otherwise, I would need to have more details on the data structure to help you. 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:57 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Issue Steve, I'm not certain what you mean by "link." There are three activities per date, Meeting Chairman, Essayist and Discussion Leader. Each line of the report should have just the date and each of the activities on the line. There are fifteen years of data in the database so I know what the outcome should be. There are some other fields within the "try2" table, i.e., first name, last name, title of essay, etc. From: [email protected] [mailto:[email protected]] On Behalf Of Steve Vellella Sent: Saturday, February 13, 2010 7:21 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Issue Jay, What is the link between the table the report is based on and the "try2" table - is it just the dutyname field? Does each date field in the report file have a unique dutyname associated with it? 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 3:59 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Issue I'll just type them in Karen since, as Jan pointed out, I can't send them the easy way. chair fulln in try2 where dutyname contains 'chair' essay fulln in try2 where dutyname contains 'essay' discuss fulln in try 2 where dutyname contains 'discuss' In each case fulln is the field with the name of the member. The three options represent Meeting Chairman, Discussion Leader and Essayist. I have them set calculating on the break footer which is where the three fields plus the date field is printed. I have stripped down the report to nothing but a page header for column descriptions and the break footer. All three of the variables are "accepted" by the report designer as valid. Jay From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Saturday, February 13, 2010 3:52 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Report Issue Maybe you should paste your variable definitions here? So you have a break on the date column, you have a break footer where you have the date and "3 variables", all the breaks show the same information for the 3 variables, right? Post what your variables are and maybe that'll help us understand... Karen 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.
