Tag: reporting services

The server principal “XYZ\USER” is not able to access the database “YourDBName” under the current security context

My Development team contacted me and said they are not able to access database  “The server principal “XYZ\USER” is not able to access the database “YourDBName” under the current security context” when I looked into server server I found – Login was there and access was granted. When I looked into database I found user… Read More The server principal “XYZ\USER” is not able to access the database “YourDBName” under the current security context

learnsqlteamLeave a comment

SSRS – How to convert in Day/Hour/Minute format in SSRS report

Scenario – In my SSRS report I have calculate Age field of Tickets like in 1 Day 2 Hours 20 min format and we are getting values in minute . Solution – I have created filed called Age(Minutes) in my SP or query IN SQL – datediff(minute,date_created, getdate()) as ‘Age (Minute)’ IN SSRS write expression =  (… Read More SSRS – How to convert in Day/Hour/Minute format in SSRS report

learnsqlteam3 Comments