This is exactly why cross posting is a bad idea. Now you have two similar threads with different people participating, possibly wasting time for some of them.

http://www.sqlservercentral.com/Forums/Topic1521887-364-1.aspx

Sure, you can use the ReportViewer Controls.

Integrating Reporting Services Using the ReportViewer Controls

arooj300 (12/11/2013)

---

Thanks for the reply...

I want to clear my question , I think this will be easy to understand.

we have a production DB. we have millions of data which client...

You cannot call a report in BIDS with an URL (you need a web service). You need to deploy the report to the server first and then you can access...

wendy elizabeth (12/11/2013)

---

The reference you pointed 'http://msdn.microsoft.com/en-us/library/ms155391.aspx' looks like a good link. My question is how is url suppose to obtain the value for the parameters? Do you know what...

I think it is quite normal that readers are blocked when a bulk insert operation is going on. This is to prevent dirty reads.

Greg Edwards-268690 (12/11/2013)

---

Koen Verbeeck (12/10/2013)

---

Greg Edwards-268690 (12/10/2013)

---

If a customer can change back and forth several times during the month, I'm missing some concept.

Why would this freeze at the end of...

Do you have any actual query plans for both statements?

Too easy 😀

Great question, thanks!

Haven't done this myself, but I think you can use the "go to URL" option that you mentioned.

You can pass parameters to the URL:

Pass a Report Parameter Within a URL

Does it work when you execute the SELECT statement directly in the OLE DB Source component?

Billing is at...

sneumersky (12/10/2013)

---

What does your current data model look like (as in a visual, if available).

There are many solutions that come to mind, but I like to compare "what...

Greg Edwards-268690 (12/10/2013)

---

At the end of the day, you still have to answer is this an always current dimension / attribute for any given customer, or tied to each month...