Recent content by snejsnej

Hi everyone, adalger's suggestion did the trick... thanks! J

Hi Macropod, I actually gave that a shot after your first suggestion... didn't work either though. Thanks again, J

Hi macropod, Sorry, no luck with that one. Appreciate the stab at it though. J

Hi there, I have a macro that does a pretty good job at outputting cell values in one column to a text file, with the values delimited by a semi-colon. However, the values all have a hard return such that each value is on another line in the txt file. How can I get it so that all values are...

The design of the report makes it difficult to group on the patient since there are different categories. I posted a screen shot here (the patient data is bogus): http://img258.imageshack.us/img258/1224/reportgt6.jpg I may have to follow your suggestion anyway b/c this is too big of a headache.

I spent a bit of time trying out command objects and it looks like this will be the only way to go. But: is there a way to use the already-existing dynamic parameters in a c.o.? I have the 'last-name / first-name' dyn params that I'd like to use if at all possible. There is a more 'profound'...

There is only 1 record per PatientID, so if I can incorporate the PatientID into my SELECT statement, that would probably take care of the issue. I've tried to do that already but had no luck; I don't know how to pass the PatientID to the statement. Everything I've tried has either been...

The problem is that I can't know which record I want until the user makes a choice from the drop down list at runtime. So for SQL to be able to pull the right record, it seems to me that this parameter needs to be given dynamically to SQL after the patient's last / first names are chosen by the...

Thanks LB-- Apologies if I'm still misinterpreting your question... The record to be displayed is determined solely by the PatientID. However, because the user can't relate to the PatientID (simply the PK of the PatientInfo table in SQL), the user selects from the drop down lists listing the...

The record to be displayed is determined by the dynamic parameter drop down lists.

lbass: this is being created in the SQL expression area. The purpose of the SQL expression is to return a single result - the OutcomeCodeName - for the patient whose last and first names were selected from dynamic parameter drop down lists. The problem that I'm running into is that the...

@lbass: Thanks for your input. Does my last post give you some insight as to what I want to do?

Sorry for the late reply: @synapsevampire: Here's the expression: (SELECT TOP 1 (OC.OutcomeCodeName) FROM lu_outcomecode OC INNER JOIN PatientArrival PA ON OC.OutcomeCodeID = PA.PatientArrHOBNotMetCode) The statement works fine except when "PA.PatientArrHOBNotMetCode" contains a "0" (zero)...

I tried using TOP 1, but it didn't work. >> Your dynamic parameters have NOTHING to do with the SQL Expression. OK, but then how are the multiple results filtered in CR XI? The following query (I took out MAX because it was wrong) returns ALL records that have an OutcomeCodeName to CR XI--...

Appreciate it, thanks. Would you mind clarifying a point re parameters? Specifically, I don't understand why more than one record is being returned despite the use of the dynamic parameters. If there were 2 "John Smiths" in my db, then it would be clear; however, my test db only contains a...