Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Classic ASP Professional For advanced coder questions in ASP 3. NOT for ASP.NET 1.0, 1.1, or 2.0.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old May 30th, 2006, 10:14 AM
Registered User
Join Date: May 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default 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

Similar Threads
Thread Thread Starter Forum Replies Last Post
ASP.NET - Crystal Reports venkat999 ASP.NET 2.0 Professional 2 October 29th, 2006 09:39 AM
Crystal Reports and ASP Rob - FH ASP.NET 2.0 Professional 0 June 13th, 2006 12:59 PM
ASP and Crystal Reports delaware_74 Crystal Reports 1 September 29th, 2004 03:31 AM
Crystal Reports in ASP sa_moizatyahoo Classic ASP Components 0 May 1st, 2004 01:43 AM
Crystal Reports in ASP.NET bmains Crystal Reports 2 March 27th, 2004 04:45 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.