reusing report output

[suris]

Guys,

How to display the computed value of one report to another report.

For example

Emp number and salary are displayed in Report1. The maximum salary of the report1 has to be displayed on report2. I created a variable for the maximum salary and when I tried to display the same on report2, I am getting sum of salaries of all employees rather than the maximum salary.

Any valuable suggestion is highly appreciated.

Regards,
suris

 

[promero]

You must use the variable with a proper context. Example:
<Employee> <Salary>
A 100
B 200
C 300

Supose <Salary> has Sum as the agregate function:

=Max(<Salary>) In Report
returns 600

=Max(<Salary> ForEach <Employee>) In Report
returns 300

Have a look to the use of Contexts into BO expression, in the BO User Manual.

 

[suris]

Hi,

It works and thanks a lot.

Regards,
suris