Search results for query: *

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

Thanks for your reply synapsevampire. The John Smith problem is an issue, I will likely need to add one more dynamic parameter (for the birth date, say). I'm using SQL Server 2005, CR XI R2, ASP.NET 2.0. The SQL Expression: (SELECT "OC"."OutcomeCodeName" FROM "lu_OutcomeCode" "OC" INNER JOIN...

Hi there-- I'm dealing with a two issues: 1) SQL Expression evaluation My report has a number of SQL Expression Fields that CR XI is evaluating at design time. That is, when I save a SQL Expression, it immediately checks it for syntax errors AND runs it against the database. However...

Sorry, I'm running VB.NET 2003.

Thanks Christiaan, I did it and it worked, so that's good news. However, the not-so-good-news is that I am getting an error on all of them, the drop downs and the textboxes, any idea why this is? Specifically, it's saying "error: cannot obtain value". It seems like it should be a...

Thanks ThatRickGuy, I tried your suggestion with ?dataaccess at the command window prompt, but it's telling me that the command is invalid. I tried the command in a couple different case permutations just to be sure, but no luck. In any case, there's a default value for all the drop downs...