Decimal place MIA

I have a field which has a decimal place in the query results in report
designer, but on a table in the report it doesn't show the decimal place. So
a 10.5 shows as just 10. I already use the cint function to convert it from
string to int, but that doesn't help. This was working, and I'm not sure if
it's related it but I think after I upgraded to RS SP2 this started happening.CInt() will convert from string to integer and ignore all decimal places.
Use CDbl() instead - it will convert from string to double. Also, do you use
a format code property on the textbox which shows the field's value?
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Chris Patten" <ChrisPatten@.discussions.microsoft.com> wrote in message
news:3F61FB70-63F0-43FC-92DD-7A720C5DF04D@.microsoft.com...
>I have a field which has a decimal place in the query results in report
> designer, but on a table in the report it doesn't show the decimal place.
> So
> a 10.5 shows as just 10. I already use the cint function to convert it
> from
> string to int, but that doesn't help. This was working, and I'm not sure
> if
> it's related it but I think after I upgraded to RS SP2 this started
> happening.
>

Debugging Report Manager

Hi,
I have created a custom data processing extension that retrieves a Data
Table object from my DAL. It all works fine in the report designer, I can
preview the report and data is returned etc However when I deploy the report
and then try to access via the report manager web interface I get an error
has occurred during report processing... I can't for the life of me see what
is could be causing the error and I don't know how to debug this
Can anyone provide any useful tips/tricks?
ThanksMy bet is that dotnet security is tripping you up. When in development you
are the admin of the box and have all the rights you need to do anything.
The context of your assembly in production is different and you need to
setup the rights for the assembly. That is my guess anyway.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Neil" <Neil@.discussions.microsoft.com> wrote in message
news:B8854717-92A7-4ED1-8FDC-0D8462A594AB@.microsoft.com...
> Hi,
> I have created a custom data processing extension that retrieves a Data
> Table object from my DAL. It all works fine in the report designer, I can
> preview the report and data is returned etc However when I deploy the
> report
> and then try to access via the report manager web interface I get an error
> has occurred during report processing... I can't for the life of me see
> what
> is could be causing the error and I don't know how to debug this
> Can anyone provide any useful tips/tricks?
> Thanks
>