Seal Report Forum
»
Report Edition
»
Reports
»
Using output field to calculate other output columns
Rank: Newbie
Groups: Registered
Joined: 7/8/2015(UTC) Posts: 3  Thanks: 1 times
|
Hi,
I need to compute the percentage of margins in a report that aggregate, in many ways, the detailed rows of sales documents.
How can I compute the % of margin in a correct way?
It shuld be nice use the aggregate field of the output... but any suggestion is welcome.
Many thanks in advance,
Beppe
|
|
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 12/20/2013(UTC) Posts: 1,209  Thanks: 14 times
Was thanked: 206 time(s) in 199 post(s)
|
Did you have a look at the new feature in 1.8 ?
Cell Script:
Custom scripts can be defined on a report element to process values after the Summary, Page and Data tables have been built in the model.
These scripts can be used to customize cell display and values or to perform complex calculations.
Check sample: 50-Cell Script - Progression and running totals
or also
Model Scripts:
For SQL Data Source, a 'Pre Load Script' can be defined in the model to modify the model before the database load and a 'Post Load Script' can be defined in the model to modify the result table after the database load.
Finally, a 'Final Script' is available to modify the model after the complete load.
Check samples: 43-SQL Source with XML Google API
You have to understand the models and to write some C#, but it might be very powerful..
|
 1 user thanked epf for this useful post.
|
|
|
|
Seal Report Forum
»
Report Edition
»
Reports
»
Using output field to calculate other output columns
Forum Jump
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.
