I've been thinking of doing something similar for a while, so your post pushed me in the right direction.

I noticed you have a lot of code just to calculate the...

Thanks for your time. I guess we can just continue going the way we've been going. I suppose allowing users to see internal reports isn't the end of...

Thanks so much! That cleared up a few things I was always wondering about our setup.

Actually, you are right. The round function would be my friend in this case, and it allows me to use a variable to set the Scale. Thanks!

I'm trying to implement a way to convert between pounds and kilograms in an existing application (C++) that heavily relies on the database.

Values are stored in the database using different...

Thanks Lynn! I think this might do it.

I have to admit I didn't know about the ## temp table. I got into the habit of dropping my temp...

Thanks for your reply.

I'm not sure sql_variant would really help in my case. I'm more concerned with calculating values using the same precision and scale than I am...

I had to use this tool last week, when we noticed some data was missing in one of our tables after a manual update. Our backups were able to...

It's a problem with Service Pack 1 for SQL Server 2005, which removed the ability to "Select All". You should already know this from your other thread, but there...

Not sure if everyone knew, but there is now a fix for this:

http://blogs.msdn.com/bwelcker/archive/2006/08/14/700189.aspx

It's nice to see some solutions coming together. We're not going to make a decision on what to do until at least next week, but our IT Manager has...

We have come across this same issue - our users do not have administrator access and therefore cannot get the print client control installed. We are using RS 2005...

You CAN compare text strings with the IIF Statement, even . You just have to make sure you are comparing a String value to a String value.

We're running Report Services 2005 & SharePoint 2003.

I was wondering if you ever found out any information on integrating the two. We have an existing Sharepoint installation, and are...

Report Services runs off a SQL Server database. I'm not sure you can use the datagrid as your datasource. Maybe you can export your data from your datagrid...