Post Author: PaulyWally
CA Forum: Formula
I'm very new to Crystal, so this is probably rudimentary. But I do have programming and SQL background.I'm trying to alter a report that someone else made. To put it simply, the report selects records based on the values of: TABLE_A.FIELD_X and TABLE_B.FIELD_Y.I need to change it to select records based on the value of TABLE_A.FIELD_X and TABLE_C.FIELD_ZThey do have record selection criteria set up in the formula workshop for TABLE_A.FIELD_X. But that is all I can find.When I view the SQL statement, I see something like this in the WHERE clause:WHERE table_a.field_x='selection_criteria' AND (table_b.field_y=N'selection_criteria')There is a lot more to the WHERE clause... but what is throwing me off are two things:1.) Where can I find where to change the record selection of TABLE_B.FIELD_Y?2.) And what are those N' things? I have a feeling those have something to do with it since I don't see them in the TABLE_A selection criteria - which is available in the formula workshop.Thanks!