I've been using this, but found that SSRS limits the sheet name to very small name. Reality is that most users want a date and the measure name or...

We decided not to use a data driven subscription as the goal was to only purge and update the report cache when our ETL process completed.

We accomplished this by finding...

I figured this one out on my own. How do we 'kill' the thread? Admin?

Thanks Daniel, that did the trick, but it seems that you must keep the original schedule as well.

Seems that now the subscrption works for the main report but the detail...

Good. Glad to help. It actually is from this link, which u may find usefull.

http://www.sqlservercentral.com/articles/SSRS/69257/

try this:

set transaction isolation level read uncommitted

;WITH ReportItems (ItemID, Name, Path, reportXml) AS

(

SELECT ItemID

, Name

, Path

, CAST(CAST([Content] AS VARBINARY(MAX)) AS XML) AS reportXml

FROM Catalog

WHERE (Type = 2)

)

SELECT ItemID

, Name

, Path

,...

I agree the questions are more basic. But this is due to the business side thinking that 'anyone' that has computer can be a dba.

Case in point. I...

You guys might want to take a look at this as well. I blew the doors off my managers when I gave them this and the rsexecutionlog reports.

We are using this proc instead.

USE [RSExecutionLog]

GO

/****** Object: StoredProcedure [dbo].[Upd_RSExecutionLog] Script Date: 11/23/2010 09:57:26 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[Upd_RSExecutionLog]

AS

--***********************************

-- Initialise

--***********************************

DECLARE @myRows INT

DECLARE @myTimeEnd DATETIME

DECLARE...

Doesn't work on 2008r2, getting Msg 8152, Level 16, State 13, Procedure Upd_RSExecutionLog, Line 108

String or binary data would be truncated.

Thanks john. We actually did notice that, but BOL doesn't talk about MSOLAP too clearly. We had to take a look at connectionstrings.com to get the correct connection...

I normally use a 'template' for all my reports,(http://weblogs.sqlteam.com/jhermiz/archive/2007/08/14/60283.aspx)

so I'm not sure how this really could benefit me?

The really pain is standardizing tablixes for reusability.

Naming all those 'textbox1,...

The original post was made in the hope that there is some 'recommended practices' from Microsoft. Has anyone see any such white paper?

What I am seeing is all the formatting is being done in the SQL. I wonder what MS says?

My point was that the primary purpose of SPs, at least from a reporting point, is the reusability of the same code, from a single source. Shared datasets are...