TechRepublic|Forums|Desktop

Desktop

General discussion

  • Creator
    Topic
  • November 1, 2005 at 8:39 am #2190866

    Exists command in Crystal Reports

    Locked

    by aduran · about 17 years, 7 months ago

    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.

    Topic is locked This conversation is currently closed to new comments.
  • Creator
    Topic

All Comments

  • Author
    Replies
    • December 11, 2005 at 9:45 pm #3121017

      Reply To: Exists command in Crystal Reports

      by william · about 17 years, 6 months ago

      In reply to Exists command in Crystal Reports

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

    • December 12, 2005 at 10:10 pm #3197836

      Reply To: Exists command in Crystal Reports

      by md_hashim · about 17 years, 6 months ago

      In reply to Exists command in Crystal Reports

      “if” “equal to” also works…

    • December 12, 2005 at 10:11 pm #3197835

      Reply To: Exists command in Crystal Reports

      by md_hashim · about 17 years, 6 months ago

      In reply to Exists command in Crystal Reports

      “if” “equal to” also works…

    • December 14, 2005 at 8:34 am #3121434

      Reply To: Exists command in Crystal Reports

      by aduran · about 17 years, 5 months ago

      In reply to Exists command in Crystal Reports

      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.

      • September 23, 2008 at 12:54 pm #2802911

        Reply To: Exists command in Crystal Reports

        by cheryl.baker · about 14 years, 8 months ago

        In reply to Reply To: Exists command in Crystal Reports

        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.

    • May 25, 2008 at 9:57 pm #2450024

      Reply To: Exists command in Crystal Reports

      by vithal01 · about 15 years ago

      In reply to Exists command in Crystal Reports

      Hi,

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

      then check it

      • September 24, 2008 at 6:29 am #2802648

        Reply To: Exists command in Crystal Reports

        by cheryl.baker · about 14 years, 8 months ago

        In reply to Reply To: Exists command in Crystal Reports

        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

  • Author
    Replies
Viewing 4 reply threads