You can avoid creating a dataset if you specify the available list of values, so if you have a really...

Thanks John

I found loads of VBA info on google, but not much about vbscript

In the end, the answer turned about to be frustratingly simple:

Change this

_sheets(_sheet.Name).copy, _sheets(1)

To this

_sheets(_sheet.Name).copy(, _sheets(1))

:crazy:

When you create a report in BIDS (and it doesn't really matter where BIDS is installed, whether on server1, server2 or on another machine as long as they can connect...

This should get you started, it basically returns a list of users against their roles for any items which have a different policy to the Home folder:

declare @HomePolicyID uniqueidentifier

set @HomePolicyID...

The security policy of all reports/folders is stored in the PolicyID field in the catalog table of the ReportServer database

The PolicyRoot field in the catalog table defines whether an item...

Following on from what The Ninja said above, in BIDS you would set up your connection to Box2 to enable the report to pull back information from your production server

Then...

Good luck 🙂

As Ben said earlier, the trick will be in making sure that the code you use for the DDS checks for the existence of valid data, so as...

Yes, that would also work and be a more straightforward way to accomplish this

As we are using Standard Edition where I am, data driven subscriptions are not available hence resorting...

AFAIk there is no setting for this within the standard subscriptions, and while you can set a report to display something different if no results are returned using the NoRows...

If you limit your output to a single row does it show the % as 100%?

Perhaps more helpfully, shouldn't this formula:

=Fields!Hours.Value/Sum(Fields!Hours.Value,"DataSet1")

be changed to this:

=sum(Fields!Hours.Value)/Sum(Fields!Hours.Value,"DataSet1")

As you want to sum up all the hours for that activity/week/team?

TEAM WeekCommencing Activity (project) % ...

Not sure if this would be any different using sharepoint, but if you were just doing this in SSRS you could set up 2 parameters, one each for the start...

If the report will always run for the previous day, you could set this in the report itself rather than the subscription by setting the date parameters (either within the...

I think you might need to change it to this...

SUM(CASE WHEN [Type]='O' AND Shift=1 THEN 1 ELSE 0 END) AS [firstOrderly],

etc.

but I could very easily be wrong