Yes Bob I did make the following assumptions while writing the code;

1. First set has one '1'

2. Every other set has 2 '1's

3. Last set doesnt have a comma

Thought not...

Haven't tested the following code for other scenarios, but works for the one mentioned in the post:

declare @STR varchar(50)

declare @str2 varchar(50)

declare @str3 varchar(50)

declare @str4 varchar(50)

set @str4='0001,01010,000101'

set

Hope i'm wording this correctly:

Modify the reports to use a Shared Datasource(s) (If multiple datasources are being used) and deploy the reports in the various environments. (Change the deployment server...

Execute the following query on the Report Server:

use reportserver

go

SELECT

ex.UserName, ex.Format, ex.TimeStart, cat.Name, ex.Parameters, CONVERT(nvarchar(10), ex.TimeStart, 101) AS rundate

FROM ExecutionLog AS ex INNER JOIN

Catalog AS cat ON ex.ReportID = cat.ItemID

ORDER BY...

If your SP returns ALL the revenue groups for each location every time, you can use the follwoing expression for the total:

=Sum(Fields!SalesGoal.Value)/CountDistinct(Fields!RevenueGroup.Value)

Cross join a subquery which returns you the total of the revenue goals. Then display this column with a First() clause in the total.

1. Create a hidden parameter(for eg @Flag).

2. Set the Falg value based on the SQL mentioned above. Set the Flag to 1 if start date > end date. 0 if...

If the Values are hard-coded, cant they be set as the default in the drill down report?

Create a query on the following lines:

Select * from (

select

ID,

date_logged,

Text,

'Incident' as TableName

Union

select

ID,

date_logged,

Text,

'Problem' as TableName)

Then Group by TableName on the Rows. This should work perfectly.

Even i am facing the same issue. I gave the FTP path as the collection directory. The package runs but the progress tab shows that the dirsctory is empty.

"Warning: The...