(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Derived columns (Read 1249 times)
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
Derived columns
Jun 12th, 2009 at 6:13pm
Print Post Print Post  
I am having trouble with a report using derived columns. There are 3 LE's in the report 1 text and 2 number. I defined a third number variable unbound and in on print for that LE I set that LE = LE1 - LE2. (the 2 number LE's)
Received message that some or all did not compile. The report ran displaying the 1st 3 LE's.
Without the defined LE the report ran without the compile message.
I thought I followed the example from Inside Sesame that was published some time ago. January 2007.
What have I missed?

Harley
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Derived columns
Reply #1 - Jun 12th, 2009 at 6:25pm
Print Post Print Post  
When you run Test in the Programming Editor, what does the error message say?
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
Re: Derived columns
Reply #2 - Jun 12th, 2009 at 6:32pm
Print Post Print Post  
Running test does not give any results.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Derived columns
Reply #3 - Jun 12th, 2009 at 6:47pm
Print Post Print Post  
pineberry wrote on Jun 12th, 2009 at 6:32pm:
Running test does not give any results.


If the report gives a compile error when it runs, the Test Program should show an error in the bottom portion of the Programming Editor when you click the Test menu and choose Test Program.
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Re: Derived columns
Reply #4 - Jun 13th, 2009 at 12:33am
Print Post Print Post  
Make sure the derived column is a number field also  Wink
  
Back to top
 
IP Logged
 
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
Re: Derived columns
Reply #5 - Jun 13th, 2009 at 2:30am
Print Post Print Post  
The derived column is a number field. There were no error messages when test was run. The problem was one of the number fields had a space. The field name is On Hand and even though it prints OK it doesn't like arithmetic.
Thanks for the responses.
Harley
  
Back to top
 
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge