I m having a data Report where i need to show data from TWO (2) tables 1 showing all the fields from 1 table and the conclution field from other table.
the problem is that the conclution is displayed along with every record where as i need to display it only once
the query that i m usign is
SQL = "Select A.* , B.conclution From custdetails A , rpt B Where A.id = 123 ; "
.CommandText = SQL
.ActiveConnection = DENV.Connections("con1")
Set .DataSource = DENV
.DataMember = "cmd1"
.Caption = LVAcList.SelectedItem.Text
plz tell me how do i get the details that i want in my report