Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Location
    Mumbai,India.
    Posts
    7

    Unanswered: SQL + Crystal Report's Query

    Hi All..I think this problem maily from database side then Crystal Reports...
    So,I am using MS SQL 2000 Database .... In that I have tab1 and tab2 tables in DB_tab database.
    tab1 is having fields:ID,End_A,End_B,Discri.
    tab2 has dields : Date,HH<MM,SS,Dataset_ID,Util

    Now I want to display as follows in my crystal reports.....
    concate ID & End_A of tab1 and store result in var1
    and using this var1,using MM as a criteria in tab2.......
    I want to display util from tab2,for all End_As & End_Bs......Can any 1 help me on this????
    Thanks in advance....
    Chandresh (India).

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Is there a single common field between tab1 and tab2? Is it tab1.ID and tab2.Dataset_ID?

  3. #3
    Join Date
    Apr 2004
    Location
    Mumbai,India.
    Posts
    7
    HI rdjabarov,
    No, ID and DatasetID is totally different,having different meaning and usage.And if its necessary,and if its gonna help me the I can add a colume in either of the table as per requirements.Then is it possible???
    Thanks in advance...
    Chandresh (India)

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    That's how it should be.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

Posting Permissions

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