General discussion

Locked

Exists command in Crystal Reports

By aduran ·
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.

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by william In reply to Exists command in Crystal ...

what result do you intend to get? Can the operator "in" can be of any help!

Collapse -

by md_hashim In reply to Exists command in Crystal ...

"if" "equal to" also works...

Collapse -

by md_hashim In reply to Exists command in Crystal ...

"if" "equal to" also works...

Collapse -

by aduran In reply to Exists command in Crystal ...

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.

Collapse -

by Cheryl.baker In reply to

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.

Collapse -

by vithal01 In reply to Exists command in Crystal ...

Hi,

U have to keep one comman field with existing table for link.

then check it

Collapse -

by Cheryl.baker In reply to

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

Back to Desktop Forum
7 total posts (Page 1 of 1)  

Related Discussions

Related Forums