This is a pretty good place to start

http://www.amazon.com/Delivering-Business-Intelligence-Microsoft-Server/dp/0071549447/ref=sr_1_1?ie=UTF8&qid=1352139096&sr=8-1&keywords=delivering+business+intelligence+sql+server+2008

clueless

If you have the enterprise edition a data driven subscription is absolutely the way to go. Assuming your report would run on the first of every month you could...

rahulpatange (11/1/2012)

---

I am talking about the actual name can you please tell me how to do that.

i need location name appended to my actual report name, and this location ...

merge

Well, that all depends on what you mean by report name. If you mean the actual name, it is possible but it is very difficult and involves doing some...

If you use the enterprise version you can make a data driven subscription and build your parameter query there. However, if you need multiple values for a single parameter...

Noah....how long can you tread water?

Franken - storm

I have found dropping the index before starting and then recreating the index afterwards results in the best overall times for me.

If you can, you would be better off creating a direct connector to the source db rather than using a linked server. If you have to stay with the...

It concerns me a bit that you have 2 different week numbers. Personally I would be inclined to change one of them. The business must have definitions for...

logic

Excel and PowerPivot directly connected to the database. There is also a tool in 2012 (I forget the name) that is very much like Tableau and supposedly available to...

Filtering the tablix rather than the individual text boxes will probably be less work. It is what I typically do.