thanks for the question and the great explanation...

Good question...

You can apply the expression on the text box...

=IIF(Fields!TotalHours.Value < 8 ,"",Fields!TotalHours.Value)

LastRuntime is the column which can help getting the Running time value of the subscription

You need to connect to the ReportServer DB on the report server to retrieve the Running time of the subscriptions...

select * from subscriptions

You can use the following query to get the last date of the week..

select dateadd(dd,7-datepart(dw,getdate()),getdate())

just replace the getdate() with the date column and group the data based on this last...

You can use the last date of each week on the X-axis...

If you will try to enter the NULL value into the column with the definition AllowNull = Yes, it will permit the NULL value to be inserted even if you...

As dave said, you can use SSRS reports to get the results back in the excel and with also the format which is required...

You can subscribe the reports to get...

It really depends on what are you trying to tune in SQL server...

if its query, procs , ssis packages, ssrs reports or the jobs...

plz be more precise asking the questions,...

Try using NVARCHAR(MAX) as datatype for the comments column

B O N U S P O I N T...

Try to open the reports in BIDS and in Data tab you will be able to locate the Datasets used by the report. Edit all the dataset and change the...

Click on Report > Report Properties

Within the Report properties click on the Layout tab and set the page width/height settings as per needed.

Got it right...

It took me 15 min to read and 15 second to answer;-)