Search results for query: *

I'm working with CR10, SQL server DB. I'm working with two tables. The first (view_episode_summary_current) holds records for any open service. The second holds information for an assessment that all clients should have every 90 days. I want to return the most recent record of that...

I'm using CR10, SQL server DB. I'm getting an error message "Failed to open a rowset... UNKNOWN MSG." Any ideas what I've got wrong. SELECT view_episode_summary_current.PATID, view_episode_summary_current.program_code, View_episode_summary_current.EPISODE_NUMBER...

Working with CR10, SQL server DB. In our business, we see patients and a lot of them get more than one service. They may or may not get a diagnosis for each service they get. They may also have more than one diagnosis for a single service. I want to write a report that returns the most...

I'm working with CR10 on a SQL server DB. I'm working with patient records and I want to bring up the most recent diagnosis for each different service they receive. I wrote the command line: Select episode_history.patid, episode_history.episode_number, episode_history.program_X_type_code...

Hi, I have data that is in rows that I would like to move into columns. Any fast way to do this?

I'm working in CR 10, SQL server DB. I've got a report that returns service records for clients. The details look roughly like this Client Location Date 11111 XXX 9/7/06 11111 XXX 1/2/05 11111 YYY 11/5/05 22222 XXX...

I'm working in CR10 on an SQL server DB. Where I work, clients get a variety of services. If I returned all the serice records for a group of clients, it might look something like this: Client_id Service_number Service_code 100 1 IP 100...

Hi I posted about this about a week ago and the responses I got almost has it working. Here's the original post updated with a couple of things I don't think I was 100% clear on. I am working with a client database. I'm pulling from 2 tables. The first is service_records and that gives me...

Going to try and explain this clearly. I'm working with CR10, SQL server db I am working with a client database. I'm pulling from 2 tables. The first is service_records and that gives me the client_id and service_number. I've got it joined (left-inner) to the assessment_table on client_id...

I am working in CR10. I am trying to get a count of clients who met either of two conditions over the year. I have a formula that basically says If field1 = x then 1 else if field2 = y then 1 else 0 There's no problem with the formula; its returning the expected values. The trouble is...

Hi, I'm working with CR 10 on an SQL server database. I have generated a report that has four items in the details section: CustomerID, Service Type, Start Date, End Date. For some records there is no end date as services are ongoing. What I would like to do, is to have a summary field in a...

I'm using CR 10 with an sql server database. I need to look at table_x and pull Client#, Client_visit, and start_date. No problem Then I need to look at table_y and find any assessment for that client that was done on that start_date or the day after. I'm trying to do this with command...

Hi I'm using vb.net 2003 and have started getting this error message "Unhandled exception of type system.nullreferenceexception object variable or with block variable not set." It gets stopped in this procedure at the line: Private Sub shuffle_source(ByRef image_array As Array,_ ByVal...

Out clients can get a lot of different services at the same time. The only place to go to find out which ones they are getting is in a table "service_records" which lists all the services ever delivered. I want to know which clients are getting one particular type of service - x. Easy enough...

Hi all, Im using CR 10. In my details section, the first thing that I list is the start date of services for a client. Sometimes, a client gets more than one service and I am listing each one. The second thing I list is the date a test was given during those services. Often, the...

Sorry, I'm sure this is a total newbie question as I am pretty much a newbie to this program. When making my report, I want to exclude records that contain the characters "rx" (e.g., 103rx2) and that end in a 3. How do I do this. Thanks

I have two variables in a program I am working on. One is a double, the other a timespan. I want to compare whether one is greater than the other. However, I am having trouble converting a double to a timespan and a timespan to a double (either of which would work for me). Any suggestions?