Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 1234»»»

Adding a detail row when none exist Expand / Collapse
Author
Message
Posted Wednesday, July 14, 2010 3:26 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 7, 2013 3:33 PM
Points: 74, Visits: 196
I initially thought I would not need detail rows in my VS 2008 BIDS report, and deleted them while keeping the group I needed. Now I realize that I do in fact need a detail row. However, no matter how many right clicks I do, I can't find one that will allow me to insert a detail row. I guess I could start over, but I have done so much work, and it would be nice to know for the future.

To recap, I deleted all my detail rows, and now that I need one, I can't find how to add one in again.

Help????

Thank you.
Post #952147
Posted Wednesday, July 14, 2010 3:49 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 16, 2010 2:00 AM
Points: 44, Visits: 65
Hi,
check the attached image for your reference.


Regards,
Gayathri


  Post Attachments 
ssrs-table.bmp (349 views, 1.28 MB)
Post #952154
Posted Wednesday, July 14, 2010 5:09 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, January 28, 2013 2:23 AM
Points: 74, Visits: 43
I m also expiriencing the same problem(inserting Details on VSS2008 BI) it seems as it has limited properties.and Also grouping are not user friendly like previous virsions
Post #952183
Posted Wednesday, July 14, 2010 5:41 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 7, 2013 3:33 PM
Points: 74, Visits: 196
Thank you for your answer, however, in VS 2008 there is no layout tab. Only design and preview.
I would assume that the add detail row is somewhere, but I just can't find it.

Thanks again for your reply.
Post #952207
Posted Wednesday, July 14, 2010 5:42 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:33 AM
Points: 213, Visits: 771
Select any of the rows in the table, right click and then click on the detail rows option.
Post #952210
Posted Wednesday, July 14, 2010 5:47 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 7, 2013 3:33 PM
Points: 74, Visits: 196
Abs-225476 (7/14/2010)
Select any of the rows in the table, right click and then click on the detail rows option.


Ok, I did that, and there is no detail rows option in the list.
Post #952218
Posted Wednesday, July 14, 2010 5:51 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, July 24, 2014 7:33 AM
Points: 213, Visits: 771
can you not just use the undo button, to take you back a step(s)?
Post #952223
Posted Wednesday, July 14, 2010 5:54 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 7, 2013 3:33 PM
Points: 74, Visits: 196
Abs-225476 (7/14/2010)
can you not just use the undo button, to take you back a step(s)?


Like I said, I realized I needed the detail row later in the development. Besides, I had saved the project many times, and exited VS a few times since I deleted the detail row.
But, thank you for answering.
Post #952225
Posted Wednesday, July 14, 2010 7:28 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 12:54 PM
Points: 31, Visits: 152
In the design screen, on your table click at the table head or group to highlight that row, right click and details will be in the second section and slightly greyed out. Just click it and your details row will be restored.

Post #952325
Posted Wednesday, July 14, 2010 7:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Thursday, November 7, 2013 3:33 PM
Points: 74, Visits: 196
Right clicking after selecting the top row gives me the following choices :

Insert Row
Delete Rows
------------
Add Group
Row Group
Row Visibility
------------
Tablix Properties


Nothing regarding detail rows.
Post #952344
« Prev Topic | Next Topic »

Add to briefcase 1234»»»

Permissions Expand / Collapse