SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Adding a detail row when none exist


Adding a detail row when none exist

Author
Message
richgator
richgator
Forum Newbie
Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)Forum Newbie (5 reputation)

Group: General Forum Members
Points: 5 Visits: 0
Add a child group to your innermost group. In the group properties for the new group, delete the group expression. The Details icon should appear.
WillC9999
WillC9999
SSC Journeyman
SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)SSC Journeyman (90 reputation)

Group: General Forum Members
Points: 90 Visits: 75
This is farcical. In 2005 this was all easy and clear. It's like MS have actually tried to make 2008 worse.
Even following the add adjacent group workaround the details group appears in the wrong place.
mailvinaym
mailvinaym
Grasshopper
Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)Grasshopper (16 reputation)

Group: General Forum Members
Points: 16 Visits: 33
1) Right click on row and Click Add group
2) Select Add Adjacent Above option
3) Select details "Show Detail data" and do not select anything in group by
4) Copy the columns from below row where all dataset values were selected already by selecting just you do in Excel.
5) Paste it in new row above
6) now done
falgar23
falgar23
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 14
I'm not sure if this was every properly answered for you. What I do is view the Code (F7) then add <DataElementName>Detail</DataElementName> between the Group tags. You have to make sure there are no GroupExpression tags...because then it is not really a detail line anymore.

Hope this makes sense and helps.
josesan43
josesan43
Grasshopper
Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)Grasshopper (19 reputation)

Group: General Forum Members
Points: 19 Visits: 0
Right click on the row table, select add adjacent group below and select show detail section.
Note: Do not add a group field on the group by option, leave blank.
That will add a detail row on your tablix Smile
Ravjeet Singh
Ravjeet Singh
SSC Rookie
SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)SSC Rookie (31 reputation)

Group: General Forum Members
Points: 31 Visits: 275
This is an old post, but I think it is worth sharing. I hope this helps. I too had the same scenario and fix was
Right Click on the Group > Row Group > Adjacent Below > Show Detail Data.
chris.stuart
chris.stuart
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1174 Visits: 808
veeren4urs (8/5/2010)
Hi,

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

Please ignore if you are not looking for this.

Thanks.
Veeren Smile



Thanks for sorting out the problem!! :-D:-D
sharonsql2013
sharonsql2013
Ten Centuries
Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)Ten Centuries (1.3K reputation)

Group: General Forum Members
Points: 1268 Visits: 1265
I tried this sometime back... Hope it helps you

https://msdn.microsoft.com/en-us/dd220470.aspx
ndiro
ndiro
SSC-Enthusiastic
SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)SSC-Enthusiastic (152 reputation)

Group: General Forum Members
Points: 152 Visits: 216
If i have understand try this:

1) Click Add Group --> Child Group from your group header row (as shown in Img1.png)
2) Select "Show detail data" radio button in next pop-up form (as shown in Img2.png)

That do the trick.
Attachments
Img1.png (18 views, 15.00 KB)
Img2.png (13 views, 33.00 KB)
yrandhir
yrandhir
SSC Rookie
SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)SSC Rookie (33 reputation)

Group: General Forum Members
Points: 33 Visits: 2
Hi,

This link describes how to add details group.

Thanks,
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search