sorry that should read

DateDiff("dd",Fields!StartDate.Value,Fields!ENDDate.Value) to get the days void

try

DateDiff("dd",Fields!StartDate.Value,Fields!StartDate.Value) to get the days void

Possibly try CInt(sum(Fields!DaysVoid, "dataset_name") ) - assuming daysvoid is calculated as part of the query ?

is the text box property set to date time ?

target server URL : http://XXXdev002/sites/Reports

target report folder: http://XXXdev002/sites/Reports/myreports

works but only if you set the other parts you are not using to blank

so as I am...

I know your pain, did the same thing with 2008 in my last company then moved it to 2012 - got everything working lovely then moved. we now have vendor...

SSRS isnt running as only the sharepoint integrated service has been installed and configured

but when i try that approach i get the following

Error1The specified folder is not valid. Specify a value for the TargetReportItemFolder property in the deployment settings. If you are deploying...

For various reasons lotsof things get set to zero at 00:01 on the first day of the month, so running thereports then isnt a possibility. However running all the queries...

I'm happily using SQL2008 and still finalizing the shift from older 2005/2000 servers to 2008, with one exception our sharepoint 2010 install is run using SQL 2012 as the BI...

Linked servers now using dbo level account and speed is back to sub 5 seconds.

I will however need to re think the whole approach as for security reasons...

sorry , i blanked out the insert part of the statement when i was trying to get the results back to try and work out why it was taking such...

I have uploaded the 'working ' plan.

On the developer server and the old production server the link between the servers was a dedicated 'sa' sql logon. On the new box...

It was set up as high performance, I dont have a spare server to act as a witness at the moment . It does document management and everytime there was...

In that case I'll just go and get it setup then 🙂