Thanks HanShi, that works great 🙂

Thanks pietlinden,

I'm using 2008R2, what would the select statement be from the temp table please as your 2012 one doesn't parse?

I resolved this by using the DeviceInfo FileExtension tags and also adding an ExtensionName for the TTX file output

<Render>

<Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering"/>

<Extension Name="NULL" Type="Microsoft.ReportingServices.Rendering.NullRenderer.NullReport,Microsoft.ReportingServices.NullRendering" Visible="false"/>

<Extension Name="TTX" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering">

<OverrideNames>

...

I found a solution for what I wanted to do by using

SELECT 'ReportName_' + REPLACE(CONVERT(VARCHAR(10),GETDATE(),101),'/','') AS [FileName]

This then allowed me to proceed to step 4 where I could populate...

works for me 🙂

I also used psexec.exe to allow a user to execute the batch file on a remote server.

perfect, thank you so much.

both solutions work, many thanks

Thanks Michael Valentine Jones, I can't say I understand it but that worked perfectly!! 😀

I've no problem with creating a view for this but there must be a way of specifying the weekending day of week to be Saturday and using that date as...

Weekly Table:

IF OBJECT_ID('TempDB..#Weekly','U') IS NOT NULL

DROP TABLE #Weekly

CREATE TABLE [dbo].[#Weekly](

[weekending] [datetime] NOT NULL,

[line] [int] NOT NULL,

[WeeksCost] [decimal](18, 2) NULL,

CONSTRAINT [PK_#Weekly] PRIMARY...

ok, i've changed the query to an update query as I already have data but want to update one field:

update dbo.Weekly set WeeksCost = (

SELECT SUM(Cost) FROM dbo.Daily GROUP BY...

I haven't tried anything yet as I am not sure how to do it.

That's great, thanks!

It was just a syntax error - missing "'s on the datepart!

DATEADD ("day", 6, Date)

It works now

The data type is date already [DT_DATE] - I used the 'suggest types' option.