I've since tried to change the job owner (me, sa, NT Service/SQLAgent$MI_SQL_SERVER, back to what it was)

No success

Everything else about the job works fine

Run as, for the step comes up...

use datepart or something like

=iif(DateDiff("d",fields!date1.value,fields!date2.value)>0,"yes","no")

Finally have a solution and it relates to SETFMT ONLY (Something I had never heard of) and the way SSRS handles result sets

Refer to this link:

http://stackoverflow.com/questions/21434827/no-fields-for-dynamic-sql-stored-procedure-in-ssrs-with-set-fmtonly

What worked for me...

Hi

Any thoughts on this

It is seriously winding me up now!

I've rewritten in a number of different ways and SSRS just keeps hanging when trying to open up stored procedures

I can...

Regarding option 1, this might help:

http://www.sqlservercentral.com/Forums/Topic1749995-150-1.aspx#bm1762267

I have reports that use a single dataset

These comprise of multiple small number of tables and charts to create a dashboard

Each part can, if necessary have it's own filter through...

What does your t-sql look like?

You should just be able to write one piece of t-sql and add this as a data set

Then parameterise (so customer name or number are...

Finally got this working!

Not sure if it's the benefit of going away and coming back with a fresh mind

Basically, I followed your expression structure and it still came back with...

Unfortunately, it still fails

So, I have an execution account set up (as me) through Reporting Services Configuration Manager

I've added an image

Set the Source to external

Set the value to ="file:///e:\Test.gif"

Now I...

Unfortunately, this as not worked, even using my account

This is really frustrating as I have now spent a number of hours trying everything

All I want to do is put an...

Thanks

Re-read Jasons article and went with this in the end:

USE [ReportServer$MI_REPORT_SERVER]

GO

/****** Object: StoredProcedure [dbo].[uspDataDriven_Fileshare_Parameter1] Script Date: 18/02/2016 08:58:40 ******/

SET ANSI_NULLS OFF

GO

SET QUOTED_IDENTIFIER OFF

GO

ALTER procedure [dbo].[uspDataDriven_Fileshare_Parameter1]

( @scheduleID...

Thanks for the responses Kevin and Jeff

1) The real purpose is improving build times

I have a small number of aggregated fact tables that build on a flush and fill basis,...

Hi

Just come back to this

I can get e-mail scheduling working but I've no idea how to get Windows File Share working

Does anybody know what the equivalent of this for Windows...

Thanks, that helps

This does look very useful

In this instance, the DB is simple so I don't backup the transaction log