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 12»»

Problem with grouping in SSRS 2008 Expand / Collapse
Author
Message
Posted Thursday, September 5, 2013 8:31 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 6:19 AM
Points: 698, Visits: 129
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
Post #1491818
Posted Friday, September 6, 2013 9:39 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:35 PM
Points: 272, Visits: 802
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.
Post #1492306
Posted Friday, October 11, 2013 8:30 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 6:19 AM
Points: 698, Visits: 129
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



  Post Attachments 
SSRS Screen.png (15 views, 126.66 KB)
Post #1504037
Posted Friday, October 11, 2013 9:36 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:35 PM
Points: 272, Visits: 802
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?
Post #1504071
Posted Friday, October 11, 2013 11:11 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 6:19 AM
Points: 698, Visits: 129
I tried selecting everything under the sun and still no joy - Joe Wolfe
Post #1504101
Posted Friday, October 11, 2013 1:17 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:35 PM
Points: 272, Visits: 802


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

EJM
Post #1504131
Posted Friday, October 11, 2013 2:09 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 8:18 AM
Points: 562, Visits: 2,617
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



Read this article for best practices on asking questions.
Need to split a string? Try this (Jeff Moden)
Need a pattern-based string spitter? Try this (Dwain Camps)
My blog
Post #1504142
Posted Friday, October 11, 2013 3:50 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, June 4, 2014 6:19 AM
Points: 698, Visits: 129
Yes, exactly....Thank you also for taking the time to respond and help...Joe Wolfe
Post #1504160
Posted Wednesday, October 16, 2013 9:27 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 8:18 AM
Points: 562, Visits: 2,617
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 ) - go talk to the CAT people. They'll figure it out in 30 seconds (they're real good)


-- Alan Burstein



Read this article for best practices on asking questions.
Need to split a string? Try this (Jeff Moden)
Need a pattern-based string spitter? Try this (Dwain Camps)
My blog
Post #1505297
Posted Wednesday, October 16, 2013 10:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 3:35 PM
Points: 272, Visits: 802
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...
Post #1505322
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse