Error Input string ......

[draganss]

I'm using CR built-in VS.NET 2002.

DataSource for reports is DataTable (DataSet) which is filled with SQL Procedure(SQL adapter).

I need my data to be with 6 decimal places accuracy.
That particular column in the DataTable is defined as decimal.

When my SQL procedure returns values with rounding of 4 decimals report works.
If I change rounding for more then 4 decimals I get error message:

System.ForamtException: Inpust string was not in a correct format. ...... etc ......etc

Code line when this is happening is:
oRpt.SetDataSource(dsTek)

where oRpt is ReportDocument
and dsTek is DataSet

Any ideas?

Thanx, Marin

 

[IdoMillet]

Try Database, Verify Database... against the new format data set.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[draganss]

Already did it.
Doesn't work.

Marin

 

[synapsevampire]

Sounds odd...

As a workaround, pass it as a string from the SP and then use a VAL({table.field}) as a formula in Crystal to make references to the value within the report.

-k

 

[draganss]

Thank you SV.

Within stored procedure I've multiplied the values by 100 with rounding of 4 decimal places and then within the report I've created formula which divides values with 100.
Workaround is easy.

I was looking for an answer why is this happening?
I'm making mistake or is CR issue?

BTW I'm using SQL 2000 with SP2.

Marin

 

[synapsevampire]

There were known issues for some versions, as in:

http://support.businessobjects.com/library/kbase/articles/c2016771.asp

Try applying the service pack:

http://support.businessobjects.com/downloads/updates/service_packs/default.asp

-k