Viewing 15 posts - 1 through 15 (of 45 total)
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,
...
September 12, 2023 at 2:19 am
You can group you sub report with ID and apply page breaks. This way every ID will be displayed in different pages.
August 15, 2023 at 7:07 am
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...
August 15, 2023 at 7:00 am
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
June 13, 2023 at 4:15 am
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...
March 6, 2023 at 8:19 am
Here is what my actual select statement looks like (simplified) instead of #sample provided above:
select ps.[Oid]
,o.Oid [Order]
...
March 6, 2023 at 5:51 am
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...
March 6, 2023 at 3:29 am
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...
November 13, 2013 at 8:35 am
Data type in SQL Server is date in both cases. Previous data flow was Domino->Oracle->SQL Server, now getting direct Domino->SQL Server
November 12, 2013 at 11:52 pm
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...
October 23, 2013 at 10:36 pm
Finally fixed, it was third party firewall blocking the connection
October 23, 2013 at 12:31 am
I thought finally found SQL Server bug 🙂 but no, it was another package that was messing with my end table. So, Dwain, it's safe to use Money type.
Thanks...
September 12, 2013 at 10:59 pm
I thought you'd never ask! #Lady from Glee 😛
INSERT INTO [IPTS_Staging].[dbo].[FactSectorKPIHist]
([Prospect]
...
September 11, 2013 at 7:25 am
Here you go:
Creating table:
---==Create table
CREATE TABLE [dbo].[MDCS_GPS_LOG_RECV](
[Msg_ID] [varchar](50) NULL,
[Callsign] [varchar](50) NULL,
[Timestamp] [varchar](50) NULL,
[Msg_Content] [varchar](2500) NULL
) ON [PRIMARY]
GO
Sample rows:
INSERT INTO [dbo].[MDCS_GPS_LOG_RECV]
...
August 14, 2013 at 3:48 am
We've been doing some performance testing for Columnstore indexing using 160 mln rows, 400 mln rows with different kind of reporting queries. The purpose of test was, if it was...
August 14, 2013 at 2:26 am
Viewing 15 posts - 1 through 15 (of 45 total)