It is possible, but you need Power View for SharePoint.

Inside Excel, you need to pull the data from your cube into Power Pivot and then build your Power View report...

The first one is clustered index, the second is a nonclustered index.

The difference is huge. A clustered index sorts the data according to its key, hence the clustered index IS...

This is something that might take some planning.

How big is the table?

Is the column used in indexes or in constraints?

Be aware that changing the width of the column might update...

Who knew you'd get this popular? 😀

Ah ok, apparently I didn't...

Try this:

=Globals!ReportName & " on " & Format(DATEADD(DAY,-1,NOW()),"dd MMM yyyy")

paul.knibbs (10/17/2014)

---

To be honest, if your developers really aren't capable of coding in a simple message that says "Sorry, you must select some filters first" if a client hits Get...

Nice one to end the week, thanks.

Only allow the execution of stored procedures?

Even if there is a way to enforce a WHERE clause, you can still always write WHERE 1 = 1.

Take a look at data driven subscriptions:

Create a Data-Driven Subscription

nostalgic.raj (10/16/2014)

---

hello, i too have been working with SQL server 2000 up till now n never upgraded to any other higher version. I want to know whether it will be...

Woohoo! 😎

😉

You need to use expression on your flat file connection manager.

Dynamically set Flat File Connection Manager

The error says otherwise...

Can you share the code?

The error message seems quite clear: either you specified an incorrect connection string, or you (or the account executing the package) don't have the permissions.