See if this helps:

http://www.databasejournal.com/features/msaccess/article.php/3407531/How-to-Execute-SQL-Stored-Procedures-from-Microsoft-Access.htm

Rob

This SSAS Performance Guide from MS might be a start for you:

http://msdn.microsoft.com/en-us/library/dn749781.aspx

HTH,

Rob

ramana3327 (11/20/2014)

---

Hi,

We have a report with parameter username. When we pass username it will update his email.

We have to enter the parameter. We didn't specify the the values or...

So, someone switched the SP_ReportServer or SP_ReportServerIntegrated (if using SP integrated mode)? You can probably tell when this happened by checking execution log for report run times. But...

Are you talking about the report's data source being changed? Is the .rsds stored in SharePoint or a file system where you can see who last modified?

It's hard to...

DarthBurrito (10/8/2014)

---

robert.gerald.taylor (10/8/2014)

---

Probably a silly question, but if the Add-On Column is always green, why not just set the back color to green.

Or are you saying that your grouping's expression...

I thought columnstore indexes were updatable in 2014:

http://blogs.msdn.com/b/sql_shep/archive/2014/05/01/sql-server-2014-updatable-columnstore-index.aspx

http://sqlblog.com/blogs/michael_zilberstein/archive/2013/07/01/49903.aspx

Wouldn't that take care of your updating the SCD?

HTH,

Rob

Probably a silly question, but if the Add-On Column is always green, why not just set the back color to green.

Or are you saying that your grouping's expression is incorrectly...

doug.brown (10/7/2014)

---

??? A...

Does your login not have permissions? Is SSRS running under a service account? That would be the first things I'd check.

HTH,

Rob

I've found it helpful to use windows explorer and browse/search the reporting server(s) directly. That way I can search for all .rdl (report) or .rsds (data source) files. ...

gmontanaro (9/22/2014)

---

I have a Retail Sales Fact table and a dimension table called DimRebate.

CREATE TABLE [dbo].[FactRetailSales]

([LocationKey] [int] NOT NULL,

[InvoiceDateKey] [int] NOT NULL,

[ItemKey] [int] NOT NULL,

[RebateKey] [int] NOT NULL,

[InvoiceNumber] [int] NOT...

mutlyp (9/8/2014)

---

Sorry new to this and I could really use some help.

I have view that has and ID number, a Min and Max value and a TotalCount columns. I then...

Someone has probably written a little bit of code to do division that handles zeros. To see the code in your SSRS report take a look at this link:

http://msdn.microsoft.com/en-us/library/ms156028(v=sql.110).aspx

From...

I'm guessing this isn't SSRS related and that you'd probably have better luck asking a MySQL load question on forums specifically for MySQL as opposed to MS SQL Server.

Good luck,

Rob