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


Problem with grouping in SSRS 2008


Problem with grouping in SSRS 2008

Author
Message
joe.wolfe
joe.wolfe
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 183
When I create a report in SSRS 2008 and I add a group, the group appears in the object as it should and it shows as a group in the Properties Dropdown but nothing appears in the Grouping Pane. I have tried reinstalling SQL Server and nothing changes.

Joe Wolfe
eric.muller
eric.muller
SSChasing Mays
SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)

Group: General Forum Members
Points: 635 Visits: 1343
Presumably you're talking about adding a group in a table or a matrix?

Can you provide some more detail, or some screenshots or something? Maybe compare what you're seeing with what you think you should be seeing.
joe.wolfe
joe.wolfe
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 183
Thank you for responding to my question and I apologize for taking so long to reply back. I had to have some emergency foot surgery.

I am in fact adding a group as you can see from the attached screen shot.I expect to group to appear on the design surface with the colored indicator and it does. I also expected to see my group in the Group Pane, but is not there. If it helps, I am doing the SSRS exercise in the Stairways.

Thank you
Joe Wolfe
Attachments
SSRS Screen.png (24 views, 126.00 KB)
eric.muller
eric.muller
SSChasing Mays
SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)

Group: General Forum Members
Points: 635 Visits: 1343
Joe -

Presumably you've tried things like selecting the entire tablix and seeing if the groups appear then? Sometimes what appears in those grouping panes below varies based on if you're selecting an individual cell versus a header, row, or the whole table.

Try that, any joy?
joe.wolfe
joe.wolfe
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 183
I tried selecting everything under the sun and still no joy - Joe Wolfe
eric.muller
eric.muller
SSChasing Mays
SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)

Group: General Forum Members
Points: 635 Visits: 1343
Ermm

Try opening that rdl file in Report Builder, what happens then?

EJM
Alan.B
Alan.B
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5390 Visits: 7736
joe.wolfe (10/11/2013)
Thank you for responding to my question and I apologize for taking so long to reply back. I had to have some emergency foot surgery.

I am in fact adding a group as you can see from the attached screen shot.I expect to group to appear on the design surface with the colored indicator and it does. I also expected to see my group in the Group Pane, but is not there. If it helps, I am doing the SSRS exercise in the Stairways.

Thank you
Joe Wolfe



So that I understand your question correctly... You are expecting to see this:



but instead you are seeing just grey where (group1) and details should be. That is the problem correct?

-- Alan Burstein



Best practices for getting help on SQLServerCentral
Need to split a string? Try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL 2012+)
Need a pattern-based splitter? Try PatternSplitCM
Need to remove or replace those unwanted characters? Try PatExclude8K and PatReplace8K.

"I can't stress enough the importance of switching from a 'sequential files' mindset to 'set-based' thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. " -- Itzek Ben-Gan 2001
joe.wolfe
joe.wolfe
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1582 Visits: 183
Yes, exactly....Thank you also for taking the time to respond and help...Joe Wolfe
Alan.B
Alan.B
SSCertifiable
SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)SSCertifiable (5.4K reputation)

Group: General Forum Members
Points: 5390 Visits: 7736
joe.wolfe (10/11/2013)
Yes, exactly....Thank you also for taking the time to respond and help...Joe Wolfe


Sorry for the late reply, I've been traveling and super-busy but have been meaning to get back to this post. I'm sorry to say that I don't have much of a solution, it just looked like people in this thread were not understanding your problem. I have seen other equally weird behavior in BIDS (Business Intelligence Development Studio) that I was fixed by a re-install.

The problem you are having appears to be related to BIDS (if that is what you are using). You said that you tried re-installing SQL Server - did you reinstall BIDS as part of that? Either way you may want to re-install BIDS (e.g. run the installer, do add/remove componants, remove BIDS... run the installer again and add BIDS. You may also check for updates. If you are using full blown Visual Studio instead of BIDS then re-installing SQL Server would not have fixed anything and you may want to re-install Visual Studio.

My world is mostly SSRS these days and, I'll be honest, I just use this stuff and have not installed/configured VS/BIDS in a few years so take what I said with a grain of salt. The best advice I can give is to re-post this problem under Reporting Services 2008 Development with the Title, "Problem with BIDS". I think you'll get a better answer. Hope that helps.

P.S. If you are at SQL PASS (I could not go this year Crying ) - go talk to the CAT people. They'll figure it out in 30 seconds (they're real good)

-- Alan Burstein



Best practices for getting help on SQLServerCentral
Need to split a string? Try DelimitedSplit8K or DelimitedSplit8K_LEAD (SQL 2012+)
Need a pattern-based splitter? Try PatternSplitCM
Need to remove or replace those unwanted characters? Try PatExclude8K and PatReplace8K.

"I can't stress enough the importance of switching from a 'sequential files' mindset to 'set-based' thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code. " -- Itzek Ben-Gan 2001
eric.muller
eric.muller
SSChasing Mays
SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)SSChasing Mays (635 reputation)

Group: General Forum Members
Points: 635 Visits: 1343
FWIW, at no point did I fail to understand the problem.

Still no response as to what happens when the file is opened in Report Builder...
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