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/
