I think you are concentrating the @@ROWCOUNT corresponding to the SELECT (the section before the IF section starts).

Here what is happening is the statement SELECT @Accounts = null makes the...

Hey I under stood... I have made it to false now. it is working now...

Thanks lot mate... 🙂

I have attached the screenshot might help some one else

Navigate to Project-->Properties-->Run64BitRuntime =...

Hi thanks for the reply.

I had a look into the by right clicking the SQL Server Business Intelligence Development Studio -->Property --> Compatibility

There nothing is checked, is this is the...

The answer is "NO" as far as I know.

If some one has some other answer please let us know.

Hi ,

Did you try the above method I have mentioned (formatting in the report side..? )

It will display the data in the report as well as in the excel as...

Thank you Steve,

I will try this book, thanks a lot...

Thank you boss... your reply about the build in history is a new information for me.. thanks a lot...

Hi,

Either you can follow the above method in the code in the DB side,

OR

In the rdl, right click the field-->Property-->Format , then select the required format.

Hi

As per my knowledge there is no direct method, but explicitly you can do it by:

1. Create one general SP,say sp_ReportHeistory

2. For each repot use this SP...

Hi,

Are you able to try the above two suggestions I have mentioned?

Hi,

What I understood is after exporting to excel, when you keep the cursor over the field the error is displaying , am I correct?

This is because along with the numeric...

Hi can you just try this:

1. In the layout, right click the field and go to Property of the field.

2. Click on the format tab then provide the required format.

Hi,

You have mentioned you have URL , is it the report server URL ? Do you know the report server database ? If so can you try the below code...

You can do it like this

ALTER TABLE tablename ADD columnname AS CASE WHEN Bonus < 100 THEN 'Meager'

WHEN Bonus between 100 and 300 THEN 'Low'

WHEN Bonus...

Hi

Can I know whether the solution which I gave has solved your issue? Or is it like my understanding about the problem was not correct ?