title: Duplicated data in crystal reports
body: <p>I am trying to load data from 3 tables in a crystal report.</p>
  
  <p>in each one, I have stored procedures that shows me the following data:</p>
  
  <p><img src="https://i.stack.imgur.com/P9e5u.jpg" alt="enter image description here"></p>
  
  <p>The codes are:</p>
  
  <pre><code>select distinct * from servicios where ID_Orden = @idordenrecibida
  
  SELECT  distinct ID_orden, Consecutivo, Observaciones, Empleado, replace(convert(NVARCHAR, FechaEntrada, 103), ' ', '/') AS FechaEntrada, replace(convert(NVARCHAR, FechaSalida, 103), ' ', '/') AS FechaSalida, Recibe, PrecioFinal
  FROM    OrdenesServicio
  WHERE ID_Orden = @idordenrecibida
  
  SELECT distinct * FROM equipos WHERE ID_Orden = @idordenrecibida
  </code></pre>
  
  <p>(the parameter sent from CR is '8' too in the next snapshots)</p>
  
  <p>And I want to show the same in my report, but the report shows some duplicated results when I call these procedures from CR:</p>
  
  <p><img src="https://i.stack.imgur.com/6kNJJ.jpg" alt="enter image description here"></p>
  
  <p>It shows some repeated values, unlike the real result of the procedure :S</p>
  
  <p>Well, the code in the form is the following:</p>
  
  <pre><code>        OrdenReport oRep = new OrdenReport();
          ParameterField Pf = new ParameterField();
          ParameterFields Pfs = new ParameterFields();
          ParameterDiscreteValue Pdv = new ParameterDiscreteValue();
          Pf.Name = "@idordenrecibida"; //nombre del parametro
          Pdv.Value = 8;
          Pf.CurrentValues.Add(Pdv);
          Pfs.Add(Pf);
          crystalReportViewer1.ParameterFieldInfo = Pfs;
          oRep.Load(@"..\..\OrdenReport.rpt");
          crystalReportViewer1.ReportSource = oRep;
  </code></pre>
  
  <p>And this is the design of the form:</p>
  
  <p><img src="https://i.stack.imgur.com/Eue4M.jpg" alt="enter image description here"></p>
  
  <p>The way I followed the Wizard:</p>
  
  <p><img src="https://i.stack.imgur.com/81enH.jpg" alt="enter image description here">
  <img src="https://i.stack.imgur.com/kzVxR.jpg" alt="enter image description here">
  <img src="https://i.stack.imgur.com/z3OnY.jpg" alt="enter image description here">
  <img src="https://i.stack.imgur.com/VUBRo.jpg" alt="enter image description here">
  <img src="https://i.stack.imgur.com/th8Pd.jpg" alt="enter image description here"></p>
  
  <p>If I select the "no repeat" option in designer, "Equipos" shows perfectly, but "Servicios" is still showing duplicates. In fact, the total number of "Equipos" is the times that "servicios" is duplicated. I tried modifying the relationships but the duplicates are still appearing.
  How could I have in that report the same data than the "exec" without mistakenly repeating the same rows?? Thanks!!</p>
  
  <p>EDIT:</p>
  
  <p>I found that the data are showing duplicate only when I want to show the data of the two tables together, so when I delete from the designer the fields of the table servicios:</p>
  
  <p><img src="https://i.stack.imgur.com/uwPpt.jpg" alt="enter image description here"></p>
  
  <p>And then, I do control + Z, I select the other half part (which corresponds to table equipos) and I press supr. And it shows:</p>
  
  <p><img src="https://i.stack.imgur.com/Qc2QZ.jpg" alt="enter image description here"></p>
  
  <p>But if I want to show the two together duplicates the fields of one of the two tables. I tried moving to another section, but then only shows ONE file, not the 2 or 3 that has to show.</p>
  
  <p>What can I do to show them in the same report properly??</p>