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

No, I've used it w/out quotes a bunch of times in a command line.

It works. Thanks. Weird, though. I've run a ton of reports with that same parameter referencing the same field and I haven't had to do that before.

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

Still a no. It is selecting the maximum date and if there are two different episodes with a diagnosis on the same day, it returns two, buts its not returning for anything but the maximum date, regardless of whether there are other episodes for which a diagnosis was and should have been given...

So here is what it would look like if I pulled all the dates from the database: PATID EPISODE_NUMBER DATE_OF_DIAGNOSIS 1111 1 8/9/2007 1111 1 6/3/2006 1111 1 6/1/2004 1111...

Of course. This is what I'm hoping to see. PATID EPSIODE_NUMBER DATE_OF_DIAGNOSIS 11111 12 12/31/2006 11111 11 11/7/2004 111111 9 1/3/2003 22222 1...

Sure. Thanks. PATID EPSIODE_NUMBER DATE_OF_DIAGNOSIS 11111 12 12/31/2006 11111 11 12/31/2006 11111 9 12/31/2006 22222 1 6/5/2004 33333 2...

Oh - also - the report isn't returning only the last date and corresponding service. For a lot of clients, it returns several service records.

Not sure if I get what you're asking. Let me see if I can be more clear. A client can get more than one service and any time they start a new service it is assigned an EPISODE_NUMBER. They may or may not be given a diagnosis with each service (sometimes they got a diagnosis with a different...

Ok - so it mostly works, however, when a client has more than one service, it is filling in the most recent date in each of the service areas. This is a sample of how it looks Client Service # Date 11111 12 12/31/2006 11111...

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

Actually, the second try eventually worked, though it took a really, really long time. After I stopped it the first time, I started it again and then just let it keep running and went on to other things. 2.5 hours later I left work and kept it running. When I got in this morning, it was done...

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

I figured it out. Highlight the data you want to flip, create a new worksheet, highlight a column, right click for "paste special" check "transpose" and there you are.

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

The solution was really easy. I added a summary field that gave me a distinct count of the places where services had been delivered and then used the "Group Sort Expert" on the toolbar. Then I sorted the group by client id on the summary field.

Sure. I'll get to a full response on Monday. I'm not in the office today and not by crystal reports. In the mean time, there is a button on the toolbar - something along the lines of "order by" or "ordering expert" Once in there, it was just a matter of pulling down the field I wanted to...

Nevermind. Just figured it out. Apologies (and thanks) to all who took the time to read my post.

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