Overflow while converting variant of type (int64) into type (Currency)
Hello,
I am using Delphi 6 with ReportBuilder 10.04.
I have a report when run from 1/1/06 to 6/21/06 or greater causes the error
'Overflow while converting variant of type (int64) into type (Currency)'.
The first page will appear, but if I try to scroll onto the next page (or
last page) the error occurs.
I have checked the field lengths of my data and I have plenty of space. I
also get a different error 'invalid floating point operation' when I run the
report from 1/20/06 to 6/30/06 but no error if I run the report 1/11/06 to
6/30/06.
There are no totals on the report which requires an additional digit if I
break down the report and run it in two sections and manually total the
figures.
Thank you,
Matthew Tilles
I am using Delphi 6 with ReportBuilder 10.04.
I have a report when run from 1/1/06 to 6/21/06 or greater causes the error
'Overflow while converting variant of type (int64) into type (Currency)'.
The first page will appear, but if I try to scroll onto the next page (or
last page) the error occurs.
I have checked the field lengths of my data and I have plenty of space. I
also get a different error 'invalid floating point operation' when I run the
report from 1/20/06 to 6/30/06 but no error if I run the report 1/11/06 to
6/30/06.
There are no totals on the report which requires an additional digit if I
break down the report and run it in two sections and manually total the
figures.
Thank you,
Matthew Tilles
This discussion has been closed.
Comments
If you change your library path to \RBuilder\Source\ are you able to trace
into the ReportBuilder source where the exception occurs? I do not believe
the dates you have in your search statement will cause this error, it is
probably some data that is being accessed in addition to the dates. The
first error may be caused by a TppVariable on your report set to the wrong
data type. If possible, please create a simple example that recreates this
behavior and send it in .zip format to support@digital-metaphors.com and
I'll take a look at it for you.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com