Data Report Designer Avg Problems 
Author Message
 Data Report Designer Avg Problems

Hey all...

I've been having some problems with using the average summary textbox
in the Data Report Designer (VB6 SP4) with an MS Access Data Tier.

In the same group footer, I will try to calculate three averages for
three separte lists of figures in the detail section. All figures in
the detail and group footer should be rounded to two digits (i.e. I
formatted the textbox to be a number displaying two decimal places).

It seems to work just peachy for the text boxes that get their values
from a field in Single number format, but when it tries to pull values
from a field in a Byte number format, the rounding precision drops down
to one place (ex. 4.66667 becomes 4.70 instead of 4.67). I even tried
to change the data format at the table-level to Single and Double and
still no effect.

I am using a middle-tier object to retrieve the data and shape it into
an ADO Hierarchical Recordset and pass that recordset back to the front
end, where it becomes the data source for the report (directly bound,
no Data Environment).

Any ideas on why this is happening?


Tom. (TTFMC)

Sent via http://www.*-*-*.com/
Before you buy.

Wed, 18 Jun 1902 08:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Data Report Designer and Data Environment Problem

2. Data Designer and a Report Designer.

3. Data Report Designer - Printing Problem

4. VB6 Data Report Designer - problems exporting to HTML

5. Data Report Designer Problems

6. Data Report Designer Problem

7. Data Report Designer - Sub Reports

8. Crystal Report vs MS Data Report Designer

9. Ole data in Access database to retrieve in report ( Report Designer 6 + VB 6 )

10. Microsoft Data Report Designer or Crystal Reports

11. Crystal Reports and the New Data report Designer

12. data report / data environment designers


Powered by phpBB® Forum Software