I have a similar problem.

I have simple report and all the cells after exporting the report to excel appear wrapped in excel.

I want to know how can I turn...

Here is what you need in your store procedure

declare @uptoMonth as int

declare @year as int

declare @LASTDAY VARCHAR(10)

declare @lear as int

set @leap = (select case datepart(mm, dateadd(dd, 1, cast((cast(@year as varchar(4))...

DECLARE @LASTDAY VARCHAR(10)

declare @uptoMonth as int

declare @year as int

declare @lear as int

set @leap = (select case datepart(mm, dateadd(dd, 1, cast((cast(@year as varchar(4)) + '0228') as datetime))) when 2 then 1...

You have many to do this.

One of them is to create a table an fill it up with month and last day.

In the table just this two fields, MONTH and...

ODE may or may not be on the dataset result.

Actual always will be on the dataset result.

When there is no ODE data, there is no problem, only show one...

The report was working correct!! Just went wrong a few minutes ago!

Im trying to make an INSERT on a temp table.

Thank you very much!

I'm working on this query for almost a week!!!!

Here if you buy a book on amazon plus the shipping charge you save between 25% or 35% than the price that is here on Argentina.

But were losing focus on...

Yes we have of course, but the prices are extremely high.

For example: 1 us dollar(u$s) = 4,30 Argentine Pesos ($)

If a book on Amazon cost u$s40, you assume here is...

Yes, I was aware of that, but I'm from Argentina and our "dear president" (sarcasm) do not allow us to buy dollars or made transaction in dollars, so I cant...

Thank you very much, I use "all source" and it works!!!!!!

I try a simple ctrl+v

I try a special paste, first values then format and viceversa and nothing, the color format change for example from a light blue to a bright...

I already export the data to an excel file.

I have another excel file with a few sheets, I want to copy the data from the excel exported from ssrs and...

Exactly.

I'll contact my client tomorrow for more information an update this post.