main logo
Subject: Re: Report Question using ROUND() on Calculated Fields
Author: "Andy Davies"
Posted: 2003/10/31 07:54:00
 
View Entire Thread
New Search


SELECT 1.2345 FROM browser && some table that happens to have e.g. three
records
CREATE REPORT trpt from query
MODIFY repo trpt
* add a summary band, set 'calculate' to 'sum', and change expression
'expr_1' to 'round(expr_1,0)'
REPORT FORM trpt
* expr_1
* 1.2345
* 1.2345
* 1.2345
* 3

Are you using form variables? (recommendation - don't)
I suggest you try re-building the report

AndyD 8-)#







 
©2003 Andy Davies
<-- Prior Message New Search Next Message -->