Issue – My BI developer informed me; They are no longer able to connect oracle data sources they have created in their cube. Troubleshooting – As I am aware; In order to connect to Oracle; you should have oracle client installed properly. As it was working earlier hence my first impression was; they definitely have… Read More Issues related to Oracle Client in SQL Server.
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