April 8, 2008 at 12:00 pm
I have a report that I inherited that is in SSRS 2000. The inbound data is sequenced exactly as we want it to appear in the report but the original author grouped on the same field thinking that would help somehow. The report now doesn't display the data in the correct sequence (long story). Seems to me if the data is displaying correctly in the Data View (and it is) then simply removing the Group should give me the data reporting in the sequence in which it is presented. However, I can't seem to either find a way to remove the Group or change the sequencing of the Group to use the appropriate field.
I really don't want to rewrite this report from scratch just to get rid of the grouping.
Any help is greatly appreciated.
April 16, 2008 at 6:28 am
I assume that the report is using a Table, if so, click on the table to select it, then right click and select properties. In the properties window select the groups tab and in here you can remove all the groups just by highlighting and removing.
If the report is not using a table, or it is using multiple objects then it might be a little more complex. In this case it is probably using a list box that is wrapped around all of the objects that are grouped. You should be able to identify this by selecting the box that wraps around all objects and then going to the properties, the name might be something like ListBox1 etc. If this is the case then the properties of the list box will have an item called Grouping, my advice at this stage would be to remove the list box completely if all you want to do is to print a list of values. Be careful though, you should move all objects outside of the list box before removing the list box!!
Let me know if any of these help.
Good luck,
Nigel West
UK
April 16, 2008 at 6:41 am
I ultimately found that solution and hadn't had time to come back and post.
Thanks for the help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply