Search results for query: *

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

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

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

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

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

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

Hello, I am having some trouble adding 3 more Parameters to an already written stored procedure. I have added the parameters at the top already. They are @protocol, @staff and @service. I have tried to fit them in the script but it is either not pulling the data or pulling data I am not...

Hello, I am trying to pull data that is null using the selection expert. I have a report that uses a table that has description fields that I joined with my patient table so I can show the description on the report. The problem I am having is if the actual field in the patient table is missing...

Hello, I am trying to write a report that shows for example: If a client ordered a bike then list all orders for that customer. Can someone help me with this? Thanks

Hello, I am having some issues getting the correct description of fields from another table. I have several fields that I am trying to pull the description of. For ex: I need to pull the description of race, gender, marital status etc. from a global code table. I have tried to add the category...

Hello, I have a comment section that on save and close of the entire form adds comments to a history section on my form. I want to be able to hit enter to add to the comment history section without having to save and close. I have a attached a screen shot of what I am trying to do. If you can...

Hello all, I get this error when trying to submit to my database using infopath 2003. InfoPath cannot submit the form. An error occurred while the form was being submitted. InfoPath cannot connect to the data source. Safety settings on this computer prohibit accessing a data source on another...

Hello, I have a form I created which has rules to mail the form to depending on what choice is picked then after the person gets the email the next step is for them to complete the rest of the form and hit a next submit button which adds all the details to database. This all works fine when I...

Hello First off I am using a cross tab if that helps. I have a select statement here below: Select case {Patient.sex} Case "M" : "Male" Case "F" : "Female" Default : "Unknow" I get no errors, but the problem is this result: Total 0% Male 34% Male 65% Total 100% Why is it only showing...

Hello, i need some help writing a SQL statement. Here is what I am looking to do: I am trying to find a customer serviced at 2 separate locations. so I have select customer from tablename where location is 123 and location is 150. I get zero returns but I know there are results that should...

I was wondering if someone can give me a hand. I have 2 tables. One table has all my clients and the other table has clients that received a certain set of services. I want to join those two tables and remove the clients that received the set of services so that I only get the clients that have...

Hello, I need to add a length of stay column to a report and I am having difficulty formating the output. I was wondering if anyone can help me with this. I have: =Fields!dischargedate.Value - Fields!admitdate.Value Then in properties under format I have tried all the different numbering...

Hello I have in my sql table ex: column name c_gender(in my database gender is displayed as 1 for male and 2 for female) In my report I need to display male or female instead of 1 or 2. The descriptions are in another table column name c_desc. How in reporting services do I keep the value as...

I have a report that is suppose to total the time a service event has. For example: Service provided = 60 minutes or 15 minutes. When I dump my data into sql it changes the datatype into and Integer. So my question is: How do I format the field to Sum up the time correctly if it is reading as...