Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SQL Server Report Builder Repeating Rows

Status
Not open for further replies.
Isai

Isai

Programmer
Oct 28, 2020
1
MX
Hi, I have a report that shows repeating rows. The report is fed from two tables, the idea is that the rows that are being repeated are shown as a detail. In this image I show the correct result, being the row that begins with "PAGO" as header and the rows that begin with "FACTURA" as lines.

reporte_correcto_bazqs4.jpg


The result I am currently getting is the following, where the rows that should be the lines are repeated

reporte_actual_wvubd9.jpg


This is the current design

dise%C3%B1o_actual_zj6s6p.jpg
 
Status
Not open for further replies.

Similar threads

tarikqazza
  • Locked
  • Question
SSRS server connection to datasource fail randomly ( sql server 2016)
Replies
0
Views
536
tarikqazza
tarikqazza
how2trainyourdragon
  • Locked
  • Question
SSRS export report as JSON
Replies
1
Views
655
PeterDimitrov
PeterDimitrov
nomi_ssrs
  • Locked
  • Question
xml column from sql server - used in ssrs
Replies
0
Views
550
nomi_ssrs
nomi_ssrs
Theresajn
  • Locked
  • Question
Collapse all Datasets in Report Data Pane
Replies
0
Views
530
Theresajn
Theresajn
Ashajohn2021
  • Locked
  • Question
Report to give Average # of cases > than 6, 7, 8 days
Replies
0
Views
504
Ashajohn2021
Ashajohn2021

Part and Inventory Search

Sponsor

Back
Top