Search results for query: *

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.

...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 am using. =sum(Fields!Duration.Value) / (count(Fields!v_PROVIDER_NAME.Value) *8)...

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

...appreciated. Msg 241, Level 16, State 1, Line 1 Conversion failed when converting date and/or time from character string. select Audit_Tool.* from (select patientid, max(EntryDate) as EntryDate from Audit_Tool group by patientid) as lastest_entry inner join Audit_Tool on...

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...

Hello, I am trying to display the digital signature image on a crystal report and I'm having no luck. I am running CR 2011. I have tried changing the location of the graphic to the database field but the original graphic still shows and not the signature. I placed the field on the report and...

Thanks sqlbill, I actually did have the parameters in the code but removed them because they did not work. I left them in the top section to show which parameters I was trying to use. I placed them in each section of passes but they did not give me the results from each parameter. The only...

The was originally written to work with a crystal report and now I have to switch it over to work with Reporting Services. The date and coverage parameters work fine but I cannot get the report to accept the other 3 parameters I need to add. I tried to add them through reporting services but...

I forgot to add that I am trying to call @service = billing_proc_code, @protocol = protocol_id and @staff = billing_clinician_id. Thanks

...new to stored procedures, having only written basic ones. If anyone can assist me I would greatly appreciate it. Below is script: USE [rpt] GO /****** Object: StoredProcedure [dbo].[psp_19501_extract_financial_data2] Script Date: 04/20/2013 07:04:37 ******/ SET ANSI_NULLS ON GO SET...