Thanks for trusting my nose, i don't even trust it myself sometimes!

My bad, I was looking for it in the left panel and drop-down menus.

You are right about date ranges, I'll fix them in final version, similar to 7 days range. Ideally, Daily averages should have calculated beyond the date limit, all time daily...

I was able to do it without CTE:

declare @FromDate as datetime2 = '2023-02-01';declare @ToDate as datetime2 = '2024-04-16';
declare @DtRef datetime = Dateadd(dd, Datediff(dd, 0,@ToDate), 0);
select  ...

This is great improvment compared my code, thank you for that.

I only have read access to this database, will talk to the devs about createing function, hopefully they agree.

The averages...

You can try this:

=IIF(
    SUM(IIF(Fields!IN_OPERATING_HOURS.Value = 1, 1, 0)) = 0 OR SUM(IIF(Fields!IN_OPERATING_HOURS.Value = 1, 1, 0)) = Nothing,
    0,
 ...

You can group you sub report with ID and apply page breaks. This way every ID will be displayed in different pages.

This could be out of context, as I'm not expert. But why not just publish SSRS reports to Power BI, as power bi seems to act as report server, at...

It's multidimensional. And for the front end using Devexpress dashboard. All this workarounds are mostly because tool doesn't have option to show/hide nulls by default

I see, so it has to be in every select statement. I think I'll stick with your original solution, because every select is kind of retrieves different step types. But...

Here is what my actual select statement looks like (simplified)  instead of #sample provided above:

select ps.[Oid]
      ,o.Oid [Order]  
  ...

Thanks folks for the great answers, both seems to work correct as I checked with data. Just second query looks more compact. Although,  my "sample" is actually  7 complex select...

Did check the data, in Domino and Oracle looks same : '0200-10-29' and their type is date as well. As far as I know they are not converting it...

Data type in SQL Server is date in both cases. Previous data flow was Domino->Oracle->SQL Server, now getting direct Domino->SQL Server

No it was not. Randomly stops connecting while Node B is active, anybody have any suggestions? I've run out ideas.

There is another package that imports data from Oracle. That...

Finally fixed, it was third party firewall blocking the connection