Results 1 to 5 of 5

Thread: Formula in CR [RESOLVED]

  1. Sep 23rd, 2005, 01:28 AM #1
    psychofoo
    psychofoo is offline

    Thread Starter
    Member psychofoo's Avatar
    Join Date
    Jun 2005
    Posts
    48

    Formula in CR [RESOLVED]

    hi, can someone help me to do this...

    i have 2 tables in my database, table1 (agent table) which contains all the information about agent and table2 (commission table) which has the commissions of the agents. what im trying to do is to get the name of the agent in the agent table where the the Agent ID is equal to the Agent ID in the commission table which is my reference table... can someone help me about the formula or any other way how will i do this... thanx! btw, im using CR 8.5
    Last edited by psychofoo; Sep 25th, 2005 at 09:32 PM.
    Reply With Quote Reply With Quote
  2. Sep 23rd, 2005, 02:21 AM #2
    pnish
    pnish is offline
    Frenzied Member pnish's Avatar
    Join Date
    Aug 2002
    Location
    Tassie, Oz
    Posts
    1,918

    Re: Formula in CR

    Why not just put both tables on your report and link them by Agent Id?
    Pete

    No trees were harmed in the making of this post, however a large number of electrons were greatly inconvenienced.
    Reply With Quote Reply With Quote
  3. Sep 24th, 2005, 04:12 AM #3
    psychofoo
    psychofoo is offline

    Thread Starter
    Member psychofoo's Avatar
    Join Date
    Jun 2005
    Posts
    48

    Re: Formula in CR

    thanx for d reply... d problem is i have 3 agent id on the commission table... whenever i get the name of the agent for agent ID 1, the same name will be displayed in the name of agent 2 and 3... i dont know how to select in crystal...
    Reply With Quote Reply With Quote
  4. Sep 24th, 2005, 12:31 PM #4
    brucevde
    brucevde is offline
    PowerPoster
    Join Date
    Oct 2002
    Location
    British Columbia
    Posts
    9,758

    Re: Formula in CR

    You cannot use Formulas to retrieve a record from the database.

    Link the Commissions table to the Agent table 3 times, once for each Agent Id field.
    Reply With Quote Reply With Quote
  6. Sep 25th, 2005, 09:32 PM #5
    psychofoo
    psychofoo is offline

    Thread Starter
    Member psychofoo's Avatar
    Join Date
    Jun 2005
    Posts
    48

    Re: Formula in CR [RESOLVED]

    Thanx... it works!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width