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 sizbut 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

dawnanne
  • Locked
  • Question
Loop through rows in an SSRS table
Replies
0
Views
259
dawnanne
dawnanne
tarikqazza
  • Locked
  • Question
SSRS server connection to datasource fail randomly ( sql server 2016)
Replies
0
Views
813
tarikqazza
tarikqazza
how2trainyourdragon
  • Locked
  • Question
SSRS export report as JSON
Replies
1
Views
955
PeterDimitrov
PeterDimitrov
nomi_ssrs
  • Locked
  • Question
xml column from sql server - used in ssrs
Replies
0
Views
823
nomi_ssrs
nomi_ssrs
Theresajn
  • Locked
  • Question
Collapse all Datasets in Report Data Pane
Replies
0
Views
784
Theresajn
Theresajn

Part and Inventory Search

Sponsor

Back
Top