Recent content by mchambers

I change it to =sum(iif(isnothing(Fields!Duration.Value),1,0)) / (count(Fields!v_PROVIDER_NAME.Value) *8) and all zeros came back.

Thank you for your response. How would I do this in SSRS under the expression? Sorry new to SSRS. I have attached my sample data and groupings.

Hello, I am creating a report that shows all staff productivity for each individual day of the week there are some staff who show a zero on some days and I can’t get the grand total at the end to count the staff Member if productivity is zero. Any help is appreciated. Here is the expression I...

Wow I can’t believe I missed that. It’s been a long morning. Thanks for the catch!

Hello, I am trying to group some rows of data so I get the most recent value. Tried to use a substring but received this error. Any help will be greatly appreciated. Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string. select...

That worked! Thanks!

Hello, I am trying to modify a script where a patient has greater than two episodes of care and I am receiving an error. I've tried changing the script however SQL throws back an error each time. Error - An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a...

That worked! Thank you both! Have a wonderful day.

Hello, Thank you for the reply. The error I receive after running the updated code: Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "bth.PatID" could not be bound. Msg 4104, Level 16, State 1, Line 1 The multi-part identifier "bth.date_of_service" could not be bound. Msg 4104...

Hello, I am trying to write a query to pull patients that have received a service within 90 days of their first services. I have tried running the below code and some other variations and have not been able to get the count. Any help would be great. select bth.PatID, from billing_table bth...

Fantastic idea Pete! Thanks so much!

Hello, Does anyone know a formula I can use to create a new medical record number based off the patient's original MR# I have in my system? I have to de-identify some data and have no clue how I should accomplish this. Here is an example of what I am trying to do below. MR# New# 1 65...

Ok thanks for getting back to me.

It is a SQL database the datatype is text and I am using an OLEDB connection to connect to it.

Thanks so much for getting back to me. The imaged is stored in the database like as text. Here is an example which is only about half the text...