Search results for query: *

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?

lbass, Thank you for your answer/help! Your suggestion makes sense, but can you point me to the spot where I can perform the left join? Can I do this somehow in the "Links" tab of the Database Expert? -Roger H.

In Crystal Reports 10, is there a way to include records in a report, even if it is 'null'? (Not even sure if I'm using that term correctly). I'm trying to get CR to give me a report that lists everyone in a specific division, then tell me the dates that they took a certain class, AND/OR tell...

Ken, What a great idea! I'll try that as soon as I get into the office tomorrow. Thank you Ken! -Roger H.

lbass, Actually they DO allow VPN, so I'll give that a shot...thanks for the suggestion! Turkbear, I didn't realize I could do the MS Access thing...I will try that as well, if nothing else, to always have copies! Thank you! -Roger H.

Turkbear, Thanks for the suggestion! Is there a way for Crystal Reports to somehow help me create the database table on my laptop? (The database is actually hosted on a windows server, and the hosting folks could only give me a back-up copy, which they explained could only be opened via an SQL...