Recent content by rharness

Perfect, thank you dgillz!! Obliged, -Roger Harness

CR Pro 10.0.0.533 I'm trying to show all instances of employees who've taken Defensive Driver Training. Unfortunately, quite a bit of this training has been entered into the database in various ways, with different course codes, and different class names. I'm trying to get records selected...

Understood lbass. Hopefully at some point I'll at least figure out exactly which tables to use (and populated) and I'll revisit the forums and see if anyone is still willing to help :) Thanks again! -Roger H.

CR85user, I think I understand what you mean re: the wizard! And actually I just spoke to the LMS vendor tech support, and he said that actually the learning_plan table isn't going to help me, as we're not even utilizing Learning Plans in our database. He seems to think I may not even be able...

lbass, I was actually using the report wizard, so I'd select the tables, then let the wizard link them together. Then the only thing I'd change is the person ID by switching it from whatever default join it currently is, to the 'left outer join', per your suggestion. Is this not the way that...

Hmm...I think this may be part of the problem, as when I try to add fields from another table, without using any formulas or the outer-join stuff, *nothing* prints! However, I just heard back from our LMS vendor and they said I should be using the registration_style_view, person, and...

lbass, Thanks for hanging in there with me on this. Ok...how's this? To get the following, I'm only using the registration_style_data table for these results. Division P_Unique_Key Last_Name Course_Code Class_Name End_Date 37 LAM 1166 Lampinen HSI 552 Bloodborne Pathogens Training7/19/2006...

lbass, Sorry, I think I mis-understood the request. Ok...here's some sample data from the report, using the formula you provided. person_style_view.P_Unique_Key ADA 9775 ADA 9775 ADA 9775 ADK 3501 ADK 3501 person_style_vew.Course_Code PTI 102 HSI005 TRAINING HSI272PST HSI003...

lbass, Ok...this is using the following code in the Formula Fields (which is brought over to the report as the last column titled "all_plus_null": if {registration_style_view.Course_Code} = "HSI 552" and ( isnull({registration_style_view.Registration_Status}) or...

CR85user, Thank you for your help! >>>The logic of your formula is basically saying that if the course code is mentioned then state 'None', what you are instead looking for is firstly those taking/finishing the course and THEN stating the date of those who finished? correct? >>> Yes, what I'm...

lbass, So something like this, correct? NAME CODE DATE Smith HSI 552 10/5/07 Jones HSI 552 10/1/07 Johnson HSI 552 None or something like that, right? I'm getting this: NAME CODE DATE Smith HSI 552 None Jones HSI 552 None Johnson HSI 552 None Do you have any ideas why it...

lbass, That fixed my syntax errors, thank you!! Ok...i think I'm really close now, but still not quite there. It IS listing everyone now, but it's listing "None" for everyone! (I have about 50 people so far who should have dates listed for them). I have nothing selected via the Select Expert...

lbass, I know I'm asking for alot, but I'm getting syntax errors with (missing parentheses) when using this code: if isnull({registration_style_view.P_Unique_Key} or {registration_style_view.Course_Code} <> "HSI 552" then "None" else totext(totext({registration_style_view.date},"MM/dd/yyyy")...

Ok now I'm just trying to get folks that have not completed the class. I'm using person_style_view on left side and registration_style_view on right. I have P_Unique_key linked in both tables by a 'Left Outer Join'. In my formula, I have this: {registration_style_view.Course_Code} = "HSI 552"...

lbass, I know you don't know the entire structure of our database/etc., but what field(s) should I used to make the left out join?