Adding a table and editing selection formula

[jawon]

I use CR 8.5 and have an existing report to which I need to add another table and edit the selection formula. So I added the table and created the link in the Visual Linking Expert. Then edited the selection criteria by going to Report > Edit Selection Formula > Record.

But when I try to run the report I get an error stating that the variable I added to the selection formula "does not match with a table name or alias name used in the query".

I checked the sql code and it seems the table and link I added in Visual Linking Expert did not make it to the code, even though I see it in the VLE. Am I missing a step?

 

[synapsevampire]

Consider posting the record selection formula.

I'm guessing that you're not referencing the field correctly (has nothing to do with variables).

The joins will not demonstrate in Crystal if Crystal deems them useless, meaning that you join a table but don't use any columns in the table.

Consoder posting your environment (verion of CR/database)and intent, rather than a vague text description of what is failing.

-k