T-SQL answer since this is a T-SQL forum.

--Calendar table

CREATE TABLE #open_days ([open] DATETIME);

INSERT INTO #open_days VALUES ('2016-08-26 00:00:00'), ('2016-08-29 00:00:00');

--Tally table

CREATE TABLE #numbers (n INT);

INSERT INTO #numbers SELECT TOP 100...

This is a T-SQL forum so you'd probably get better answers in an Oracle forum. I've had a bash in Postgres since I believe the date functions are similar...

Hi Frank,

Could this not be achieved using a RunningValue aggregation instead of custom code?

If it's in the group footer you can just add the summed value each time e.g.

=RunningValue(Sum(Fields!CO.Value), Sum,...

This is to do with the interval min and max you set on your axis, the type it is expecting is a DateTime and when you enter 00:00:00 and omit...

Use the TimeSerial as the value for your Y series. You're not formatting, you're converting the Integer to a DateTime. The chart will interpret the DateTime as a...

Hang on, I think I see what you are getting at.

In a scatter plot the y-axis labels will always be determined by the value, you cannot set your labels as...

The custom format should just be a string e.g. mm:ss

You can adjust the intervals via the axis options.

Even better - use the TimeSerial (it does the same as above) function and format the datetime it returns!

I.e. =TimeSerial(0,0,Fields!Seconds.Value)

You can pass any number of seconds in e.g. 120 and...

You could convert it to an actual datetime from the year dot (01/01/0001 00:00) since you are only interested in the minutes and seconds parts.

I.e. =DateAdd(DateInterval.Second, 30, System.DateTime.MinValue)

Where 30 would...

Hi Nineiron,

Not really.

You can use your dataset to populate available values for a parameter which is set to filter a report item, e.g. a tablix.

This will populate the...

SSRS does this to prevent overlapping objects when it cannot predetermine the size, e.g. how many rows a table will have.

If you want to lock items relative to eachother on...

Hi Rob,

SSDT works with a project model and does not maintain an active link to the report server. This means all the objects, dataset etc have to be stored...

Design issues aside when you post these sorts of questions you should post the SQL to create the sample data - I've done it here, I've changed the dates slightly...

Charts are like a matrix so the category and series groups in charts are just that: Groups. Therefore you can use them as a scope for aggregations.

Change your chart...

Hi,

You can backup the encryption key again through the Reporting Services Configuration Manager. You don't need to go through any of the other configuration steps.

Or you can use the...