In an SSRS report I want to hide the tablix/table when there are no rows appearing. Problem is there are rows, but I hide the rows when column 1 is the same as column2. So my problem is that I don't want the column headers / table to appear when no other row appears. Is this possible I think there are scope issues doing this.

At moment I have two datasets. One retrieves current values, the other dataset retrieves historical data from a specific point in time. So I am using the lookup value '=Lookup(Fields!LabelLookup.Value, Fields!LabelLookup.Value, Fields!Value.Value,"Date2")' to show in one cell what the value was at a specific date and in the other cell what is is now on the same row.  When the two values are the same I hide the row because there was no change. This works fine, but sometimes I am left with just the table header showing no rows. However, there might be lots of rows but are actually duplicate, as the value has not changed between the two dates.

Is there a way to check if there are no rows appearing in the table after the hide rows has been applied? I'm not sure it is possible? If not is there another way I might be able to do this?

Using sql server and SSRS instance 2014

Dear all
        i would like to know how many IIS is running on the server in the world, is there any website for this ?

I have written a procedure to update SSRS subscription schedules. The procedure appears to work because the values are updated in ReportServer.dbo.Schedule. However when I view the schedule through SSRS Report Manager, the dates are not updated.

The code I am using is below -

declare 
--@SubscriptionID varchar(100) = 'E65E6D4A-A631-4C17-A8DB-001FB0AD0855'
@Path varchar(max) = '/QTS Internal/RTM/Service Disruption Report'
, @SPLC varchar(max) = '123456'
, @State varchar(max) = 'VA,NC'
, @Country varchar(max) = NULL
, @Carrier varchar(max) = NULL
, @Location varchar(max) = NULL
, @CustomerID varchar(max) = '1'
, @Disruption varchar(max) = 'Hurricane Florence'
, @StartDate datetime = '20180914 04:19:00'
, @EndDate datetime = '20181002'

create table #subs (SubscriptionID varchar(200), [Path] varchar(200))

insert into #subs

select s.SubscriptionID, c.Path

from Catalog c
join subscriptions s on c.ItemID = s.Report_OID
where c.Path = @Path

-----------------------------------------------------update schedule dates

UPDATE ReportServer.dbo.Schedule
SET StartDate = @StartDate, EndDate = @EndDate
from Catalog c
LEFT OUTER JOIN Subscriptions s WITH (NOLOCK) ON s.Report_OID = c.ItemID
LEFT OUTER JOIN ReportServer.dbo.[ReportSchedule] RS WITH (NOLOCK) ON s.[SubscriptionID] = RS.[SubscriptionID] 
LEFT OUTER JOIN ReportServer.dbo.[Schedule] SC WITH (NOLOCK) ON RS.[ScheduleID] = SC.[ScheduleID]
JOIN #subs subs on s.SubscriptionID = subs.SubscriptionID

Select all Open in new window

Does anybody have experience with this?

I have been tasked with creating some reports out of VS and SSRS from an Oracle 12c database.  I am an Oracle developer but I don't know much about VS or SSRS.  I have both VS 2015 (14.0.25431.01 Update 3) and 2017 (15.7.5) installed and I have installed ODTwithODAC for 12c.  I have also installed SSDT for both VS 2015 and VS 2017.  

Using VS 2017, i have created a new project but I am unable to create a shared data source.  As soon as I select Oracle Database in the Type drop-down, the Edit button next to the connection string becomes grayed out.  

Using VS 2015, I have cloned an existing project that works fine for my colleague.  However, when I first tried to load the project I received a message that the version of the report server project is not supported and the project must be upgraded.  If I say no, then the project won't load.  If I say yes, the project loads and everything seems to be ok. However, when I try to Preview an existing report from the project, I receive the following error:
"An error has occurred during local report processing.  An error has occurred during report processing.  An attempt has been been made to use a data extension 'ORACLE' that is either not registered for this report server or is not supported in this edition of Reporting Services."  There is nothing in the Error List when this happens.  

The only difference between my colleague's setup and mine is that he has SQL Server Reporting Services 14.0.806.134 and I have …

RADIUS VPN fails to connect due to NPS error.

We have a router doing Radius passthrough to Server 2012 R2 using NPS.

The policies have been created via a wizard and appear correct.
I have a security group in AD that I am testing with a test account.

When initiating the connection externally it times out and returns the following from the NPS event logs:

