Yes Drew, always same. Thanks.

Yes, week always...

WOW! Thanks Lutz.

This is excellent, worked excatly how i wanted. Only change i made is to use getdate() to avoid hardcoding the calendar derived table.

Thanks Again!

srichaitya,

see this link below. This should help you.

http://sqlscrapbook.wordpress.com/2010/07/14/load-data-into-a-temp-table-using-ssis/

Thanks.

Perfect. Thank you so much.

May be worth it to mention that this is a built in functionality in SQL2008 R2.

Here is how to do this...

http://www.bidn.com/blogs/PatrickLeBlanc/ssis/762/ssrs-r2-naming-excel-worksheet-tabs

From your description, it is unclear of what is source of your problem. It could be your sql query, or the groups/drilldowns in your report.

Try playing with the TimeOut field...

I don't think so, by using page break you are telling the SSRS to show the part of the report after the pafe break in a new page and new...

can you post the result of this query,

select convert(decimal,'-95469.49') as Result

Try this.

declare @amt nvarchar(100)

set @amt = '-10299.00'

select convert(decimal,REPLACE(@amt,',','')) as Result

--Result -10299

Thanks Wayne,this helps...

lmu92 (6/24/2010)

---

Please provide table definition (DDL), sample data and expected result based on the sample in a ready to use format as described in the first link in my signature.

Also,...

Thanks for the quick response Dan!

Please see attachment. that's what i could get but i am trying to show the toppest levels and all the employees underneath them like below...

May be i posted in the wrong forum,

I posted this again at http://www.sqlservercentral.com/Forums/Topic846233-338-1.aspx

Please direct your response .

Sorry for the duplication.

I would use the No Rows property to display a custom message that will tell the users that there is no data.

Email will be sent based on the subscription schedule,...