Microsoft Server OS

57K

Solutions

41K

Contributors

The Microsoft Server topic includes all of the legacy versions of the operating system, including the Windows NT 3.1, NT 3.5, NT 4.0 and Windows 2000 and Windows Home Server versions.

I have a SSRS report where in one text box I want to only display part of the FIELD that populates the textbox.
For example, if the text in the field is "LASTNAME, FI - ID", I want to display only "LASTNAME, FI". So in the query I have Select LASTNAME + ', ' + LEFT(FIRSTNAME,1) + ' - ' + ID.
I can't just change the SELECT statement to leave off ID because I need that for grouping and sorting.
I changed the placeholder properties to recognize HTML tags
Something like:
Select LASTNAME + ', ' + LEFT(FIRSTNAME,1) +<font size= "3">' + ' - ' + ID + '</font>'
works, but I can't find a way to hide the ID
I tried:
Select LASTNAME + ', ' + LEFT(FIRSTNAME,1) +<div style="visibility:hidden">' + ' - ' + ID + '</div>'
References say that only certain inline CSS attributes are supported, so visibility must be one that isn't.
Any ideas, other than using one field for sorting and another for display.
0
Hi,

In ssrs I get diff from two dates.
How do I get also hours and minutes (now some results show 0 since diff is hours minutes only.

Thanks!
0
Hi,

I'd need a sql query to color code a date:
Items = status NOT equal to 'Status01', 'Status02'
For all items which have date less then a week => green
older then a week => orange
older then 2 weeks => red
Items which have Status Status03
and have date
older then 2 weeks orange
older then a month red

Thanks for helping with the approach!

J
0
Hi,

I mail my ssrs report on a daily basis. Opening it in mail (mobile device) takes 30 seconds, so people think the mail is not working and delete it.
Also loading it on Windows, it still takes like 3 seconds to load.
How can I make my report more leightweight?
Suggestions: show less items on a page (there are a few 100 rows now, howto?), leighter formatting (like I have gridelines for better visibility ... howto?) ...?

J
0
Hi,

I have an SSRS KPI in which I have totals like the following expression:

=Sum(IIf(Fields!StatusName.Value = "Status01", 1, 0))

Now, how do I make more difficult queries: like
sum of all items where statusname.value = status02 and status03 but not empty status but also status06,status07

J.
0
The group I work for has acquired a company, where an external consultant isn't playing ball with handing over the keys to domain admin which we now look after internally.

Could someone point me in the right direction, we need to recovery the domain admin credentials.

Any advice would be great.

Looking for a simple way as possible even it it involves software

Ian
0
Hi,

I have an ssrs report for a ticketing system which has names, ticket number etc.

I d like to add several filters:
-show my tickets = filter on username, all tickets
-environment: UAT/PRD
-statuses: open/not resolved, closed

This way a user of the form can see/filter on only specific data like.his requests which are open in prd

Please advise.
J
0
I am using this data set query that is generating error , The dated diff function requires 3 arguments(s). Incorrect syntax near Label 1. Incorrect syntax near 'Group Order'. The Query generates data for a DemographicsPar2(parameter. I am building a ssrs has board that uses this parameter.

SELECT DISTINCT 
                  'Age' DemographicGroup, 
CASE 
WHEN DATEDIFF(YY, DOB, @ReportDate) < 25 THEN '<=25'

 WHEN DATEDIFF(YY, DOB, @ReportDate) BETWEEN 25 AND 35 THEN '26-35' 
WHEN DATEDIFF(YY, DOB, @ReportDate) BETWEEN 36 AND   45 THEN '36-45' 
WHEN DATEDIFF(YY, DOB, @ReportDate) > 45 THEN '46+' END Label, CASE 
WHEN DATEDIFF(YY, DOB, @ReportDate) < 25 THEN 1 
WHEN DATEDIFF(YY, DOB, @ReportDate) BETWEEN 25 AND 35 THEN 2 
WHEN DATEDIFF(YY, DOB, @ReportDate) BETWEEN 36 AND 45 THEN 3 
WHEN DATEDIFF(YY, DOB, @ReportDate) > 45 THEN 4
END GroupOrder

INTO        #Demo2
FROM     [dbo].[Dim_Borrower]
UNION
SELECT DISTINCT 'Marital Status', MaritalStatus, 1
FROM     [dbo].[Dim_Borrower]
UNION
SELECT DISTINCT 'Race', Race, 1
FROM     [dbo].[Dim_Borrower]
UNION
SELECT DISTINCT 'Sex', Sex, 1
FROM     [dbo].[Dim_Borrower]
                      SELECT *, DemographicGroup + ' - ' + Label RealLabel
                      FROM     #Demo2
                      WHERE  DemographicGroup IN (@Demographics1)
                      ORDER BY DemographicGroup

Open in new window



When I run this query on the SSRS query Designer, the output shows Three columns. DemographicGroup / Label / GroupOrder/ Real Label ..
0
Hi,

I have an ssrs report which I would like to make dynamical (like a Powershell Crusties): when you click ok a column of sorts, when you search, it filters, ideally have also search filters and some nice formatting too (now it is a boring formatting).
One more thing: can I link to another ssrs report (clickable link)?

J
0
Hi,

I have a GUI which talks to a sql db backend via powershell and sql queries.

I execute queries remotely but now discovered stored procedures and views.
Created some views and a stored procedure.

What is the specific purpose of each item, the difference and what should I use for my gui?
Also, can I use the view for ssrs report?

J
0
Hi,

I have been asked to evaluate/review approximately 150 servers on our network, ranging from Server 2008 to Server 2019 list in  a spreadsheet with very limited information.   Just primary roles. (e.g. DC, DNS, RODC, SCCM Distribution Point, File and Print server, etc.)   It also lists Hyper-V, Hyper-V on workstation, etc.  

I don't have the owner information so I can't reach out to each and ask "what is this and what's it for?  The objective is to go through this giant list and label each with a "priority #" to either decommission it, upgrade the existing OS, determining the utilization of each server, apps installed, roles installed, etc.   I then need to be able to share my findings with the rest of my team so we can then determine the effort necessary to migrate, upgrade or decommission the server(s) as we look forward to our newest 2016 functional level infrastructure.  Fro example, there are 14 RODCs at branch sites, but Sites and Services is not configured properly, so that could be a priority #1 (through 5) for us.   How do you experts approach these types of tasks and projects?   What do you break things down to and label it as to what should happen to each server and where it should reside, e..g Azure.

Thanks for any information you can provide.
0
Hi all,
How can set group policy for wallpaper for all client PC.
I have configured but some time it is going to black screen. because I kept wallpaper in shared folder.
please suggest how we can avoid this issue and suggest me.
Any other group policy suggestion.
0
I am proposing a major upgrade for one of my clients.

Up till now, we have been using a 3rd party registrar for business emails. Lately my client continues to ask for additional emails accounts to be setup - exceeding our purchased quota. I have also been pressed for synchronization on inboxes with iphones. For the time I have been configuring via IMAP.  Needless to say, they have out grown this basic email package.

Yes I have considered Office 365 Business, and Premium w/ Exchange, but, I want to investigate my options in-house. I can't seem to get past that reoccurring annual charge.

We currently have a 1 Dell PE R320 running Windows Server 2012 R2 Standard. There are 13 users in the office environment, 10 out in the field.  We have a 3rd party business application running off of SQL on this same server. Our system comes with the ability to created 2 VM'S, running the Server 2012 R2 Standard. I'm thinking great, I don't have to spend another 2,500 on a server, I'll use what I already have. Then I read the following on Microsoft:

•      Only management software (for example, antivirus software, backup software, or virtual machine management software) can be deployed on the physical host machine. No other server-based applications (for example, Exchange, SQL Server, Active Directory, or SAP) should be installed on the host machine. The host machine should be dedicated to running guest virtual machines.

So, that is the warning. Has anybody actually tried to do this, …
0
Hi, is there anyway to Stop SSRS from Building ALL reports when Previewing in Visual Studio ?

Many Thanks
0
I have a situation where I have incorrectly added a 2nd Domain Controller certificate ( for server, and client authentication purposes), and i think this is causing me problems with LDAPS authentication ( from some external java applications - using LDP locally works fine, and can bind to SSL on port 636)

See attached picture.

certificatesThe Certificate with the expiry date 04/02/2021 is the one is have just created ( and would like to keep )
The Certificate with the expiry date 05/06/2020 is the certificate that was originally installed.

The only other relevant information is that this domain controller was migrated from SBS2008, and the CA root certificate was migrated over.

So - is it safe simply to delete the expiry date 05/06/2020 certificate in Certificates MMC, or is there anything else i need to do / not do !
Thanks
0
My organization is currently using SCCM version 1902.

We have some Windows 7 machines and Windows 10 initial install machines that both need to be upgraded to the latest version of Windows 10 using SCCM.

All of these computers are joined to the Active Directory domain and have the SCCM client installed.

SCCM is currently configured to load the latest Windows 10 operating system to computers and virtual machines using PXE boot. Now we need to upgrade these existing Windows operating systems to Windows 10.

What are the steps to upgrading these existing operating systems to the most current version of Windows 10?

SCCM Operating Systems
0
I recently moved SSRS to a new server.  The migration went fairly well and most of the reports are running fine on the web server.  I've been going through each project to point the project  to the new report server location and then updating the connection string on shared data sources to again point to the new server.  Almost all of my data sources point to one of 2 catalogs (one for finances and one for fundraising) and I have successfully updated many of the projects without an issue for both catalogs.  However, I have a folder that uses both data sources.  I've made all the changes to point to the new server and when I test the connection string, it is successful.  However, if I try and run the query for the financial data source, it errors out with the following error (last paragraph).  If I turn on the old SSRS server, it works fine.  I've checked and double checked that everything points to the new server and it does.  Again, this data source is used in other projects and works fine there - just not in this one project.  I've even deleted and recreated the data source and it still won't work.  I can't figure out what the problem is... and feel the error is misleading.  

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - …
0
I am setting up a new Windows 2019 Server for a customer.  The way I was taught in the past was to add the role of DNS server to the DC and use the router for the DHCP to the PCs.  I have done it successfully on several servers but it seems convoluted and possibly not correct and efficient.  I do have one customer where the DC is both the DHCP server and DNS server and have not had any issues.  The DNS is configured properly with the interfaces and forwarders and DHCP turned off in the SonicWall.  DHCP is configured with the scope and all of the correct parameters.  I would like to get some opinions as to which way to go.  It seems to me it would be best practice to allow the DC to do both.  What are the pros and cons (if any) using this method?
Thank you in advance,
Phil
0
New HP Proliant ML350 Gen10 server - doesn't have a dvd reader
Obtained ROK with Windows Server 2016 Essentials it came on DVD.
HP suggested using their USB key utility - but it wouldn't work with the DVD -even though the dvd is readable / tried multiple computers.
Copied DVD contents to local folder, then created ISO using freeware.
Used Rufus to make a bootable USB flash using the ISO.
HP intelligent provisioning won't recognize the flash, or the same iso on another flash.
Started to boot direct from the flash but errors with  'windows could not collect information for [OSImage] since the specified image file [install.wim] does not exist.
Hours spent on this and multiple calls to HP have yielded no success.
Is there a foolproof way to create a USB flash from this ROK that will work?
0
I would like to create a Virtual Directory that points to a PDF or Image file on our active directly drive which is mapped on the IIS server. So when someone follows the link it will pull up that PDF or Image.

Example:
G:\Image\Maps.jpg
G:\PDF\MyFile.pdf

Thanks

Here is the error I currently get:  Capture.JPG
0
I was having a heck of a time trying to create a report in Visual Studio 2017.  I removed references to version 9 and installed 150.1400 from nuget and added the references back.  I was never able to get a report viewer onto a form.  It always ended up at the bottom as a component like the timer or backgroundworker.  I uninstalled 2017 and installed 2019 after hours of unsuccessful google fu trying to fix it.  2019 allows me to drop a report viewer onto a form but I am missing the add new item - report option.  So now I can drop a report viewer onto a form but I can't add an RDLC to my winforms project.  I may go back to VS 2010 where things just worked...This is crazy frustrating.

Any ideas on getting the report creation option into the menu?

Thanks
screen shot references
0
What other "microsoft.com" website do you recommend besides the below to get a patch HISTORY list ?

https://portal.msrc.microsoft.com/en-us/security-guidance
0
Hi,

I d like to have a daily or weekly sql ssrs report of ALL software users have on their pc (add/remove programs?) by querying our sccm 2012 server (latest version) plus number of installs per item/preferably also clickable that it shows the list of pcs per software.
Nice would also be to map it to sccm.itself: do.we have it in sccm (or was it installed nu user manually).

I d like to be able to exctact the data in Powershell so I can work with it. F.e. $alllsoft | get top 10 foreach ...

Thanks!
J
0
I have 2 windows servers that are part of a workgroup and sitting on a VLAN behind a ferewall. I want to sync time on these 2 servers to a domain controller sitting on another VLAN on the other side of the firewall. Is this possible and if so how do I do it? Or are there better alternatives??
0
I moved my SSRS application to a new server.  My last step was to get my SSL certificate working for the new server.  I’ve done quite a few, but cannot get this one to work. It is through Godaddy and I’ve talked to them several times.  Today I was told that they aren’t training in certificates for IIS so they can’t help me.

I’ve followed the instructions in this article:  
https://www.godaddy.com/help/manually-install-an-ssl-certificate-on-my-iis-8-server-4951

But there is some misleading steps and I don’t know if that is why it isn’t working?  Step 14 says to upload the intermediate (.p7b) to MMC.  I’ve done that.  The next steps are in IIS and on step 22 it says to find your primary certificate that you previously uploaded.  There aren’t any steps that say to import it on MMC so I’m not quite sure what that means.  I complete the install of the primary certificate (.crt) on IIS and then do the bindings.  I then restart the services.  But the website never works.  On IIS everything looks ok.  I’ve actually started the old server and compared what I see in the 2 servers and they look the same.  I’m not sure what to do?  Any thoughts??
0