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).

Is there a single common field between tab1 and tab2? Is it tab1.ID and tab2.Dataset_ID?

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)

That's how it should be.