Desktop

Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!

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.

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

Related Discussions

Related Forums