Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
SSRS Grouping Pane

Answered SSRS Grouping Pane

  • Friday, June 22, 2012 2:12 PM
     
     
    Sign In to Vote
    0

    I've created a report that includes groups, but when I go to the grouping pane, the group information is not listed.  (Nothing is, it just says Row Group and Column Group).  The advanced mode option shows, but changing it does not produce the groups that I have setup on the report. 

    I've uninstalled SQL2008, Reinstalled it (yeah, that was about as much fun as a gut full of pinworms) and installed SP1 to vs2008.  Nothing has changed, though.  I still can't get to the groups to be able to tell them to print on each page.

    Anyone? Anyone?   Anyone?

     

All Replies

  • Friday, June 22, 2012 2:21 PM
     
     
    Sign In to Vote
    0

    Hi

    Send a screenshot and version of SSRS you use (2005 is different to 2008).

    Meanwhile you can also try ssrs tutorial it might contain exact answer but you might find things that will help to do it.

    Regards

    Emil

     
  • Saturday, June 23, 2012 11:33 AM
     
     
    Sign In to Vote
    0

    Emil,

    Thanks for the response.  Nice tutorial page.  It's wonderful that you guys make this informaiton available to others. 

    My issue isn't writing the report, I've written many.  It's that my computer crashed, and when rebuilt, the grouping pane contains no details about the groups on the rport.  Here's a screenshot to show what I'm talking about.

    I've uninstalled and reinstalled SQL2008 added sp2, and loaded the latest service pack for vs2008 (sp1).  Unfortunately, the grouping pane still doesn't contain the information needed.  (Report builder 2.0 does, but it is a dreadful tool)

    John Vander Wagen

     
  • Thursday, June 28, 2012 12:27 PM
    Moderator
     
     Answered
    Sign In to Vote
    0

    Hi John,

    Thanks for your posting.

    From your description, the issue may occur if the Business Intelligence Development Studio (BIDS) component was corrupt during the operating system crash. At this time, I suggest that we repair the BIDS feature to see if it works. For the detailed information, please see:
    How to: Repair a Failed SQL Server 2008 Installation

    Regards,
    Mike Yin  

    TechNet Subscriber Support

    If you are TechNet Subscription user and have any feedback on our support quality, please send your feedback here.

     
  • Monday, May 06, 2013 11:05 PM
     
     
    Sign In to Vote
    0

    Hi John,

    Can you please let me know how you fixed this issue as i am having exact same issue on my home PC.

    Thanks