Network Policy Server denied access to a user.

Contact the Network Policy Server administrator for more information.

User:
      Security ID:                  dc.local\testing123
      Account Name:                  dc.local\Testing123
      Account Domain:                  RSCdc.local\Testing123

Client Machine:
      Security ID:                  NULL SID
      Account Name:                  -
      Fully Qualified Account Name:      -
      OS-Version:                  -
      Called Station Identifier:            -
      Calling Station Identifier:            -

NAS:
      NAS IPv4 Address:            192.168.23.5
      NAS IPv6 Address:            -
      NAS Identifier:                  -
      NAS Port-Type:                  -
      NAS Port:                  -

RADIUS Client:
      Client Friendly Name:            draytek vigor 2920
      Client IP Address:                  192.168.23.5

Authentication Details:
      Connection Request Policy Name:      Use Windows authentication for all users
      Network Policy Name:            -
      Authentication Provider:            Windows
      Authentication Server:            dc.local
      Authentication Type:            MS-CHAPv2
      EAP Type:                  -
      Account Session Identifier:            -
      Logging Results:                  Accounting information was written to the local log file.
      Reason Code:                  48
      Reason:                        The connection request did not match any configured network policy.


NPS is …

We recently upgraded our SCCM clients (Configuration Manager) to 5.00.8634.1814.

We did this after upgrading the site to 1802.

After the upgrade all of the icons in Software Center are wacked out.  Prior to the upgrade, something was taking different sized icons and make them automatically appear the same.

In the new version, this functionality works in the List View option - all icons appear the same size regardless of their size.  In Tile View, which everyone uses, this is not the case.  The icons are not being adjusted for the view.

Has anyone else noted this issue?  Is there a setting somewhere I can click to resize?

I hope so.  So far it's that or I have to resize them all manually.

Can someone provide the name of some open source software that can assist with web utilization, os utilization virtualization and security vulnerabilities. It does not have to be all the same software. This is for linux and windows OS.

What device do you recommend that can email me when my server room's SOUND get above a certain decibel level ?
  ** Maybe something like https://serverscheck.com/sensors/sensor_sound.asp, etc ?

The following command string exports a PDF to be saved or opened.

start explorer "<http://ServerName/ReportServer$NamedSQLInstance?%2fPurchasing%2fPurchaseOrder&PoNumber=103290&rs:Format=PDF"

Need to NAME and SAVE the file Automatically, from a Delphi desktop application.

Dear Experts ,
Please help in
windows 2012,

ADAM Sync Error logs

Ldap error occured. ldap_modify_sW: Constraint Violation.  
Extended Info: 00002082: AtrErr: DSID-03151768, #1:
0: 00002082: DSID-03151768, problem 1005 (CONSTRAINT_ATT_TYPE), data 0, Att 9ae287ba (title):len 154

Citrix Receiver 4.1 working fine, but not 4.9 for PS 4.5 IE App (Dual hop) inside Citrix XAXD 7.15 Win7 (XA7.6 VDA) VDI
Citrix Environment: Citrix XD 7.15 LTSR CU1
Provisioning technology:  It is static VDI (Windows 7 using 7.6 LTSR VDA) assignment no PVS/MCS.
Profile type: Microsoft User experience virtualization (UEV)
Hypervisor: VMWARE ESXi 6.5
- are all users affected? Yes
--Problem Statement:
We have VDIs running with VDA 7.6 and Citrix receiver 4.9 cu2.
We have an IE based app which is published on presentation server 4.5 rollup 4, win 2003 R2 sp2 standard edition, web interface 4.5 and running on Citrix secure gateway. I know it is very old and unsupported but that is what we have got, unfortunately..
The user logs in to the VDI using a Citrix SF URL and from the VDI the user then clicks on the PS 4.5 published IE and goes to another Citrix secure gateway URL.
To launch the IE-based app. This is the legacy PS 4.5 farm.
When the user connects to this app user experience poor screen refresh rate and latency in the overall VDI session. If the user closes The IE app the VDI functions normally.
This issue started when we rolled out received 4.9 LTSR cu2 on to the VDIs. The IE-based app works perfectly fine on receiver 4.1. So we definitely know it is the compatibility issue between receiver 4.9 and presentation server/web interface 4.5.
We can’t roll back the receiver from 4.9 to 4.1, because we have to align with LTSR components in 7.15 LTSR environment.
…