SSRS 2008:  Detail line only shows one row

Jim Horn
Jim Horn used Ask the Experts™
on
SSRS report detail with only one line, design view
Hi All

The detail section of my SSRS report is now generating only the top line.
There's nothing showing in the Row Groups section, and I appear unable to add a group.

Q:  How do I get my detail to print all rows again?

Thanks.
Jim
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Technical MAnager
Commented:
are you using tablix or matirx ?

if its a tablix ..when i checked with your screen shot , i found like you have deleted the Details row and instead of you have added one column before the detail row , thats why its showing one value .(because of this your row group show nothing)

please start from the begining or give me full screen shot
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Author

Commented:
>i found like you have deleted the Details row and instead of you have added one column before the detail row
This looks correct, as I just looked at a backup copy and it has the detail row is there.

Q:  Is there any way to 're-add' the detail row, without re-creating the tablix?
SThayaTechnical MAnager

Commented:
its not possible to re-add the deleted groups ... try undo option from view menu
Jim HornSQL Server Data Dude
Most Valuable Expert 2013
Author of the Year 2015

Author

Commented:
Figured it out.

Select any Textbox >> right click >> Add Group>> Row Group >> Adjacent Above>> Show details Data.

Then repopulate the Details section, and blow away the one that was there before.

Thanks.
Jim

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial