The data are shown repeated

Comments

• Anu de Deus Hampshire, UK

  January 2010 edited 4:25PM

  I think the main problem is in your query.
  The easier solution would be to group it in a way that it will show one record per line as you want it in the report, and all should be fine.
  Your report will show one line per record, so if your query is returning repeated data, it will only reflect that, unless you change your report.
  I'm afraid I don't have enough time to help you more than that, I hope it gives you some ideas.
  
  
  
• elarys

  January 2010 edited January 2010

  I did a query for page
  
  <!--sql--><div class='sqltop'>SQL</div><div class='sqlmain'><!--sql1--><span style='color:blue;font-weight:bold'>SELECT</span> D.Number, D.PrintDate, D.TotDuty, D.TotTax, S.Importer, S.Broker, S.EstDuty, S.EstiTax,
  <span style='color:green'>FROM</span> <span style='color:orange'>DailyStatements</span> <span style='color:orange'>D
  </span><span style='color:green'>LEFT</span> <span style='color:green'>JOIN</span> <span style='color:orange'>Shipment_ABI</span> <span style='color:orange'>S</span> <span style='color:blue'>ON</span> (D.Number <span style='color:orange'>=</span> S.Number)
  <span style='color:green'>WHERE</span> D.Number <span style='color:orange'>=</span><span style='color:red'>'170925'</span>
  <span style='color:green'>ORDER BY</span> Number <!--sql2--></div><!--sql3-->
  
  <!--sql--><div class='sqltop'>SQL</div><div class='sqlmain'><!--sql1--><span style='color:blue;font-weight:bold'>SELECT</span> <span style='color:blue'>SUM</span>(FeeAmount) Total, C.Description, D.Number, D.PrintDate, D.TotDuty, D.TotTax
  <span style='color:green'>FROM</span> <span style='color:orange'>DailyStatements</span> <span style='color:orange'>D
  </span><span style='color:green'>LEFT</span> <span style='color:green'>JOIN</span> <span style='color:orange'>Shipment_ABIFees</span> <span style='color:orange'>F</span> <span style='color:blue'>ON</span> (D.Number <span style='color:orange'>=</span> F.Number)
  <span style='color:green'>LEFT</span> <span style='color:green'>JOIN</span> <span style='color:orange'>BASICO.dbo.Codes</span> <span style='color:orange'>C</span> <span style='color:blue'>ON</span> (C.Code<span style='color:orange'>=</span>F.FeeCode)
  <span style='color:green'>WHERE</span> D.Number <span style='color:orange'>=</span><span style='color:red'>'170925'</span>
  GROUP BY F.FeeCode, C.Description, D.Number, D.PrintDate, D.TotDuty, D.TotTax,
  <span style='color:green'>ORDER BY</span> Number <!--sql2--></div><!--sql3-->
  
  <!--sql--><div class='sqltop'>SQL</div><div class='sqlmain'><!--sql1--><span style='color:blue;font-weight:bold'>SELECT</span> D.Number, D.PrintDate, D.TotDuty, D.TotTax, M.Entry, M.Source
  <span style='color:green'>FROM</span> <span style='color:orange'>DailyStatements</span> <span style='color:orange'>D
  </span><span style='color:green'>LEFT</span> <span style='color:green'>JOIN</span> <span style='color:orange'>ABI_STMT_MSG</span> <span style='color:orange'>M</span> <span style='color:blue'>ON</span> (D.Number <span style='color:orange'>=</span> M.Number)
  <span style='color:green'>WHERE</span> D.Number <span style='color:orange'>=</span><span style='color:red'>'170925'</span>
  <span style='color:green'>ORDER BY</span> Number <!--sql2--></div><!--sql3-->
  
  This works fine, but changing the WHERE and pass many records
  This shows
  Page 1
  1?? record
  2?? record
  ...
  
  Page 2
  1?? record
  2?? record
  ...
  
  Page 3
  1?? record
  2?? record
  ...
  
  
  And I have to display the report like this:
  1?? record
  Page 1
  Page 2
  Page 3
  
  2?? record
  Page 1
  Page 2
  Page 3
  
  so many records
• gordk St.Catherines On. Canada.

  January 2010 edited 4:25PM

  are you using more than 1 design page?
  or are you trying to group one mdband like the nested groups demo report in the main demo,
  if this is the case then connect your dataset to the band not the page, also
  just use the orderby clause in the query to get the data ordered by the conditions of the headers.