|
View previous topic :: View next topic
|
| Author |
Message |
tapas84
New User
Joined: 12 Mar 2009
Posts: 23
Location: Bangalore
|
|
|
|
Hi Bill,
Thanks for catching my mistake. I changed it to POS and it worked.
Thanks again.
But I have a issue at the end of the report.
| Code: |
SUMMARY TOTAL ; 529.560; 1,156 ; 558.59 ;
PRODUCT TOTAL ; 529.560; 1,156 ; 558.59 ;
POLICY TOTAL ; 770.260; 1,329 ; 797.13 ;
862.250 1,507 886.41
|
But Bill I want my last line to be printed like
| Code: |
SUMMARY TOTAL ; 529.560; 1,156 ; 558.59 ;
PRODUCT TOTAL ; 529.560; 1,156 ; 558.59 ;
POLICY TOTAL ; 770.260; 1,329 ; 797.13 ;
FINAL TOTAL ; 862.250; 1,507 ; 886.41 ;
|
I want to print FINAL TOTAL and semi colon in my last line.
Please advise |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Add another test for LEVEL EQ 4, should get the FINAL |
|
| Back to top |
|
|
tapas84
New User
Joined: 12 Mar 2009
Posts: 23
Location: Bangalore
|
|
|
|
Hi Bill ,
I put condition for LEVEL 4 , and I am getting the report like
| Code: |
REPORT
UMMARY TOTAL ; 529.560; 1,156 ; 558.59 ;
PRODUCT TOTAL ; 529.560; 1,156 ; 558.59 ;
POLICY TOTAL ; 770.260; 1,329 ; 797.13 ;
FINAL TOTAL ; 862.250; 1,507 ; 886.41 ;
862.250 1,507 886.41
|
Here I am writing FINAL TOTAL 2 times and POLICY TOTAL amount is overridden by FINAL TOTAL data.
LEVEL 4 is not working for my case.
Please advise. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| On your CONTROL statement, you have to include FINAL NOPRINT when you don't want the print. So CONTROL FINAL NOPRINT POLICY NOPRINT etc, still nicely formatted. |
|
| Back to top |
|
|
tapas84
New User
Joined: 12 Mar 2009
Posts: 23
Location: Bangalore
|
|
|
|
Hi Bill,
Thanks a lot it worked for me and I am getting correct report.
Just for my learning , could you please explain me what is the use of POS.
I am not familiar with POS parameter and my case why my first POS is coded as POS 08
why not POS 01.
Thank you again. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Code: |
LINE 01 +
LINE-ITEM-1 +
LINE-ITEM-2 +
LINE-ITEM-3 +
LINE-ITEM-4 +
LINE-ITEM-5 +
LINE-ITEM-6 +
LINE-ITEM-AMT
|
In the above you have six line items, say names, dates, whatever, and one field which Easytrieve is going to keep a total of (by default, it will SUM anything on the LINE which has decimal places (even zero decimal places, if explicitly defined).
Now, in a report procedure, I want to put some comment and the total. I want the comment under LINE-ITEM-3 and the total under LINE-ITEM-AMT.
So, I use POS 3 (the third position on the LINE statements) and POS 7 (the seventh position).
In your program, we got up to POS 8 so quickly, because of all the delimiters. If you reduce the POS by one and run again, you'll see the totals trying to line up with a delimiter. Now you have it, practice. |
|
| Back to top |
|
|
tapas84
New User
Joined: 12 Mar 2009
Posts: 23
Location: Bangalore
|
|
|
|
| Thank you Bill. I got it. |
|
| Back to top |
|
|
|
|
