Baanboard.com

Go Back   Baanboard.com > Forum > Baan Quick Support: Functional & Technical > Tools Development

User login

Frontpage Sponsor

Main

Google search


Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
17%
200 - 500 GB
25%
500 - 800 GB
3%
800 - 1200 GB
11%
1200 - 1500 GB
11%
1500 - 2000 GB
14%
> 2000 GB
19%
Total votes: 36

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 21st April 2018, 03:45
francis's Avatar
francis francis is offline
Junior Member
 
Join Date: Jan 2003
Location: Toronto, Canada
Posts: 10
francis is on a distinguished road
Baan: Baan IVc4 & Baan V - DB: Oracle/Informix/MSSQL - OS: UNIX/Windows
Need help in report print expression
Baan: Baan IVc4
C/S: Client

First time that I come across this type of print expression and print condition for a report field. The print expression is for determining and printing the percentage result of the 2 aggregations (total), whereas the print condition is the aggregation of one of the 2 columns. The 'total' seems to me is a Baan internal variable as it is used in here but not declared anywhere in the report. The number after " total.." seems to be using to address the aggregation of the specific column.
Attached Images
File Type: jpg BaaN.jpg (37.4 KB, 17 views)
Reply With Quote
  #2  
Old 21st April 2018, 11:22
bdittmar's Avatar
bdittmar bdittmar is offline
Guru
 
Join Date: Apr 2002
Location: Germany, 50.584097,8.544078
Posts: 1,734
bdittmar will become famous soon enough
Baan: 2.2/3.1/4c4/LN6.1 FP6/FP9/HiDox - DB: tbase, ms-sql7, oracle10gV1, 11g - OS: HP-UX, W2K3, SLES
total.. is based on the agregate function of field

Hello,
i'll try to explain :

Your example says ;
use field total..20 / total..19 * 100 only when total..19 is not zero.

The total.. fields are maintained in order of using the aggregate function TOTAL in a report field.
The total.. fields must not be in order of reportfields.

Example:

Report with 3 after.. layouts.
In 1st layout you use the aggregate function on 1st and 5th field, so totall..1 and total..2 ist used. After this you set the aggregate on 3rd field in this layout, total..3 is used.

Regards
__________________
//Bernd
Reply With Quote
Sponsored Links
  #3  
Old 21st April 2018, 16:27
francis's Avatar
francis francis is offline
Junior Member
 
Join Date: Jan 2003
Location: Toronto, Canada
Posts: 10
francis is on a distinguished road
Baan: Baan IVc4 & Baan V - DB: Oracle/Informix/MSSQL - OS: UNIX/Windows
bdittmar, thank you. got it.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Invoices printing issue-display last record with 2 lines tracylee Tools Development 7 20th October 2017 11:51
print 2nd report from 1st report script cmandal Tools Development 6 15th October 2012 00:56
Print expression meaning in report fields pjohns Tools Development 3 25th March 2009 16:31
solving recursion problems rmarles Tools Development 2 25th January 2005 22:23


All times are GMT +2. The time now is 12:55.


©2001-2018 - Baanboard.com - Baanforums.com