Question first: ?? We have a sparce populated table with large number of columns(like 200 or so). ? ?This table will always have just one record in it. (there is another table that actually stores data).
?? Now I am designing report that should roughly look like to entry form for that table. 1) Can I automatically convert a form to a report ? 2) When printing report is there a way not to print columns and their LABELS(headings) when there is no data in the column. ???? For example: Criteria:????????? Importance??? Design Soulution. ====================================== ??? Flexibility:? ? Important.????? Modular type. ??? Durability:???????? ??? Age Group.? Importants.?? ?Older Adults. Suppose? columns FlexImp,FlexDsgnSolution,AgeGroupImp,AgeGroupDesignSolution? have data in them but?? DurabilityImp? and DurabilityDesignSolution are empty(not filled by user). ? Is there a way (in the report to skip the Label and DBText for column DurabilityImp and DurabilityDesignSolution so it looks like this: Criteria:????????? Importance??? Design Soulution. ====================================== ??? Flexibility:? ? Important.????? Modular type.???? ??? Age Group.? Importants.?? ?Older Adults. So here is the question, the "contribution" folows in next post. BT, KCK. www.LinuxCAD.com -----Original Message----- From: A. Razzak Memon <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Tue, Jun 30, 2009 6:31 am Subject: [RBASE-L] - Re: Sort a slave table in a form At 02:23 AM 6/30/2009, R:Daniele wrote:? ? >How can I sort a slave table (scrolling region in a FORM)? >by colname1 when colname1 is not a commun column?? ? Daniele,? ? If you have a form with slave tables and a report with? sub-reports, and if you wish to sort the matching rows? related to slave table(s)/sub-report(s), you'll need to? use the ARRANGE BY clause to achieve your goal.? ? ARRANGE tablename BY columnlist sorts the rows displayed? by a form's or report's lower-level tables. Each lower-level? table in the form or report that you want to sort requires? its own ARRANGE clause. You can specify up to twenty-five? tables to ARRANGE and up to five columns in each table on? which R:BASE will sort.? ? -- Example 01:? ? Database: RRBYW15? Sample Form: SalesTransactions? Associated Tables (5):? . Customer (Master)? . InvoiceHeader (Slave 1)? . InvoiceDetail (Slave 2)? . Employee (Slave 3)? . Contact (Slave 4)? ? Command:? ? -- Begin? EDIT USING SalesTransactions +? ARRANGE InvoiceHeader BY TransID, +? ARRANGE InvoiceDetail BY ItemNum, +? ARRANGE Employee BY EmpLName,EmpFName +? ARRANGE Contact BY ContLName,ContFName +? ORDER BY Company WHERE CustState = 'PA'? RETURN? -- End? ? -- Example 02:? ? Database: RRBYW15? Sample Report with Sub-Report: CustomerContacts? Associated Tables (2):? . Customer (Master)? . Contact (Slave 1)? ? Command:? -- Begin? PRINT CustomerContacts +? ARRANGE Contact BY ContLName,ContFName +? ORDER BY Company WHERE CustState = 'PA' +? OPTION SCREEN|WINDOW_STATE MAXIMIZED +? |ZOOM_TYPE PERCENTAGE|ZOOMPERCENT 90? RETURN? -- End? ? Very Best R:egards,? ? Razzak.? ?
