Tom- That is a good thought, but alas no. The columns in the driving table are TICKET (Integ) LOT# (Integ) BINLOC (Text) SELLPRICE (Curr) and LINENUM (Integ).
When I get a chance (may be a while) I will try to pin down what was causing this. In the meantime, I am up and running although a little confused! I kept a copy of the old report for experimentation. Thanks again! -----Original Message----- From: Tom Grimshaw <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, May 14, 2002 8:13 PM Subject: Re: Report Oddity >G'day Bob, > >Is OrdTotal a column name as well? > >At 18:31 14/05/02 -0500, you wrote: >>Sami - >> >>Thank you for your response. My report is based upon a >>table and not a view and the field names are all less than >>10 characters. >> >>I did resolve the problem, but have no idea why it was causing >>it. I had a computed variable that added the values of (3) >>variables, it was entered as such: >> >>OrdTotal = (.VTOTAL + .VFRTCHG + .VMISCHARGE) >> >>I deleted the variable and location and the report would then >>accept the column values. I entered the variable back in and >>all the columns disappeared! I deleted the column and >>entered it back as: >> >>REPTOTAL = (.VTOTAL + .VFRTCHG + .VMISCHARGE) >> >>and everything worked fine! Go figure! I am 99.99% sure that I >>changed nothing else. For some reason it did not like the >>OrdTotal variable name. I know it sounds weird! In any case >>I am up and running! >> >>Thanks again! >> >> >> >> >>-----Original Message----- >>From: Sami Aaron <[EMAIL PROTECTED]> >>To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> >>Date: Tuesday, May 14, 2002 5:00 PM >>Subject: Re: Report Oddity >> >> >> >Bob - >> > >> >Check the view definition that the report is based upon. If the field >>names >> >are saved as "tablename.columnname" and the length of this "field name" >> >exceeds 18 characters, it will cause the fields to disappear, as you have >> >seen. If that's the case, re-define the view to use alias names, then >>place >> >those on the report. The alias names can be the same as the field names - >> >but without the table designation. >> > >> >Sami >> > >> >----------------------------------------------------------- >> >Sami Aaron >> >Software Management Specialists >> >19312 W 63rd Terr >> >Shawnee KS 66218 >> >913-915-1971 >> >http://www.softwaremgmt.com >> >----- Original Message ----- >> >From: Bob Thompson >> >To: RBase-L >> >Sent: Tuesday, May 14, 2002 3:11 PM >> >Subject: Report Oddity >> > >> > >> >Rbase 6.5++ Win. >> > >> >I have used the report generator on several reports and am fairly >> >familar with it, but have ran across a problem that is weirding me >> >out! >> > >> >I have a report that has several variable objects and a few text >> >boxes. I place column objects on the report as normal and then >> >save the report. When I print the report, the column fields do not >> >show up. I go back into the report generator and the column >> >fields are all gone. All the calculation variables work fine and display >> >when printing. So I add the column objects back and save the report >> >and immediately go back into the report generator and the columns are >> >all gone. No error messages or anything. >> > >> >I tried copying the report, and the copy acts the same. Other reports >>based >> >on the same driving table work OK. I added additional variable objects >> >and they "stay" OK. All objects work except column on this report. >> > >> >Pretty bizzare! Anyone else seen this? >> > >> > >> >================================================ >> >TO SEE MESSAGE POSTING GUIDELINES: >> >Send a plain text email to [EMAIL PROTECTED] >> >In the message body, put just two words: INTRO rbase-l >> >================================================ >> >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >> >In the message body, put just two words: UNSUBSCRIBE rbase-l >> >================================================ >> >TO SEARCH ARCHIVES: >> >http://www.mail-archive.com/rbase-l%40sonetmail.com/ >> > >> >> >>================================================ >>TO SEE MESSAGE POSTING GUIDELINES: >>Send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: INTRO rbase-l >>================================================ >>TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >>In the message body, put just two words: UNSUBSCRIBE rbase-l >>================================================ >>TO SEARCH ARCHIVES: >>http://www.mail-archive.com/rbase-l%40sonetmail.com/ > >Warmest regards, > > >Tom Grimshaw >coy: Just For You Software >tel: 612 9552 3311 >fax: 612 9566 2164 >mobile: 0414 675 903 > >post: PO Box 470 Glebe NSW 2037 Australia >street: 3/66 Wentworth Park Rd Glebe NSW 2037 > >email: [EMAIL PROTECTED] >web: www.just4usoftware.com.au > >"... the control of impulse -- is the first principle of civilization."-- >Will Durant, >Pulitzer Prize winning philosopher, writer and historian > >the most needed product in the world can be found at >www.thewaytohappiness.org > >This email and any files transmitted with it are confidential to the >intended recipient and may be privileged. If you have received this email >inadvertently or you are not the intended recipient, you may not >disseminate, distribute, copy or in any way rely on it. Further, you should >notify the sender immediately and delete the email from your computer. >Whilst we have taken precautions to alert us to the presence of computer >viruses, we cannot guarantee that this email and any files transmitted with >it are free from such viruses. > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
