Desktop

Ask something
Discussion Locked

Exists command in Crystal Reports

0 helpful
7 replies

by aduran

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I was trying to use the EXIST command in Crystal Reports but was informed that it is not supported. Does anyone know a work around to this or what other code I could use.

7 replies

by aduran

I am trying to pull information from a table if it exists. For example I want to be able to pull the dates that one of our employees went to see a client during the month of December and any comments that were made. The table that that the comment are in only has an entry if a comment was made. If there was no comment made there is nothing in this table. This is why I was trying to use the exist command.

by cheryl.baker

Did you get an answer to your question? I am having the same issue where a table has multiple entries and I only want one record if any of them are selected. 'and exists' is how I programmed this in SQL.

by cheryl.baker

I am having the same issue where a table has multiple entries and I only want one record if any of them are selected. 'and exists' is how I programmed this in SQL. I have a field that is common between the tables.
Thanks

This discussion is closed to new replies.