Thanks for the responses Gus and Alan

I was hoping to be able to do this without editing XML but that seems to be the only way

I've use the dataset approach...

Thanks, makes sense

I now have the following:

create procedure ReturnFirstOfMonthList @dateToUse date, @startDateToUse date,

@endDateToUse date

as

set nocount on;

select distinct FIRST_OF_MONTH

from DW_Presentation.dbo.D_CALENDAR

where CALENDAR_DATE >= @startDateToUse

and CALENDAR_DATE < @endDateToUse

option (recompile)

go;

declare @dateToUse date

declare @startDateToUse date

declare...

Thanks for the responses

I am going to look at both single dataset and subreports

I suspect for this particular report, a single dataset would work best as the data is derived...

Looks like I need to create a New System Role Assignment

http://searchsqlserver.techtarget.com/tip/Managing-permissions-in-SQL-Server-Reporting-Services

Problem is, if I go into Site Setting; Security; New Role Assignment, I do not have the ability to create...

Thanks

Via Site Settings, If you set the role up as System User, it looks to provide 'View system properties, shared schedules, and allow use of Report Builder or other clients...

Last night, I fixed this with the creation of this index:

CREATE NONCLUSTERED INDEX [IX_F_POLICY_PREMIUM_TRANSACTION_DATE_SKEY] ON [dbo].[F_POLICY_PREMIUM]

(

[TRANSACTION_DATE_SKEY] ASC

)

INCLUDE ( [COVER_START_DATE_SKEY],

[POLICY_SKEY],

[POLICY_POSTING_SKEY],

[BUSINESS_AREA_SKEY],

[PRODUCT_SKEY],

[COVER_EXPIRY_DATE_SKEY],

[LAPSED_DATE_SKEY]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING...

Hi

Yes, it's a star schema

I've attached actual plan along with code for the indexes (there's quite a few)

Thanks

Damian.

Hi

I've attached a before and after plan

Before uses:

select count(*)

FROM F_POLICY_PREMIUM POLICY_DATA

INNER JOIN D_PRODUCT

ON POLICY_DATA.PRODUCT_SKEY...

great, thanks

I have the basics working now

Now going to try and adapt this

...Adapted version working, problem solved!

Thanks

what's the query?

Thanks

Bit of a shame as I it squashes everything up for the first few days of a month

I've got around different presentation formats by using rendering (hidden based upon export...

Problem with the wizard is that it looks for a value (compulsory)

Once you drop that in it groups every column!

I now think this simply isn't possible

Seems like such basic functionality...

Hmm...

So this morning (UK) I come in and see that the job worked!

Also, I can now perform manual backup steps to the network drive with no issues

All things considered, I...

ok, so I've tried the following and this still does not work

Created a maintenance plan that performs a backup to the network folder

Created me as a proxy user

So, added me...

I just can't see what has changed here

Now concerned that the same will happen if I have to restart the report server

If it's running as the service account on both...