SSRS Strip Domain from User!UserID

By -
In SSRS, if you want to be fancy and display the USER NAME in the header or footer of your reports, like what I do.  SSRS uses Domain\UserName format... So someone this morning was asking in the forums about how to strip the domain out.

So I provided two solutions...


="Welcome " & MID(User!UserID,InStr(User!UserID,"\")+1, Len(User!UserID))

="Welcome " & =right(User!UserID, InStr(StrReverse(User!UserID),"\")-1)

Hope that helps someone...

                                           

Comments

  1. Mark weinsMarch 29, 2020 at 9:01 AM

    Merely wanna state that this is very beneficial , Thanks for taking your time to write this. webflow developers

    ReplyDelete
  2. TabatSeptember 21, 2021 at 12:40 PM

    You might comment on the order system of the blog. You should chat it's splendid. Your blog audit would swell up your visitors. I was very pleased to find this site.I wanted to thank you for this great read!! creative business names

    ReplyDelete

Post a Comment

Popular posts from this blog

Run a VBscript using SQL Server.

By -
Image
Today I came across a question in EE  of how to run a VBscript using SQL server. Well, it could be done using the SQL server agent or using SSIS, but the easiest way would be the SQL agent. Here how: 1-Right click on "SQL Server Agent" and select "New Job" 2-Name the job according to your needs. 3-From the "Steps" , select New. 4-Name it to your needs and select the "Type" as "Operating System CmdExec" as shown in the screenshot. 4-Set the schedule as desired and that's it!!
Read more

Practical Web Scraping with Python: A Clean, Safe Pattern for Pulling Company Names & Emails

By -
Image
Practical Web Scraping with Python: A Clean, Safe Pattern for Pulling Company Names & Emails Turn that quick-and-dirty script into a reliable tool you won’t be afraid to run twice. Meta description suggestion: Learn a production-friendly pattern for scraping company names and emails with Python, Requests, and BeautifulSoup—featuring retries, timeouts, robots.txt checks, pagination, and CSV export. On this page The problem The cleaned, safe solution Copy-paste code How it works How to run it Practical use cases Pitfalls & guardrails Variations & alternatives What to try next The problem You’ve got a page of companies and you want the name and email for each one. The “first pass” script might work on your machine, but it’s brittle: no retries, no timeouts, no robots.txt check, and it assumes every email is a mailto: link. The cleaned, safe ...
Read more

SSIS to Sybase OLEDB connection error [IM002]. [Native Code: 30136]

By -
Image
Hi, I was getting that nasty error message, although you could test the OLEDB connection from the Sybase “data source configuration” and gets a success notification!! [IM002] [Native Code: 30136] [ASEOLEDB]Data source not found and no default driver specified   I also made sure that the OLEDB connection are there and configured well under 32 BIT and 64BIT, and the Sybase “data source configuration”  gives a success message when I test them.   So I thought the error is relevant to SSIS and it’s permuissions, not the Sybase, I started investigating the service account that SSIS is running under and if it got access to the C:\Sybase\DataAccess64\OLEDB\DataSources As Sybase ASE 15.5 was installed on my root drive C:\ and I’m using win & 64 BIT. I'd the same setup and configuration working on a vista 64 bit, but found other posts online about the driver and it is working well on windows 7. The full error message is:   TITLE: Microsoft Visual Studio -------...
Read more