Crystal Reports Truncate Numbers from ASP
Hi, i have a report called ReportHH.asp which connect's to a ODBC SQL Server Stored Procedure to retreive data. This stored procedure returns a temporary table with some data, like worker_name varchar(255) and worker_hours numeric(12,2). when i see the report in Crystal Report app the numbers in worker_hours seems ok (example: worker_1 has 5,5 hours in 1 day), bur when i call the report from asp with the link
ReportHH.asp?server=DATASERVER;user0=sa;password0= sa;prompt0=12
where prompt0=12 means the stored proc param representing worker ID, the report shows thw worker_hour value = 5,00 !!!! , i'v tried to find the error testing in server and my pc (Server: Windows 2000 SP4 + SQL Server 2000 SP3+ IIS 5 + Crystal Reports 8.0)
but i don't know how the number is truncated by the seagete web page server engine
Thanks for any help
|