You might also try using the LISTOF function in a report variable. vListVariable = (LISTOF(columnname)) IN lookuptablename WHERE linkingcolumn = linkingcolumn
Sami ----- Original Message ----- From: Troy Sosamon To: RBASE-L Mailing List Sent: Monday, August 18, 2003 12:53 PM Subject: [RBASE-L] - RE: reports 1. Build a view between the 2 tables joining them appropriatly. 2. Make a report that runs off of that view. 3. You need a break point on your item number (4105409) - Break One 4. Go into the report and add the sections H1 and F1 for header one and footer one. 5. Locate your your item number and related fields in the H1 section of the report. 6. Locate you parts in the data section of the report. 7. Save it and run it. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of parts Sent: Monday, August 18, 2003 11:34 AM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: reports I need a verticle column with a variable amount of records to line up with a single record ie 4105409 lof 5qt oil ----- Original Message ----- From: Troy Sosamon To: RBASE-L Mailing List Sent: Monday, August 18, 2003 1:29 PM Subject: [RBASE-L] - RE: reports No you can't. You can run reports from inside of a cursor. What are you trying to do? Instead of a declare cursor inside of a report, you probably just need to base the report on a view that has that table linked to it. If you only need single row values, you can do lookups with variables in a report. Troy -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of parts Sent: Monday, August 18, 2003 10:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - reports Can I set up some sort of declare cursor inside of a report?
