Sum in page header & problem with casting

[2001 JI Open Discussion]

By: Yen Yee Chin - cyy

Sum in page header & problem with casting

2002-11-25 19:49

Hi,

 

i have 2 questions here.

 

1. At the first line of my report Page Header, i have a variable called 'Total Amount' that will display the sum of a field named 'Amount'. In my report Details, i will display all the Amount values. When i view the first page of the report, i get a null value for Total Amount. How do I get the sum of Amount and display it in Total Amount in the Page Header?

 

 

2. How do i cast a double value from the database into a integer?